Dear Tom / Administrator,
I have developed a Venapp that in one part, I need to provide the user the ability of defining the file name that he/she wishes to read from (GET XLS DATA). However, MODVAR function just work for constants not strings! Is there any way that I can the problem could be solved?
Best regards,
MODVAR for strings
-
- Super Administrator
- Posts: 4589
- Joined: Wed Mar 05, 2003 3:10 am
Re: MODVAR for strings
Unfortunately there is no way to change strings via MODVAR.
However, you can use
SIMULATE>SPREADALIAS|?alias=filename.xls
or
SIMULATE>SPREADALIAS|?alias=?
However, you can use
SIMULATE>SPREADALIAS|?alias=filename.xls
or
SIMULATE>SPREADALIAS|?alias=?
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Re: MODVAR for strings
Dear Administrator,
Thanks for your reply. I just tried but nothing happened. What excatly these commands do?
Thanks for your reply. I just tried but nothing happened. What excatly these commands do?
-
- Super Administrator
- Posts: 4589
- Joined: Wed Mar 05, 2003 3:10 am
Re: MODVAR for strings
http://www.vensim.com/documentation/ind ... ?25372.htm
If you have
shape sales[shape] := GET XLS DATA('?SHAPEDATA','Sheet2','1','B3')
then
SIMULATE>SPREADALIAS|?SHAPEDATA=filename.xls
will substitute "?SHAPEDATA" with "filename.xls"
If you have
shape sales[shape] := GET XLS DATA('?SHAPEDATA','Sheet2','1','B3')
then
SIMULATE>SPREADALIAS|?SHAPEDATA=filename.xls
will substitute "?SHAPEDATA" with "filename.xls"
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559