Page 1 of 1

Get XLSX data

Posted: Mon Feb 02, 2015 4:57 pm
by luisangelguzmang
Hi, I have several problems trying to get data from an excel 2010 file. There is the error message:
Error message
Error message
1.jpg (22.86 KiB) Viewed 4889 times
My equation is:
Equation
Equation
1.jpg (26.99 KiB) Viewed 4889 times
And the excel file is:
Excel file
Excel file
1.jpg (61.28 KiB) Viewed 4889 times
Can you help me to fix the error?
Thks

Re: Get XLSX data

Posted: Mon Feb 02, 2015 5:41 pm
by Administrator
Can you upload the model and Excel file? Or at least a model with the one parameter and Excel file so we can check the call?

Screenshots are not very useful.

Re: Get XLSX data

Posted: Mon Feb 02, 2015 6:07 pm
by luisangelguzmang
Sure...
Thks

Re: Get XLSX data

Posted: Mon Feb 02, 2015 6:19 pm
by luisangelguzmang
I get the Vensim DDS V6.1

Re: Get XLSX data

Posted: Tue Feb 03, 2015 9:14 am
by Administrator
Try changing
GET XLS DATA('data\Energy_Bogota.xlsx','PE C02','1','B3')
to
GET XLS DATA('data\Energy_Bogota.xlsx','PE CO2','1','B3')

Re: Get XLSX data

Posted: Tue Feb 03, 2015 4:05 pm
by luisangelguzmang
Sooorry