把集合数据放到excel的第九行第一列前面空白

最新推荐文章于 2024-08-08 18:29:13 发布

一个处女座的暖男程序猿

最新推荐文章于 2024-08-08 18:29:13 发布

阅读量35

点赞数 1

文章标签： excel

本文链接：https://blog.csdn.net/weixin_46597615/article/details/141023056

版权

    public static Sheet convertDataListToSheetsa(List<Map<String, Object>> dataList) {
        Workbook workbook = new XSSFWorkbook();
        Sheet sheet = workbook.createSheet();

        for (int i = 0; i < 8; i++) {
            sheet.createRow(i);
        }

        int rowIndex = 8;
        for (Map<String, Object> data : dataList) {
            Row row = sheet.createRow(rowIndex++);
            int cellIndex = 0;
            for (Map.Entry<String, Object> entry : data.entrySet()) {
                Cell cell = row.createCell(cellIndex++);
                setCellValues(cell, entry.getValue());
            }
        }

        return sheet;
    }

    private static void setCellValues(Cell cell, Object value) {
        if (value instanceof String) {
            cell.setCellValue((String) value);
        } else if (value instanceof Number) {
            cell.setCellValue(((Number) value).doubleValue());
        } else if (value instanceof Boolean) {
            cell.setCellValue((Boolean) value);
        } else if (value instanceof java.util.Date) {
            cell.setCellValue((java.util.Date) value);
        } else {
            cell.setCellValue(value != null ? value.toString() : "");
        }
    }