dhatim / fastexcel

Generate and read big Excel files quickly
Other
672 stars 122 forks source link

`Worksheet.isCellInMergedRanges` make write slow. #185

Closed jilen closed 1 year ago

jilen commented 2 years ago

For example 10000 rows x 20 cols x 100 merged regions There could be 10_000_000 Worksheet.isCellInMergedRanges iterations.

jilen commented 2 years ago

Possible solution:

ochedru commented 2 years ago

Thanks for your feedback. Indeed, we could use a better data structure for mergedRanges or rethink column width computation, which is not perfect anyway.