Writing to Excel

[shers]

Hi,

I have done some code to write to Excel from a String Array of 3 items. These 3 items are written to columns 1, 2, 17 or 3, 4, 17, depending on the value of the 3rd item in the array. For certain Excel files, this is taking too long to write. Is it because I'm writing cell by cell? Is there any other way of writing faster to Excel?

Thanks

 

[giskumar]

Hi,

Try to Create an Excel addin and Load it to the excel. Create a formula with addin function for the required cells to get result.

Kumar.