Hi everybody !! I'm currently using apache POI to automatically tranfers data from xls file to xlsm file after some process. I have strong executing time constraint and the setters on XSSFCellStyle is very time consuming.
In fact i have files with thousands of cell to transfert and method on boder (SetBorder & SetBorder color) take 3 ms to 5 ms to execution each on 1 cell. In my context 1300 thousands it takes 30 sec to execute. <http://apache-poi.1045710.n5.nabble.com/file/n5715024/XSSFCellStyle_slow.png> In this graph, we can see the most time spend on these methods is in state "waiting". Is it normal for you or not ? Thanks a lot!! -- View this message in context: http://apache-poi.1045710.n5.nabble.com/XSSFCellStyle-method-seems-to-be-slow-tp5715024.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
