Printing Excel Cells in AutoCAD

[maxh]

Hi Everyone,

Can anyone tell me why when I import an Excel spreadsheet cell into AutoCAD LT I get a border printed for the top and lefthand side of the cell. I just want the text to appear and have the drawing linked to the spreadsheet so that when the spreadsheet changes the values on the drawing also change.

In the base Excel spreadsheet the cell is specified without borders, the cell colour is set to white and the text colour is set to black.

I have looked all the colour and property settings in AutoCAD and I have played with the plot table settings as well and yet I still get this phantom border appearing.

Can anyone help ?

Thanks

 

[dbaird]

In Excel go to page setup----->sheet----->print.....is gridlines box checked? If so that may be your problem.


David Baird
mrbaird@hotmail.com

Sr Controls Engineer

EET degree.

Journeyman Electrician.

 

[maxh]

Thanks for the tip David, I have tried it and the problem remains.

Any other thoughts anyone ?

Thank you in advance for your suggestions

 

[melone]

Is it there when you print the speadsheet?

 

[joerd]

Try (in Excel) Tools/Options/View tab, under Window options uncheck the box at Gridlines, then press OK. Gridlines should disappear in Excel, and in the linked object in ACAD as well.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[maxh]

melone - no the border didn't appear when printing the spreadsheet - see below.

joerd - Your tip gave me the solution - thanks

I found my excel print settings suppressed the gridlines but as joerd correctly suggested it was only when the gridlines for the display were suppressed that the copy / paste through to AutoCAD worked without carrying through a border.

Hope my explanation makes sense.
Thanks for your help.

 

[Sparweb]

maxh, et al.,

I have tried in the past to create "pivot tables" to import into AutoCAD, but without success.

How do you "capture" the value in the Excel table, in a way that influences, say, the length of a line in AutoCAD?

I've done this plenty with Solidworks, but there just doesn't seem to be the same functionality with ACAD.


Steven Fahey, CET
"Simplicate, and add more lightness" - Bill Stout

 

[BrianIreland]

SparWeb,
I'm not sure I follow your question but in the past I have used excel data to draw stuff in Autocad. Generally, it's copying commands and lengths, angles, etc. of lines (from excel) and pasting them into the script box of Acad.

I have created long-sections of pipes for example purely from Excel tables. Including Manhole names, Ground Levels, etc.

If this is something like what you want, let me know and I will get you the exact commands used and how I did it (it was at a previous job, so I dont have the commands, etc. to hand, but can get them).

 

[IFRs]

You need to setup OLE (Object Linking and Embedding). I have in the past linked an Excel spreadsheet to Acad so that the cells int Excel defined the size and shape of an i-beam in Acad. If you changed a cell value in Excel for the web, for instance, the drawing of the i-beam's web in Acad changed like magic! This was a long time ago, it may be easier to use VBA from within Acad to read the Excel values.