This project has moved. For the latest updates, please go here.

Performance problem when formatting rows

Oct 26, 2013 at 8:42 PM
I can generate an excel document using 42 input records generates ~4368 rows ( and 32 columns) of data in about 2 minutes.

There are 19 different types of rows and I need to merge different column based on a value in the first column, i.e., value 1, 5, 6, 11, 12: merge columns 4 through 36, value 2 or 3: merge columns 4/5, 6/7,/8/9,... 31/32.

I tried merging as I created the rows and looping through each of the rows but it takes ~30 Minutes to format.

Is there a way to make this any faster?