Reading column from excel

Almeida · Post by **Almeida** » Mon Jul 07, 2003 8:50 am

I have Vensim PLE Plus.
I would like to be able to read a column from excel to use the values in a model variable.
For instance: Workbook Demand, Sheet yearly, 12 values in column C, i.e. the monthly values for electricity demand for a specific load.
Thanks for any suggestions.

Post by **Administrator** » Mon Jul 07, 2003 12:28 pm

Hello,

I moved the post here as it is a more appropriate place for it. I hope you do not mind.

You need to look at the functions
GET XLS DATA and GET XLS CONSTANTS.

If you go to the index at the Vensim documentation website,
http://www.vensim.com/documentation/vensim.htm
Type in GET XLS and you will see the functions.

They are very easy to use.

Hope this helps,

Tony.

[Edited on 7-7-2003 by Administrator]

Post by **Administrator** » Tue Jul 08, 2003 9:41 am

Also, to get data from a column and not a row, the 'time row or col' part of the function chances. If you put in an "A" then Vensim knows you are looking for a column of data, if you put in a "1", Vensim will look for a row.

Tony.