hutool工具的BigExcelWriter导出数据设置excel表的行高不生效

Question

hutool工具的BigExcelWriter导出数据设置excel表的行高不生效

 private void getExcel(List<Map<String, Object>> list)  {
        RequestAttributes requestAttributes = RequestContextHolder.getRequestAttributes();
        HttpServletResponse response = ((ServletRequestAttributes) requestAttributes).getResponse();
        //excel大数据生成
        BigExcelWriter writer=new BigExcelWriter();
        Sheet sheet = writer.getSheet();
        sheet.setDefaultRowHeight((short) 4000);
        writer.write(list);
        response.reset();
        response.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(tableName+".xlsx", "UTF-8"));
        response.setContentType("multipart/form-data");
        try {
            writer.flush(response.getOutputStream());
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            if (writer!=null){
                //关闭writer 释放内存
                writer.close();
            }
        }
    }

效果：

Answer 1

“Devil组”引证GPT后的撰写：
用hutool工具的BigExcelWriter导出数据时，设置Excel表的行高无效的原因可能是因为setDefaultRowHeight方法设置的是默认的行高，而不是指定的行高。要设置指定行的行高，可以使用setRowHeight方法，例如：

for (int i = 0; i < list.size(); i++) {
    Map<String, Object> map = list.get(i);
    Row row = sheet.createRow(i);
    for (int j = 0; j < map.size(); j++) {
        Cell cell = row.createCell(j);
        cell.setCellValue(String.valueOf(map.get("column" + j)));
    }
    row.setHeight((short) 4000); //设置行高
}

用循环为每一行设置了行高。setRowHeight方法接受一个short类型的参数，表示以1/20个点为单位的行高，例如4000表示200个点高的行。