Jump to content
Developer Wiki and Function Reference Links Read more... ×
Matster

Updating Record from Excel Spreadsheet

Recommended Posts

Is it possible to update an object or symbols record from an Excel document?

 

I was thinking, I could name the object and it would update the record with the reliant information in the spreadsheet.

Share this post


Link to post

If the excel file is saved as a .csv, you can use the nodes in the File I/O category to pull information from it.

I don't have any examples handy, but I'll make a note to try to get something simple together.

  • Like 2

Share this post


Link to post

I might be able to put the information into a vectorworks worksheet, is it easier to reference a worksheet embedded into the drawing file? although, I'm not clear how to do that either.

Share this post


Link to post

There currently aren't nodes for native worksheets in the default content, though I've also written a handful of those. Either way, we can get information in, so it's whatever you think will work best for you!

Share this post


Link to post
On 4/11/2019 at 6:59 AM, Marissa Farrell said:

If the excel file is saved as a .csv, you can use the nodes in the File I/O category to pull information from it.

I don't have any examples handy, but I'll make a note to try to get something simple together.

A tool that lets you easily link (and update) records to spreadsheets, especially something on the cloud like google sheets, would be a huge win for vectorworks! But I would settle linking to a .csv on our company server as a good starting point. @Marissa Farrell, please pursue this if you can!

 

Thanks,
Matt

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

 

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.

×