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 !

Hi Mike,

If you are able to determine the length (i.e. last row) of your dataset it
should be faster to copy all of your data rows in one go to excel.

On My PC I am able to run a number of instances of Excel at the same time -
you may be able to find a way of running two instances of excel. I find
though that when I am importing text using vba it is safer to leave it until
it is finished as it seems to take up a lot of processing power.

Sorry if this is a bit vague, but it is just a thought.

Regards

Andi


"MiniMike" wrote in message
...
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 !

Thanks !
Could you give some little more info on how to copy all rows in one go?
Determining the length of the dataset is no problem ...
dataset.tables(0).rows.count should do the trick, doesn't it ...?

"Andibevan" wrote:

Hi Mike,

If you are able to determine the length (i.e. last row) of your dataset it
should be faster to copy all of your data rows in one go to excel.

On My PC I am able to run a number of instances of Excel at the same time -
you may be able to find a way of running two instances of excel. I find
though that when I am importing text using vba it is safer to leave it until
it is finished as it seems to take up a lot of processing power.

Sorry if this is a bit vague, but it is just a thought.

Regards

Andi


"MiniMike" wrote in message
...
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 !