How to optimize massive cellStyle setting

Chandler Zhang <[email protected]> Tue, 11 Jul 2023 10:34:21 +0800

Newsgroups	gmane.comp.jakarta.poi.user
Message-ID	<CALmy-xp_rhBQtRifTtbeVJjgnv9wutAvS6yV2D3BAzc8opAaQQ@mail.gmail.com>

Hi,

I am using poi(5.2.3) to export 200 sheets in a workbook (xssf). But the
procedure is too slow for me.

For each sheet, there are more than 1000 cells need to set cellStyles. Each
row has the same cellStyle.

Now, I create every cell and set its cellStyle. It seems too slow and most
time cost on setting cellStyle.

Any batch API or suggestions to  optimize this situation?

Thanks&Regards,

Chandler