Taking hours to save excel file

[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

 

[Howard Kaikow]

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

Make sure that no formulae are being updated when you Save the file.

 

[Anna Rajan]

No we get the values from a table and are populated in the grid.
Thanks for the response

 

[Peter T]

Is the delay (obtaining and then) populating 32Mb of data into cells, or is
it merely saving the workbook to disc.

Regards,
Peter T

 

[James Snell]

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?

 

[Anna Rajan]

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

 

[James Snell]

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?

 

[Anna Rajan]

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