Jump to content

Worksheet Export Checkbox

Recommended Posts



I Created a custom dialog to create several worksheets. On the custom dialog i made a checkbox to export the active worksheet to a .txt file.

I wonder if its possible to make is like: if you check several checkboxes and the "EXPORT TO TXT" checkbox is checked than it wil give me after the sheet is generated the "Export Worksheet" dialog.

Example :


Check the "Total LED" checkbox

Check the "LED Screen 1" checkbox

Check the "EXPORT TO TXT" checkbox

Press "Create"

The Script Creates the worksheet

The Script opens the export setings DoMenuTextByName('Export Worksheet',0);

You store the Export to a destination

The Script will repeat the steps on every checkbox that will be cheked.


Part of the scrip:

                    GetBooleanItem(id, 6, Bool); if Bool THEN DoMenuTextByName('Oaktree ALL LED',0);
                    GetBooleanItem(id, 7, Bool); if Bool THEN DoMenuTextByName('Oaktree LED Screen 1',0);
                    GetBooleanItem(id, 8, Bool); if Bool THEN DoMenuTextByName('Oaktree LED Screen 2',0);


The id of the "EXPORT TO TXT" checkbox is 37.


i hope someone has a solusion.







Export worksheet.JPG

Share this post

Link to post

You’re ultimately going to have to dive deeper into scripting rather than relying on DoMenuTextByName. I suggest having the script retrieve your data and then directly writing the text file. 

VS has commands for reading data from the worksheet, though you may find that reading data directly from the screen objects and writing to your text file is more efficient. (GetRField() will read data from plug-ins)

I would also recommend moving over to python — the built-in routines for working with data and writing to text files is more robust and documented.  

Share this post

Link to post

Thanks for the reply,


I created a workaround


Now it works like i wanted it to work.

Export worksheet txt.JPG

Share this post

Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114


© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

  • Create New...