Anuncios

The Autodesk Community Forums has a new look. Read more about what's changed on the Community Announcements board.

jwright1962
318 Vistas, 4 Respuestas

Trainwreck with Tables

Hello Forum!!  

So, I have a beautiful table in excel.  Looks exactly the way I want it.   create a data link to it and the whole thing falls apart.   text in columns not centered,  brings in the wrong font...   any ideas the get things centered up and the correct font applied ?  

 

Thanks!

pendean
en respuesta a: jwright1962

Describe in detail your exact step by step method of linking it in AutoCAD.
Then post a few screenshots so we can see what you see.
Also let everyone know your exact AutoCAD version as listed in ABOUT command and your OS.

TIA
Anonymous
en respuesta a: jwright1962

Try creating a table style first with the fonts you want to use and make it current. If it doesn't have to be linked, i'll do a paste special with AutoCad entities. The are always a few modifications that need to be done, thats the nature of the beast.

ChicagoLooper
en respuesta a: jwright1962

Just like there are text styles, dimension styles and multileader styles in a drawing file, there are also table styles.  When you paste form Excel, you are pasting your copied rows and columns into the default standard table style of AutoCad. You must establish your table style in AutoCad, not Excel. After pasting that standard table style to modelspace, you can apply your customized table style to that table.   

 

 

Chicagolooper

EESignature

TerryDotson
en respuesta a: jwright1962

AutoCAD table objects are not capable of accurately representing complex Excel spreadsheets.  If you don't find a solution to suit you and you were to consider third party software, take a look at DotSoft's XL2CAD.