[Enhancement] [Writing Without Creating Objects] how to set column width

[jobmission]

Search before asking

• I searched in the issues and found nothing similar.

Motivation

Writing Without Creating Objects,
Write data directly using List<List> to define headers and data without creating entity classes, but how to set column width?

Solution

No response

Alternatives

No response

Anything else?

this example:
https://fesod.apache.org/docs/write/pojo#writing-without-creating-objects

Are you willing to submit a PR?

• I'm willing to submit a PR!

[alaahong]

Please refer to below sample

 FastExcel.write(fileName)
.registerWriteHandler(new SimpleColumnWidthStyleStrategy(200))
.head(head()).sheet("模板").doWrite(dataList());

[jobmission]

[Writing Without Creating Objects]
SimpleColumnWidthStyleStrategy can set a fixed width for all columns; Can automatic column span be set or width be set separately for each column?

[bengbengbalabalabeng]

[Writing Without Creating Objects] SimpleColumnWidthStyleStrategy can set a fixed width for all columns; Can automatic column span be set or width be set separately for each column?

You can use AbstractHeadColumnWidthStyleStrategy to customize.

Like:

class CustomColumnWidthStyleStrategy extends AbstractHeadColumnWidthStyleStrategy {

        private final Map<Integer, Integer> headWidthMap;

        CustomColumnWidthStyleStrategy(Map<Integer, Integer> headWidthMap) {
            this.headWidthMap = headWidthMap;
        }

        @Override
        protected Integer columnWidth(Head head, Integer columnIndex) {
            return headWidthMap.get(columnIndex);
        }
    }

List<List<String>> head = List.of(
           List.of("Number"),
           List.of("Name"),
           List.of("Age")
);

Map<Integer, Integer> headWidthMap = new HashMap<>();
// for "Number"
headWidthMap.put(0, 10);
// for "Name"
headWidthMap.put(1, 20);
// for "Age"
headWidthMap.put(2, 30);

FastExcel.write(file)
                .head(head)
                .registerWriteHandler(new CustomColumnWidthStyleStrategy(headWidthMap))
                .sheet()
                .doWrite(Collections.emptyList());

[jobmission]

Thank you . I will try this later.