Jump to content

Hello Community!

This Thursday, October 21st, from 6 pm to 7 pm EDT, we will be performing an update on the Vectorworks Community Board. During this time, the site will be unavailable.

Paste ExCel Spread sheets


Recommended Posts

Brian O suggests:

Try the "Import" feature in VectorWorks to import a Worksheet. First, save the Excel file as a copy with a comma delimited format or a tab

delimited format. Next, create a new worksheet in your file. Use the Import Worksheet command (File-Import-Import Worksheet).

I want to copy and paste directly from the cells I choose and not go through the steps to save my excel spreadsheet as a separate file for the purposes of exporting data to VW. My Excel file is a workbook with many sheets and the files are typically revised and updated many times after creation... no different from a CAD drawing file which one works on for many hours days and weeks. The approach Brian suggests would create a file management nightmare and take up hard drive space and many extra steps.. cost SOMEONE time and MONEY. This is NOT an acceptable answer.

Why can I copy and paste on a MAC and why can't I copy and paste on PC????

The problem lies in the software me thinks and the solution lies in the fixing of a bug perhaps????

defjef

Link to comment

I work on VW8.52 on a G4 and Dell866L... both have more 512mb of ram. I am able to copy and paste spread sheets on the MAC version of VW, but when I attempt the same on the PC it pastes as a bitmap which looks god awful. The MAC paste has every line and text as a separate object. I have tried closing all other apps when doing this but the PC version AWLAYS does the bitmap deal. Does any one know why and how to get the PC paste of an Excel spread sheet to work as it does on the MAC???

I use Excel because I have a lot of spread sheet worksheets for each project which are oftened conveyed as letter size documents and I dont want to create worksheets since the spread sheets have been formatted for presentation already. Of course the MAC pastes the entire formatting... which is perfect... and the cells no longer contain formulas, but the results of the calculations. Help!!!!!!!!!!

defjef

Link to comment

Try the "Import" feature in VectorWorks to import a Worksheet. First, save the Excel file as a copy with a comma delimited format or a tab delimited format. Next, create a new worksheet in your file. Use the Import Worksheet command (File-Import-Import Worksheet).

This should import nicely for you and there is no pasting involved.

------------------

Brian O

Nemetschek North America

Technical Support Specialist

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