java获取xlsx文件内容
通过apach包里自带的的Workbook来读取xlsx表格中的内容,解析做相应处理。
// An highlighted block
public class Test
{
/**
* main方法
*
* @param args
* main方法参数
*/
public static void main(String[] args) {
XSSFWorkbook xssfWorkbook = null;
try {
xssfWorkbook = new XSSFWorkbook(new File(""));
}
catch (InvalidFormatException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
XSSFSheet sheet = xssfWorkbook.getSheetAt(0);
int firstRowNum = sheet.getFirstRowNum();
int lastRowNum = sheet.getLastRowNum();
for (int i = firstRowNum + 1; i <= lastRowNum; i++) {
XSSFRow row = sheet.getRow(i);
int firstCellNum = row.getFirstCellNum();
int lastCellNum = row.getLastCellNum();
for (int j = firstCellNum; j < lastCellNum; j++) {
XSSFCell cell = row.getCell(j);
String cellString = cell.toString();
System.out.println("cellString:" + cellString);
}
}
}
}