今天在工作中碰到了一个问题,用easypoi导出excel的时候,实体中BigDecimal类型的属性设置了对应的格式为saleAmount.setNumFormat(&quot;#.00&quot;);,同时设置类型为double,但是导出时excel还是显示单元格格式为文本,我想问如何设置单元格格式为数值或者日期等类型呢?代码如下:```public class Main { public static void main(String[] args) { File file = new File(&quot;D:\\kake_work\\excel\\excel_test1.xlsx&quot;); mkdir(file); int size = 10; try (OutputStream outputStream = Files.newOutputStream(file.toPath())) { ExportParams params = new ExportParams(); params.setSheetName(&quot;订单页&quot;); params.setType(ExcelType.XSSF); List<OrderReport> list = new ArrayList<>(); OrderReport report = new OrderReport(); report.setBaseAmountRmb(BigDecimal.valueOf(99.13)); report.setSaleAmount(BigDecimal.valueOf(100.45)); report.setCheckindate(new Date()); OrderReportReq request = new OrderReportReq(); for (int i = 0; i < size; i++) { list.add(report); } List<ExcelExportEntity> dynamicExportColumnSetting = getExcelExportEntities(); Workbook sheets = ExcelExportUtil.exportBigExcel(params, dynamicExportColumnSetting, (queryParams, page) -> { OrderReportReq req = (OrderReportReq) queryParams; int listIndex = page - 1; if (listIndex < size) { List<OrderReport> rows = list; for (OrderReport row : rows) { row.setAdults(1); } return new ArrayList<>(rows); } return null; }, request); sheets.write(outputStream); } catch (Exception e) { System.out.println(&quot;excel导出发生异常&quot;); e.printStackTrace(); } finally { //remove(file); } System.out.println(&quot;excel导出成功!&quot;); } private static List<ExcelExportEntity> getExcelExportEntities() { List<ExcelExportEntity> dynamicExportColumnSetting = new ArrayList<>(); ExcelExportEntity baseAmountRmb = new ExcelExportEntity(&quot;底价CNY&quot;, &quot;baseAmountRmb&quot;); baseAmountRmb.setType(BaseEntityTypeConstants.DOUBLE_TYPE); baseAmountRmb.setNumFormat(&quot;#.00&quot;); dynamicExportColumnSetting.add(baseAmountRmb); ExcelExportEntity saleAmount = new ExcelExportEntity(&quot;售价CNY&quot;, &quot;saleAmount&quot;); saleAmount.setNumFormat(&quot;#.00&quot;); saleAmount.setType(BaseEntityTypeConstants.DOUBLE_TYPE); dynamicExportColumnSetting.add(saleAmount); ExcelExportEntity checkInDate = new ExcelExportEntity(&quot;入住日期&quot;, &quot;checkindate&quot;); checkInDate.setFormat(&quot;yyyy/MM/dd&quot;); //checkInDate.setType(BaseEntityTypeConstants.DATE_TYPE); dynamicExportColumnSetting.add(checkInDate); return dynamicExportColumnSetting; } private static void mkdir(File file) { if (!file.exists()) { if (!file.getParentFile().exists()) { file.getParentFile().mkdirs(); } } } private static void remove(File file) { if (file != null &amp;&amp; file.exists()) { file.delete(); } }}```