Fastest way of getting data into excel
Hi Everyone
I am writing an app at the moment which has to import a large amount of data (1m + cells) into excel and am currently using the excel object model to do this. I am using the cells value property to do this i.e 'objsheet.Cells(1,1).value = x'
I have noticed that usings the cell object model seem to be very slow is there a faster way of getting the data into excel
Cheers.....Ji
|