Reading column from excel

Use this forum to post Vensim related questions.
Post Reply
Almeida
Junior Member
Posts: 4
Joined: Mon Jul 07, 2003 8:41 am

Reading column from excel

Post by Almeida »

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.
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Post by Administrator »

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]
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Post by Administrator »

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.
Post Reply