I am working with tables that are linked to data from an excel file.
After I create a table I dettach it from the excel file. I do not want the excel file to control the table.
I then need to update the text format of all the text in the table. I've noticed that the text strings are still formatted based on how the excel file was formatted.
The only way to remove this is to click on the cell, highlight the text, right click, and then select Remove Character Formatting. Unfortunately I have to do this for each text string.
Is there a way to remove the character formatting for all of the text strings at once?
Even better, is there a way to format the table so that it does not change the text style based on what is in the excel file but instead based on AutoCAD's text styles?
I've attached an example of a table I'm working on. I've detached the table from the excel file.
Solved! Go to Solution.
Not sure what you're trying to format but if I assume that it is the font, make sure the font is the way you want it in the excel sheet before inserting the table in autocad.
If the table is still linked to the excel file, change the font in the excel file and update the table link and the font will update in the autocad table
Excel supports any "windows" TTF font.
What prevents you from using the same font in autocad as in excel ?
If you want to use a SHX font in autocad you're out of luck because excel is not compatible with SHX fonts.
That is a good point. The font in AutoCAD that I want to use is an SHX font.
Even so I would like the user to be able to change the font to whatever they want within autocad.
Perhaps there is a way to remove the character formatting with a lisp program?
I've attached some pictures to show what I'm talking about.
To remove excel formatting from a linked table:
2-Double click the link your working with. Click the expand interface logo (circle with an angle in it (>)) to show all options.
3-Uncheck the box beside Use Excel Formatting.
That's how it's supposed to work, but it doesn't seem to always work for me. If there's a CAD expert, maybe you could let me know why this option doesnt always work
Thanks for the input! It worked! I did notice that I would loose the row and column widths if I did this. But if I created a table with the formatting linked to the excel file, then went back and edited the data link to remove the excel formatting, the rows and columns with keep the desired widths.
Is there a way to keep the column and row widths while removing the character formatting?
AWSOME!! Thanks again!!!