gdxxrw failure when writing to Excel sheet that has a pivot table over it

Hi

I have some some gdxxrw gams code which has worked fine for a long
time, it reads in a .gdx file and dumps the results out into an excel
workbook.

Recently we wanted to add pivot charts/tables over one of the output
data tables. So I have defined a pivot table across the block of data
which is being exported from the .gdx into the Excel workbook.

Now the gdxxrw fails, I get a generalised Windows error dialog popping
up which says:
“gdxxrw.exe has encountered a problem and needs to close. We are
sorry for the inconvenience”

In my DOS window I also get the following message:
“Exception not caught: Call was rejected by callee”

I have tried to write a gdx log file and have trace=3, but the error
seems to stop it writing much to this file, all I get is:
GDXXRW Dec 24, 2007 WIN.FR.NA 22.6 003.000.000.vis
Delphi
Excel version 11.0
Input file : C:\Orbit\Current\CRA_PH\PEPPY\Results\GDX
\GenericSummary.gdx
Output file: C:\Orbit\Current\CRA_PH\PEPPY\Results\GenericSummary.xls
Exception not


Is this a known issue? Is there a cure?
Running GAMS 22.6

Thanks in advance
AndyC
–~–~---------~–~----~------------~-------~–~----~
To post to this group, send email to gamsworld@googlegroups.com
To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en
-~----------~----~----~----~------~----~------~–~—

\

Andy,

Using the RWait parameter could address this issue.

After loading the file, we introduce a delay before asking Excel to do anything.

This parameter was introduced with version 23.0 of the GAMS system.

–Paul

On Fri, Jul 31, 2009 at 12:52 AM, AC wrote:

Hi

I have some some gdxxrw gams code which has worked fine for a long
time, it reads in a .gdx file and dumps the results out into an excel
workbook.

Recently we wanted to add pivot charts/tables over one of the output
data tables. So I have defined a pivot table across the block of data
which is being exported from the .gdx into the Excel workbook.

Now the gdxxrw fails, I get a generalised Windows error dialog popping
up which says:
“gdxxrw.exe has encountered a problem and needs to close. We are
sorry for the inconvenience”

In my DOS window I also get the following message:
“Exception not caught: Call was rejected by callee”

I have tried to write a gdx log file and have trace=3, but the error
seems to stop it writing much to this file, all I get is:
GDXXRW Dec 24, 2007 WIN.FR.NA 22.6 003.000.000.vis
Delphi
Excel version 11.0
Input file : C:\Orbit\Current\CRA_PH\PEPPY\Results\GDX
\GenericSummary.gdx
Output file: C:\Orbit\Current\CRA_PH\PEPPY\Results\GenericSummary.xls
Exception not

Is this a known issue? Is there a cure?
Running GAMS 22.6

Thanks in advance
AndyC




\