Re: Export DataSet to Excel

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Andibevan (andibevan_at_remove-to-prevent-spam-hotmail.com)
Date: 03/18/05 

Date: Fri, 18 Mar 2005 15:44:26 -0000

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" <MiniMike@discussions.microsoft.com> wrote in message
news:545F0C2C-8839-4846-B10A-EB24F95DCDDD@microsoft.com...
> 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 !

Relevant Pages

  • Re: Export DataSet to Excel
    ... > should be faster to copy all of your data rows in one go to excel. ... > it is finished as it seems to take up a lot of processing power. ... >> I'm looping through my datarows, adding them one by one to the file. ... seems to open when i open excel whilst ...
    (microsoft.public.excel.programming)
  • Re: # of working days between receipt & complete
    ... There is no way for these functions to know /your/ work schedule, especially when it comes to excluded holidays and other exceptions specific to your organization. ... I would do the work in Excel. ... Resort the whole thing so the data rows are contiguous. ... DateIndex WorkDay ...
    (microsoft.public.access.queries)
  • Export DataSet to Excel
    ... I'm exporting a .Net dataset to an Excel file, ... I'm looping through my datarows, adding them one by one to the file. ... seems to open when i open excel whilst looping. ...
    (microsoft.public.excel.programming)
  • Create and open Excel spreadsheet from ASP.NET
    ... I found an earlier thread that showed creating an Excel file from ASP.NET, ... However I set the code to create 3 columns and 25 data rows, and it creates a CSV file but when I open the file in Excel the data shows up in one column thus: ... Does anyone know how I could modify the code so I can create separate columns in Excel? ... foreach ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Drag text file to Excel -- stopped working
    ... What version of Excel? ... by simply dragging the .txt file to an open Excel worksheet. ... it brings in the data rows as a single column ...
    (microsoft.public.excel.misc)