查看下面的代码,并帮助我获得单行中的多列值
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Iterator;
public class ApachePOIExcelRead {
public static String cellValue = "";
private static final String FILE_NAME = "./DealerExcel.xlsx";// ./PoiWorkbook.xlsx
public static void main(String[] args) throws IOException {
XSSFWorkbook workbook = new XSSFWorkbook(FILE_NAME);
XSSFSheet sheet = workbook.getSheetAt(0);
ArrayList<String> columndata = null;
Iterator<Row> rowIterator = sheet.iterator();
columndata = new ArrayList<>();
while (rowIterator.hasNext()) {
Row row = rowIterator.next();
Iterator<Cell> cellIterator = row.cellIterator();
while (cellIterator.hasNext()) {
Cell cell = cellIterator.next();
if (row.getRowNum() > 0) { // To filter column headings
if (cell.getColumnIndex() == 0) {// To match column
// index
switch (cell.getCellType()) {
case Cell.CELL_TYPE_NUMERIC:
columndata.add(cell.getNumericCellValue() + "");
System.out.println("Number: "
+ cell.getNumericCellValue());
break;
case Cell.CELL_TYPE_STRING:
columndata.add(cell.getStringCellValue());
System.out.println("String: "
+ cell.getStringCellValue());
break;
}
System.out.println();
}
}
}
}
}
}
发布于 2018-08-14 08:57:47
下面是我们如何读取一行中所有列的方法:
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("Sheet1");
sheet = wb.getSheetAt(0);
for (Row myrow : sheet) { //iterating row by row
for (Cell mycell : myrow) {
//Iterating through all the columns in a row
}
}
https://stackoverflow.com/questions/-100002118
复制相似问题