View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jnc[_2_] jnc[_2_] is offline
external usenet poster
 
Posts: 2
Default 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