Hello,

I am having some trouble using GDXXRW to read some values from a

spreadsheet. I want to emphasize that I have a previous version of

this code that functions correctly. However, when I shift values

around/add new parameters to my spreadsheet (and update the cell

reference accordingly), I receive errors along the lines of:

**** There were 12 duplicate entries for symbol ParameterA

1: January,0

2: February,0

3: March,0

4: April,0

5: May,0

6: May,0

7: June,0

8: June,0

9: July,0

10: July,0

Remaining entries skipped

Where ParameterA has a row index and a column index, and the zero

values shown above appear to be the values of the last element of the

column index (i.e. the values in the far left column of Parameter A in

the spreadsheet – not sure this matters) It’s also weird that the

error above lists some months twice, when the spreadsheet only

contains one instance of each.

Furthermore, the parameters that produce errors are not the ones that

have been added or edited. All the syntax is the same for previous

functional version. Only when I add or change locations do I encounter

this problem.

Here’s a simplified example of the routine I am using here:

$onecho > GDXInput.txt

Par=ParameterA rng=Sheet1!A7:B14 Rdim=1 Cdim=1

Par=ParameterB rng=Sheet1!A17:B26 Rdim=1 Cdim=1

Par=ParameterC rng=Sheet1!A29:B31 Rdim=1 Cdim=1

Par=ParameterD rng=Sheet1!A34:B42 Rdim=1 Cdim=1

$offecho

$CALL GDXXRW Input=C:\folder\gdxlink.xlsx @GDXInput.txt

$gdxin gdxlink.gdx

Where gdxlink.xlsx is the spreadsheet with the parameter values and

all the cell references in the instruction file GDXInput.txt are

confirmed correct.

After I get one or several of the errors as described above, I get

“Output gdx file deleted” then errors on the line calling gdxin,

because the file it needs does not exist.

I see that the only other mention of this problem on the board uses

merged cells. To clarify, I have no merged cells in the spreadsheet I

am reading from.

Frankly I have no idea how to proceed. Any advice would be greatly

appreciated. Thanks

\