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 >
