Taking hours to save excel file

  • Thread starter Thread starter Anna Rajan
  • Start date Start date
A

Anna Rajan

To save an excel file of about 32.602 MB size it takes 14hrs45min.
Currently it is implemented using threads in VC++.
Here a stingray studio function (OnSaveDocument) is used to save the file in
excel format.
Working on Visual Studio 2003
How can it be reduced to about 4 hrs??
Here before saving the data to the Excel file, the values are populated to a
grid after calculation.
To place the value in the grid we call CGXGridCore:SetValueRange().
Now to improve the performance, I changed it to CGXData:StoreValueRowCol()
to place the values.
Also I tried using LockUpdate() along with this.

But all these did not have any effect.

Please help
 
Anna Rajan said:
To save an excel file of about 32.602 MB size it takes 14hrs45min.
Currently it is implemented using threads in VC++.
Here a stingray studio function (OnSaveDocument) is used to save the file in
excel format.
Working on Visual Studio 2003
How can it be reduced to about 4 hrs??
Here before saving the data to the Excel file, the values are populated to a
grid after calculation.
To place the value in the grid we call CGXGridCore:SetValueRange().
Now to improve the performance, I changed it to CGXData:StoreValueRowCol()
to place the values.
Also I tried using LockUpdate() along with this.

But all these did not have any effect.

Please help
Click to expand...

Make sure that no formulae are being updated when you Save the file.
 
No we get the values from a table and are populated in the grid.
Thanks for the response
 
Is the delay (obtaining and then) populating 32Mb of data into cells, or is
it merely saving the workbook to disc.

Regards,
Peter T
 
36 megs of data is by no means the biggest workbook I've worked with and that
seems like an outrageous time to save. What happens if you rule
stingray/vc++ out & just use Excel to do the save?
 
The delay is for saving the data from the worksheet to excel file.
can you provide me with a VC++ code to save a huge data into excel file
 
Actually - not using vc++ was kind of the point of what I was trying to get
you to do.

Are you saying it's getting the data from VC++ to Excel that's taking the
time and it actually has nothing to do with saving the file at all?
 
The entire code is in VC++....It uses some stingray studio function to save
the data obtained from a table to an excel file. I would like to know if I
can get some way to write huge data into excel file
 
Back
Top