GET XLS Function

[maxin454]

I use GET XLS function in my vensim model to import data from an external excel spreadsheet. When running the model, the excel spreadsheet also opens up automatically. I'm wondering if there is a way to "NOT" auto run the excel spreadsheet when running the vensim model? Thank you.

maxin

[Administrator]

Have a look at GET DIRECT DATA, that might do what you need.

GET XLS DATA needs the spreadsheet open as it reads via a live link.

Tony.

[maxin454]

Thanks, Tony. But somehow I cannot locate GET DIRECT DATA function in the manual. Could you direct me to the right spot?

maxin

[Administrator]

Yes, all easy to find.

http://www.vensim.com/documentation/ind ... t_data.htm
http://www.vensim.com/documentation/ind ... stants.htm
http://www.vensim.com/documentation/ind ... ookups.htm

Hope this helps.

Tony.

[maxin454]

I have Vensim DSS 5.7a and I do not find GET DIRECT DATA function in it. Is the fuction a recent update? Thanks.

maxin

[Administrator]

Ah, yes it is a recent addition.

If you cannot upgrade, you will have to read the data in via another format if you do not want Excel to open.

Tony.