java如何在ApachePOI中不使用公式单元格获取行数据
我正在开发一个程序,其中excel工作表中的行数据应显示为输出。一个id作为输入,它将映射到特定行以显示输出。我正在java上使用ApachePOI来编写代码。我想在不使用我当前在prog中使用的单元格的情况下显示输出。是否有任何函数可以直接打印行对象的行数据
package exceldata;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.*;
public class exceldata {
private static final String FILE_NAME = "C:\\Users\\agandiko\\Desktop\\data.xlsx";
public static void main(String[] args) {
try {System.out.println("Enter the id:");
Scanner s=new Scanner(System.in);
String field=s.next();
int on=0;
int n=0;
int cc=1;
FileInputStream excelFile = new FileInputStream(new File(FILE_NAME));
Workbook wb = new XSSFWorkbook(excelFile);
DataFormatter formatter = new DataFormatter();
for (int i = 0; i < wb.getNumberOfSheets(); i++) {
System.out.println();
System.out.println();
System.out.println("Data for Sheet"+" "+(i+1));
System.out.println("-----------------------------------");
System.out.println();
System.out.println();
Sheet datatypeSheet = wb.getSheetAt(i);
Iterator<Row> iterator = datatypeSheet.iterator();
int noOfColumns = datatypeSheet.getRow(0).getPhysicalNumberOfCells();
while (iterator.hasNext()) {
Row currentRow = iterator.next();
Iterator<Cell> cellIterator = currentRow.iterator();
while (cellIterator.hasNext()) {
Cell currentCell = cellIterator.next();
Cell k=currentCell;
//getCellTypeEnum shown as deprecated for version 3.15
//getCellTypeEnum ill be renamed to getCellType starting from version 4.0
String val=formatter.formatCellValue(currentCell).toString();
if((val.equals(field)))
{
while(cellIterator.hasNext()){
if(cc==1){System.out.print(formatter.formatCellValue(k).toString()+" ");}
else{currentCell = cellIterator.next();System.out.print(formatter.formatCellValue(currentCell).toString()+" ");}
cc++;
}
// System.out.print(currentRow.toString()+" ");
// currentRow = iterator.next();
// cellIterator = currentRow.iterator();
// on=1;n++;}
//System.out.println(cc);
}
// if(n==noOfColumns){System.out.println();n=0;}
//on=0;
}
cc=1; }
}
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
}
# 1 楼答案
以下是我对用例的理解:查找某个id(代码假定它位于每张表的第一列),如果它与输入的id匹配,则打印整行;下面是解决这个问题的方法(取决于工作表中的数据,可能需要添加一些空检查,但通常它“按原样”工作):