After I fixed that, it adds a few columns of and calculates data for one workbook, it reads 21600 cells, reads another 21600 cells, adds a column of data and sometimes rows to 16 sheets in another...
Type: Posts; User: aussiemcgr
After I fixed that, it adds a few columns of and calculates data for one workbook, it reads 21600 cells, reads another 21600 cells, adds a column of data and sometimes rows to 16 sheets in another...
Well I suspect I found the issue. If I'm correct, the issue isnt with the loops but the two lines after it.
It would seem that:
workBook.setColWidthAutoSize(c,true);...
Ok, I am using SmartXLS to write excel sheets and I have one group of loops that takes a rediculous amount of time to run. Much more so than I would expect. Here is the code for my current set of...