Auto adjust column width for excel writing

mini-software / MiniExcel

Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)

https://www.nuget.org/packages/MiniExcel/

Apache License 2.0

2.81k stars 342 forks source link

Auto adjust column width for excel writing #682

Closed Discolai closed 15 hours ago

Discolai commented 1 month ago

Excel Type

[x] XLSX
[x] XLSM
[ ] CSV
[ ] OTHER

I have been looking into implementing an autosize feature in a similar fashion as dimensions are handled in fastmode.

Fastmode changes the filemode of the zipfile to support seeking. Is there a reason why this is not the default? Is it slower?

The autosize feature would require fastmode to be enabled. So I want to remove the fastmode option and make it the default behaviour if you have no objections @shps951023

oukene commented 1 month ago

I have a question, How did you use autofit by adjusting fastmode?

Can you show me an example?

Discolai commented 1 month ago

It is not just adjusting FastMode, but some internal changes to how things are written.

My branch is still a work in process, but I will publish a pr when I think it is ready