Excel Paste Special to ACAD

I have done all the tricks mentioned on here. I can handle working around the scaling and truncating of the Excel spreadsheets when paste specialing.

What I can't seem to find a fix for is when I have cells formatted in Excel to have borders. Then when I paste into ACAD, the lines come in but are shifted either right, down, both, or some other form.

Is there a way to bring in the sheet and keep the lines intact?

 

Would you consider a 3rd party tool, or are you wanting to stick with plain AutoCAD?

 

There is a thrid party app called Spanner that seems to work pretty well.

Marc

the scaling and truncating of the Excel spreadsheets when paste specialing.

Excel to have borders. Then when I paste into ACAD, the lines come in but
are shifted either right, down, both, or some other form.

 

there is also a free macro that is or was posted in the user files section that allows to import excel spreadsheets into autocad as cad entities, if you cannot find it there feel free to e-mail me @ and I will mail it to you...

Spanner works very well as well, and I think it allows for some what dynamic updating, but it isn't free...

 

go to
http://www.cadaddon.com
they have several different programs - but the one we use is "AutoXlsTable".
This program will keep line, layer, text settings as ACAD drawings but keeps
the excel intelligence. it can count blocks, calc. areas, mathmatical
equations etc... It automatically updates when you flip back and forth.

This program is VERY functional and used daily in our office - well worth
the $80.

Feel free to email me if you have any questions.

good luck,
-Rob

Would you consider a 3rd party tool, or are you wanting to stick with plain
AutoCAD?

 

Spanner works well and Marc suggested. So does Dotsofts AutoCell if you want
to go that route.

This doesn't really answer your question concerning paste special.

If it's a table your creating, have you considered creating an attributed
table within AutoCAD and then import that data from excel into the ACAD
table? This way you have a template in excel (the one you use now) that can
be updated and imported into AutoCAD. You're simply updating the table via
excel. Setting it up would be a bit time consuming but once you've done
that, you get the same functionality you have now without the issue of
truncated/shifted lines. It's all ACAD entities your dealing with.

Check out the pulldown Tools>attribute extraction
and
Express>blocks>Import Attribute information

I used a form of this method when creating door schedules for contractors a
few years back. I would attribute all the doors and then export that
information out to an excel template the contractor provided. Any change
made on our side or his side was handled through importing or exporting the
table.

My 2cents

J. Logan

the scaling and truncating of the Excel spreadsheets when paste specialing.

Excel to have borders. Then when I paste into ACAD, the lines come in but
are shifted either right, down, both, or some other form.

 

Try Paste Link instead. You will get an OLE object and it will update if your master Excel sheet is modified. I like it better.