AutoCAD 2010/2011/2012

AutoCAD 2010/2011/2012

Reply
*Expert Elite*
ToanDN
Posts: 1,880
Registered: ‎09-26-2006
Message 11 of 19 (2,980 Views)

Re: insert Excel spread sheet into an autocad dwg.

01-05-2011 11:47 AM in reply to: jamiej

You can manipulate an AutoCAD table's border and grid lines any ways you want.

Valued Contributor
dbirchfield
Posts: 52
Registered: ‎06-17-2008
Message 12 of 19 (2,976 Views)

Re: insert Excel spread sheet into an autocad dwg.

01-05-2011 11:53 AM in reply to: ToanDN

I'm assuming you're referring to the OLE is not printing right.

 

Are you printing through AutoCAD's PDF writer or a 3rd party app?

 

I prefer PDFCreator myself (on 64bit) or CutePDF, PDF995 worked very well in XP, but I haven't used it recently.

Contributor
jamiej
Posts: 13
Registered: ‎12-05-2006
Message 13 of 19 (2,972 Views)

Re: insert Excel spread sheet into an autocad dwg.

01-05-2011 12:05 PM in reply to: dbirchfield

I am using Acrobat x's PDF printer, and i also tried using Autocad's dwgtopdf printer, same result. i tried the export to pdf but that doesn't work at all, i just get a plot.log file.

Valued Contributor
dbirchfield
Posts: 52
Registered: ‎06-17-2008
Message 14 of 19 (2,961 Views)

Re: insert Excel spread sheet into an autocad dwg.

01-05-2011 01:23 PM in reply to: jamiej

Here's an example of PDFCreator's work with some OLE's.

 

It's available free here:

 

http://sourceforge.net/projects/pdfcreator/

 

 

New Member
sam.synn
Posts: 2
Registered: ‎06-17-2008
Message 15 of 19 (2,645 Views)

Re: insert Excel spread sheet into an autocad dwg.

06-29-2011 02:00 PM in reply to: hvysteel

I tried this but the cell formatting does not carry through. The text formatting does. Any Ideas?

Member
blackbolt9
Posts: 5
Registered: ‎01-26-2007
Message 16 of 19 (2,464 Views)

Spreadsheet not plotting properly

10-25-2011 11:15 PM in reply to: sam.synn

I linked my excel file to my autocad drawing but when I try to print it only prints the data in the first row and the gridlines but none of the rest of the data. It even shows up this way in the preview. What setting do I have screwed up to cause this to happen? I'm using autocad 2008 btw.

 

http://i36.photobucket.com/albums/e4/blackbolt9/issue.jpg

New Member
Paul_in_Tbilisi
Posts: 1
Registered: ‎06-19-2013
Message 17 of 19 (1,591 Views)

Re: insert Excel spread sheet into an autocad dwg.

06-19-2013 05:58 AM in reply to: maureenc

Better late than never - here's the answer to how to get rid of the border lines around linked Excel objects.

 

I worked out how to remove the lines from linked Excel fields in AutoCad. I'm a real novice using AutoCad so finding out I can link a drawing to Excel was great news. I think we'll do all of our drawings this way from now on - it'll make them much easier to maintain and change our item tag numbers.

It doesn't matter if the borders are displayed in Excel. The important thing is to use Arial Narrow 64pt as the font in Excel as this seemed to paste into AutoCad at the correct size. The cell background in Excel is set to "No Color" and the font color to Red.

Here's how I did it, and then removed the borders:

1. Copy a cell from Excel

 

2. Paste Special "As link" in the drawing

(the new field will then display but with a border)

3. Select the new field then right click... "Properties"

4. In the "Color" field choose "Select color..." at the bottom of the drop down.

AutoCad-InsertExcelField1.jpg

5. Click on the "True color" tab - you will note that the "Color:" box at the bottom is currently disabled

AutoCad-InsertExcelField3.jpg

6. Click anywhere on the grayscale slider - this will activate the field at the bottom

 

AutoCad-InsertExcelField5.jpg

7. Move the slider back up to the top - the box at the bottom should then display "255.255.255"

AutoCad-InsertExcelField6.jpg

8. Click ok - the border should now be invisible in the page layout view

9. To remove the borders on any additional items select a bunch of them all at once then simply choose the new stored color setting of "255,255,255" from the drop down list

AutoCad-InsertExcelField7.jpg

 

HTH!

 

Regards
Paul

 

 

*Expert Elite*
punisher
Posts: 297
Registered: ‎10-13-2008
Message 18 of 19 (1,302 Views)

Re: insert Excel spread sheet into an autocad dwg.

10-31-2013 09:58 AM in reply to: smbrennan85

Thanks, I needed the alternate solution for faster results.

Cheers

John Evans
Autodesk Certified Professional

http://designandmotion.net
New Member
jim.vonderahe
Posts: 2
Registered: ‎04-11-2014
Message 19 of 19 (787 Views)

Re: insert Excel spread sheet into an autocad dwg.

04-11-2014 08:14 AM in reply to: maureenc

Very Helpful!!

 

Thanks

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.