解析sheet页,for嵌套,遍历每一行,再遍历每一个单元格
百度poi就行,找个demo
这样:
List<Object[]> list = new ArrayList<Object[]>();
HSSFWorkbook workbook = new HSSFWorkbook(io);
int sheets = workbook.getNumberOfSheets();
for(int i =0;i<sheets;i++){
HSSFSheet sheet = workbook.getSheetAt(i);
for(int j=1;j<sheet.getPhysicalNumberOfRows();j++){
HSSFRow row = sheet.getRow(j);
Object[] arr = new Object[row.getPhysicalNumberOfCells()];
for (int k = 0; k < row.getPhysicalNumberOfCells(); k++) {
arr[k] = getformatCellValue(row.getCell(k));
}
list.add(arr);
}
}
return list;
cell可以识别文档中的数据类型,比如日期,字符串,或者数字,根据需要进行转换 如果要封装成Object[]那就(Object)强转就可以了。
HSSFWorkbook wb = new HSSFWorkbook(new POIFSFileSystem(new BufferedInputStream(source)));
Sheet sheet = wb.getSheetAt(1);
Row row = sheet.getRow(1);
Cell cell = row.getCell(1);
(1)Date date = cell.getDateCellValue();
(2)String string = cell.getStringCellValue();
(3)double double1 = cell.getNumericCellValue();