Get XLSX data

luisangelguzmang · Post by **luisangelguzmang** » Mon Feb 02, 2015 4:57 pm

Hi, I have several problems trying to get data from an excel 2010 file. There is the error message:

: Error message; 1.jpg (22.86 KiB) Viewed 4888 times

My equation is:

: Equation; 1.jpg (26.99 KiB) Viewed 4888 times

And the excel file is:

: Excel file; 1.jpg (61.28 KiB) Viewed 4888 times

Can you help me to fix the error?
Thks

Post by **Administrator** » Mon Feb 02, 2015 5:41 pm

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.

luisangelguzmang · Post by **luisangelguzmang** » Mon Feb 02, 2015 6:07 pm

Sure...
Thks

luisangelguzmang · Post by **luisangelguzmang** » Mon Feb 02, 2015 6:19 pm

I get the Vensim DDS V6.1

Post by **Administrator** » Tue Feb 03, 2015 9:14 am

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')

luisangelguzmang · Post by **luisangelguzmang** » Tue Feb 03, 2015 4:05 pm

Sooorry

Ventana software support forum

Get XLSX data

Get XLSX data

Re: Get XLSX data

Re: Get XLSX data

Re: Get XLSX data

Re: Get XLSX data

Re: Get XLSX data