Having trouble with datalinks

[Anonymous]

Hello everyone. First post here. Fairly new to AutoCAD. (I miss SolidWorks already!) I'm getting really frustrated with datalinks. I'm probably missing something obvious! 

I'm having two main issues, both to do with formatting. I got a datalink to work fairly well, however some of the formatting isn't copying over from Excel. The font is right, the justification is correct, but that's about it. All the words within the boxes are changed to the same font size / text height. The Excel spreadsheet did have several cells with the text "shrunk to fit," and I tried to solve the issue by going through and manually changing the font size of those cells, with no luck. I was able to manually go through and shrink the text in each box that was wrong, but that was way too time-consuming. Also, the embedded table in AutoCAD seems to be just picking whatever column widths it wants when it creates the table. I can change it manually, but it's pretty annoying. I'll be doing this a lot... 

My other main issue is that I only got this ONE datalink to work. I'm not sure what I did, but it looked pretty good right off the bat when I inserted it. I tried creating one on a new drawing, and NONE of the formatting was copied over. All the cells/boxes were the same height and width, the font was changed to the default style and size, and centered in the boxes, etc. Just completely off. I'm not sure what I did differently but I can't make it look like the first one I did. Help please! 

Screenshots:
Excel sheet http://i.imgur.com/analqtP.png 
What the table looks like before I manually change the text sizes http://imgur.com/7a87SBn
What every other table looks like I try to insert http://imgur.com/RT4iWgV 

[wispoxy]

Enjoy the links 🙂

http://knowledge.autodesk.com/support/autocad/getting-started/caas/CloudHelp/cloudhelp/2015/ENU/Auto...

http://www.ellenfinkelstein.com/acadblog/insert-data-from-an-excel-worksheet/

A Video:
https://www.youtube.com/watch?v=QEXQJxajSGc

[Anonymous]

I am currently have the same issue. Those links that you posted are a great discription of Datalinks. But dosen't help with the problem at hand.

[Anonymous]

Have you found a solution to this problem yet? One suggestion was in Datalink dialog box under Cell Formatting to uncheck Use Excel Formatting. But this has not been helpful to me. Right now I am trying to lock down Excel to see if using the formatting would help. But I am sure you already know that the units between the two programs are different. What have you tried so far?

[zalant]

Hopefully this information will be helpful to you.

The Windows DPI setting (100%, 125%, 150%, etc.) affects what text height will be used in the resultant AutoCAD table from a data-linked Excel spreadsheet. (Assuming that you're using Excel formatting for the datalink.)

• For example, if your Windows DPI setting is 100%, an Excel font using the Calibri font, size 10, will end up being .0972 text height in the AutoCAD table cell.
• If the Windows DPI setting is 125%, that same Excel data will come into the AutoCAD table at a height of .0694.

The text height calculation is dependent on the number of logical pixels, which is controlled by the Windows DPI setting.