1. 读取xlsx
private static FormulaEvaluator evaluator;
String static void readXlsx(String path) {
try{
// 读取的时候可以使用流,也可以直接使用文件名
FileInputStream is = new FileInputStream(path);
Workbook xwb = new XSSFWorkbook(is);
// 循环工作表sheet
for(int numSheet = 0; numSheet < xwb.getNumberOfSheets(); numSheet++) {
Sheet sheet = xwb.getSheetAt(numSheet);
if(sheet == null) {
continue;
}
// 循环row,如果第一行是字段,则 numRow = 1
for(int numRow = 0; numRow <= sheet.getLastRowNum(); numRow++) {
Row row = sheet.getRow(numRow);
if(row == null) {
continue;
}
// 循环cell
for(int numCell = 0; numCell < row.getLastCellNum(); numCell++) {
Cell cell &