Jump to content

Hello Community!

This Saturday, April 11, from 9am – 1pm EDT we will be performing maintenance on the Vectorworks Community Board. During this time, the site will be unavailable.

Sign in to follow this  
remarkr

Importing worksheet

Recommended Posts

I'm having rouble importing an Excel worksheet into VW 9.5. I tried saving the original in every format, but when I import it into the worksheet all the info lands in the 1st line.

Can anyone walk me thru this.

Thanks,Robert

Share this post


Link to post

We only support these formats when importing worksheets.

CSV Comma seperated text, Tab delimited text, SLYK, and DIF.

You should be able to select any of these format's from the Excel save dialog.

If this doesnt work, let me know what version/platform you are using excel on and I will check it out.

Matthew GiampapaNNA Technical Support

Share this post


Link to post

You can also copy and paste from your Excel spreadsheet into VW worksheet. The trick is, your have to select the exact number of rows and columns in the VW worksheet that you copied from Excel, or you can select only the upper, left cell in the VW worksheet & then ctl-v to paste.

Share this post


Link to post

oh yea, and don't forget word wrap doesn't exist in Vectorworks worksheet land, which might also be causing problems. If you do have wrapped cells and they do make it in to the worksheet, be prepared for a worksheet that looks like Mr. Jefferson's National Land survey and will cause your cells to spread from Columbia MD to somewhere in Kansas....

Share this post


Link to post

I think this behavior may be a bug, or at least an explained change in the program. I just ran into it myself, importing a tab delimited file from Excel into 9.5.1 under OS X and 9.2.2. The import did not reconize the line endings, so all the numbers were in one row. The same file imported correctly into 8.5.2 under OS 9.2.2. When I changed the line endings to UNIX in BBedit Lite, it imported fine into 9.5.1.

I submitted this in a bug report, but haven't heard anything back.

Share this post


Link to post

Hey chris:

You would think with the increasing number of programs out there that do dynamically update, that this would have been a priority in the last release. One need only check with the likes of Indesign 2.0 or Archicad to see how powerful and useful this feature is.

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.

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.

Sign in to follow this  

 

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