Re: How to optimize massive cellStyle setting

Hi,

Can you share some sample code which triggers the problem?

This would make it easier to take a look for others.

Ideally as simple as possible but still producing the slow writing that you
experience.

Thanks... Dominik.

On Tue, Jul 11, 2023 at 4:34 AM Chandler Zhang <[email protected]> wrote:

> 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
>