最近使用java导入高版本Excel技术,写下以后可能用到。
目前只有POI方式导入。导入POI3.5版本的 相关的jar包。
<!--StartFragment --> public static void main(String[] args) {
XSSFWorkbook xs;
try {
xs = new XSSFWorkbook("D:/ss.xlsx");
XSSFSheet sheet = xs.getSheetAt(0);
XSSFRow rows = null;
String cells = null;
rows = sheet.getRow(0);
// int xsRows = sheet.getPhysicalNumberOfRows();
rows = sheet.getRow(0);
for (int i = 0; i < sheet.getPhysicalNumberOfRows(); i++) {
rows = sheet.getRow(i);
cells = rows.getCell(0).toString();
System.out.println(cells + " : " + rows.getCell(1).toString()
+ " rows:" + rows.getCell(2).toString());
for (int j = rows.getFirstCellNum(); j < rows
.getPhysicalNumberOfCells() - 1; j++) {
// 通过 row.getCell(j).toString() 获取单元格内容,
System.out.print(rows.getCell(j).toString() + " ");
}
System.out.println();
}
} catch (IOException e) {
e.printStackTrace();
}
}