這樣讀取excel時,得到的是結果值,而不是單元格的公式
import cn.hutool.poi.excel.ExcelReader;
import cn.hutool.poi.excel.ExcelUtil;InputStream inputStream = file.getInputStream();
ExcelReader reader = ExcelUtil.getReader(inputStream, 1);
List<List<Object>> list = reader.read();
for (int i = 4; i < list.size(); i++) {List<Object> row = list.get(i);for (int i = j; j < row .size(); j++) {row.get(j);// 這樣得到的值是單元格的值,不是公式}
}
這樣解析excel時,得到的是公式,不是值
import java.io.InputStream;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;InputStream is = file.getInputStream();Workbook workbook = WorkbookFactory.create(is);Sheet sheet = workbook.getSheetAt(1);Row dataRow = sheet.getRow(rowIndex);Cell valueCell = dataRow.getCell(i);// 這樣得到的值是公式,不是單元格的值