Define your styles up front, apply the correct style when you make the cell.
On 1/24/19 4:47 AM, Venkata Sagar Varma Muppala wrote:
Hi, As part of our project, we have to build an excel report, which will have thousands of rows and columns. in this many of the cells in each row will have different cell styling like, text in green color, text in red color, different background fills etc.. I have tried applying CellStyle to each cell in a row. using ..getCell().setCellStyle(). but this operation is consuming lot of time when many rows and many columns exists. As a result, for huge data the excel report itself is not getting downloaded forever. Could some one please suggest a better way to handle this scenario? Thanks, Sagar. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
--------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org