error while getting data from excel

LBD · Post by **LBD** » Thu Mar 30, 2006 4:28 pm

Hi,

In the model that I am making, one of the variables has to read data from excel (constants). In the equation I have added the
GET XLS CONSTANTS'filename.xls','sheetname', 'column name'), but when I try to run the simulation or partial simulation, I get an error saying "Unable to get constant vales." Please advice.

Rafael · Post by **Rafael** » Thu Mar 30, 2006 5:55 pm

Hi,
Perhaps The problem is the Excel R1C1 Letters in the Global optios Settings

When you use the GET XLS CONSTANTS or GET XLS DATA functions Vensim queries Excel for this information. The appropriate format for this query is different for some international versions of Excel.

For check the correct ones letters for your Excel open the spreadsheet xlstest.xls in models\sample\extra and click on the button labeled Get Row and Column Labels (you will need to enable macros).

Rafael

bob@vensim.com · Post by **bob@vensim.com** » Thu Mar 30, 2006 9:44 pm

With older versions you may need to change the R1C1 letters. It is best to update to the latest release that does not have this problem with international versions or Excel.