View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MiniMike MiniMike is offline
external usenet poster
 
Posts: 2
Default Export DataSet to Excel

Hi !

I'm exporting a .Net dataset to an Excel file, using the Excel Object Model.
I'm looping through my datarows, adding them one by one to the file.

I have 2 questions.
* Is there a faster way?
* I'm having a problem when i open excel during the loop: the file that is
processing in the background, seems to open when i open excel whilst looping.
Can i avoid this ?

Thanks !