Jump to content

automated export to excel


Recommended Posts

@Pat Stanford @Luka Stefanovic

Hi everyone,

 

I got a question from one of my material booking colleagues, is it possible to automatically export worksheets to excel files? So for instance, when I update the worksheets in a drawing, it automatically updates an excel sheet connected to that.

I've read about referencing a file when importing an excel file as a worksheet, for no apparent reason I'm assuming this might work the other way as well?? Because to me it looks like when working with an imported worksheet, the excel file is leading, and I can't recalculate my Vectorworks drawing correctly when counts in my drawing change.

 

thanks for any tips or answers on this,

 

Peter

Edited by Peter Telleman
Link to comment

@Jesse Cogswell

Hi Jesse,

 

read a thread which mentioned your tool, does that tool do what I'm looking for? Again, what I'm looking for is something that updates the counts in worksheets in Vectorworks to an excel file. So basically, when I recalculate my worksheets in Vectorworks, it refreshes the count in my excel sheet (or it does with a mouseclick somewhere). I don't mind if the initial setting up of this takes a little time, since we very often work on these projects for months.

 

thanks,

 

Peter

Link to comment
  • 2 weeks later...
  • Vectorworks, Inc Employee

Hi @Peter Telleman you can export Vectorworks worksheets to Excel, you can even reference Excel files in Vectorworks models and then push the data from Vectorworks to Excel and vice versa in a two-way data exchange, but you can't do it automatically. References need to be updated and worksheets recalculated, data pushed from Vectorworks to Excel or worksheets exported manually. 

There's no automatic recalculation because if it was doing it that would mean that every time there is a small change in the model, worksheets would be recalculating and if you had a big database model, your machine would be constantly blocked.

  • Like 2
Link to comment

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.

Guest
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.

×
×
  • Create New...