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