咨询

[swl-123]

fastexcel有没有快速便捷的方法，设置导出的excel有固定的标题行（不是表头）

[alaahong]

Please attach your expectation sample...

[swl-123]

类似这种的

[delei]

Please refer to this and see if it is helpful to you.

@Test
public void writeTest() {
  
    List<List<String>> headers = new ArrayList<>();
    headers.add(Arrays.asList("标题", "姓名"));
    headers.add(Arrays.asList("标题", "年龄"));
    headers.add(Arrays.asList("标题", "学历"));
    headers.add(Arrays.asList("标题", "爱好"));
    headers.add(Arrays.asList("标题", "存款"));
    
    
    FastExcel.write(new File("test.xlsx"))
            .head(headers)  // configure the head
            .sheet()
            .doWrite(Collections.emptyList());
}

[swl-123]

十分感谢🙏，测试没问题想问下目前是只支持这样设置吗

[delei]

It also supports the use of POJO.

@Getter
@Setter
@EqualsAndHashCode
public class ComplexHeadData {
    @ExcelProperty({"标题", "姓名"})
    private String name;
    @ExcelProperty({"标题", "年龄"})
    private int age;
    @ExcelProperty({"标题", "序列"})
    private String degree;
}

[nyc1215]

您好，请问一下如果这个固定的标题行需要单独设置一个样式（与下方表头单元格样式不同），能否通过自行实现AbstractHeadStyleWriteHandler分别设置标题和表头的样式吗？我是需要直接对setHeadCellStyle中的relativeRowIndex进行判断吗？
目前我的解决方案是自定义SheetWriteHandler，然后在afterSheetCreate方法中直接插入新行，再写入表头和数据

[delei]

It is recommended that a new discussion be created to track feedback.

[nyc1215]

sorry, I just created a new discussion.
discussions-490