How to get paste special to bring in excel formatting?

[Egbay]

At work these are the steps we do to bring in an excel table into a CAD drawing:

1. Copy content from excel
2. In autocad
   • Paste special->Paste link-> Autocad Entities

The problem is that some of the tables we want to bring in are formatted with excel cells having no boarders but when following the steps above the cell boarders appear. I'll add in some screenshots below. I know that in autocad you can select the cells, right click-> boarders and then format the cells that way. Problem is that the file with the data gets overwritten and when we have get the option to update datalinks in autocad, it reverts back to all having boarders again.

I'm not talking about 7 new rows being added to the original excel file and expecting the formatting to stay, rather just the data in the cells changing and that causing the autocad formatting to bring back the cell boarders.

If this is what it is then that is fine but I was wanting to see if anyone knew other ways to keep the excel formatting?

[pendean]

Reread your own post: you want EXCEL settings but you want to use AutoCAD settings 😉

Choose one OR the other.

FWIW: TABLESTYLE is not automagical, it requires user effort to create a look you wish to have before use.

[-Igor-]

If you turn off all the borders in the AutoCAD table style, it will follow the original excel formatting for the copy- paste method (Note: all borders will still be visible, but only those that are made visible in excel would print)

I would recommend a different approach though:

1. type "DataLink"

2. click "Create a new Excel Data Link"

3. Browse to your file

4. expand the arrow on bottom right

5. 

this data link process can be set up to be automated, for example the link can be made relative, and the excel file can be kept in the same folder as the dwg, then when you copy both to a new folder those would be linked to each other.

hope this helps.

[dbroad]

If you really want Excel formatting, is there a reason that you don't choose pastespec -> Paste -> Microsoft Excel Worksheet OR pastespec -> Paste Link -> Microsoft Excel Worksheet?

Seems like that would be more consistent with your intent of automatic updating.

[Egbay]

I was trying to see if I can bypass that effort so I thought Id ask where there are people with more knowledge/experience. Thanks for the help though.

[Egbay]

I'll give this a shot and report back. Thanks

[Egbay]

Good question. Im not sure, that is just how I was instructed things were done. Not sure if it had to do with files being overwritten so that the datalink can just be updated rather than having to copy and paste in the future? That's just my thoughts.

I'm trying to figure out ways to make our process easier/better and this is just something I wanted to look into

[dbroad]

Thanks.  Cutting and pasting doesn't create a link to a file unless you use the link options.  Seems to me that if you've going to use datalink, you don't cut and paste and you will still need the orginal excel file.  In that case, if you want the Excel formatting, then copy/pasting a link to the Excel file makes sense.

[Egbay]

This unfortunately did not work. The other thing I tried to do was create a new table style but I dont believe that would be the consistent solution.