This project has moved and is read-only. For the latest updates, please go here.

How to insert to cell by array

Aug 20, 2013 at 11:57 AM
Dear All,

I have created the excel where about 2000 row and 100 column.
I set value by cell by cell. It take 10 minute to finish the excel.
May i know is there any way I can set value to multiple cell using array.

For example

obj[] abc = new obj[]{ "1", "2", "3", "4"};
ws.Cells["A1:D1"].Value = abc;

Regards,
Nicholas
Aug 26, 2014 at 3:50 PM
+1 for this request. I didnt like to create excel-files with COM at all, but assigning an array to a range was pretty sweet ;)