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 CGXGridCoSetValueRange().
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" <Anna wrote in message
...
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 CGXGridCoSetValueRange().
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.

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

"Howard Kaikow" wrote:

"Anna Rajan" <Anna wrote in message
...
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 CGXGridCoSetValueRange().
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.

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

Regards,
Peter T

"Anna Rajan" <Anna wrote in message
...
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 CGXGridCoSetValueRange().
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

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" wrote:

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 CGXGridCoSetValueRange().
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

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" wrote:

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" wrote:

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 CGXGridCoSetValueRange().
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

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" wrote:

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" wrote:

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" wrote:

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 CGXGridCoSetValueRange().
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

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

"James Snell" wrote:

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" wrote:

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" wrote:

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" wrote:

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 CGXGridCoSetValueRange().
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