MENU>VDF2XLSX: specify sheet?

Use this forum to post Vensim related questions.
Post Reply
kleemax
Senior Member
Posts: 125
Joined: Tue Jan 26, 2016 3:50 pm
Vensim version: PRO

MENU>VDF2XLSX: specify sheet?

Post by kleemax »

The help file for MENU>VDF2XLSX just refers to MENU>VDF2Tab. Hence it is not clear if the excel version of the command has additional possibilities compared to the tab version.
Excel-files can have multiple sheets. When using command scripts for exporting data to xlsx from several runs, it would be very handy to have these runs not as separate xlsx files but as separate sheets in one xlsx file. I wonder if that is already possible.
If not: you may treat this as a feature request;-)
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: MENU>VDF2XLSX: specify sheet?

Post by Administrator »

It's not already possible. I'm not sure if the library we use to create XLSX files allows appending to an existing file. I've raised it as a feature request so will let you know as soon as it is looked into in detail.
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
tomfid
Administrator
Posts: 3804
Joined: Wed May 24, 2006 4:54 am

Re: MENU>VDF2XLSX: specify sheet?

Post by tomfid »

It's been a while since I've done this, but isn't it possible if you use a .frm file?
Post Reply