This page has been translated for your convenience with an automatic translation service. This is not an official translation and may contain errors and inaccurate translations. Autodesk does not warrant, either expressly or implied, the accuracy, reliability or completeness of the information translated by the machine translation service and will not be liable for damages or losses caused by the trust placed in the translation service. Translate
09-13-2013 02:05 PM
I simply want to paste a series of cells from excel into an existing autocad table. About 8 rows, 1 column thick. I want the values to acquire the destination formatting too if possible. I do not want to create an OLE object or anything fancy. I have seen instructions to use "Paste Special" on forums, but I do not have this choice when I right-click.I'm sure this is possible.
Any help would be greatly appreciated.
-----
AutoCAD 2018/2021
AutoCAD Civil 3D 2021
09-14-2013 06:08 AM
PASTESPEC is the command name, type it.
Look up usage in Help.
09-16-2013 09:34 AM
The PASTESPEC command is helpful to know.
However, I still do not see how you can "paste as rows" - this is the nomenclature from Ms Word.
When I go into an AutoCad table cell, I do have "Paste Special" > "Paste without Character Formatting" as the only option. This pastes all data for multiple rows into one cell. I want to enter data into multiple rows at once:
ExcelRow 1 > Cad Row 5,
Excel Row 2 > Cad Row 6,
Excel Row 3 > Cad Row 7,
etc ...
-----
AutoCAD 2018/2021
AutoCAD Civil 3D 2021
09-16-2013 10:24 AM
There is no 'paste as rows" in AutoCAD: you can only paste what you pre-select and copy in Excel.
The choices of the command are worth exploring in HELP, as well as testing: try each and explore what they offer and if that meets your needs.
09-18-2013 09:55 AM
FYI, This is the best solution for my situation:
- PASTESPEC
- Paste as AutoCad Entities
- This creates a brand new AutoCAD table. You can select the range of columns and rows you like, copy
- Paste into exiting AutoCAD table.
I can update multiple cells at once, which is a big timesaver in this case.
Thanks Dean.
-----
AutoCAD 2018/2021
AutoCAD Civil 3D 2021
12-30-2013 12:21 PM
After you have copied the area from Excel, go into AutoCad and do not right click instead click on edit button then click on paste special then click on Excel link.
01-03-2014 12:38 PM
Where is the edit button you are talking about? Dos this make an AutoCAD editable table or OLE object?
-----
AutoCAD 2018/2021
AutoCAD Civil 3D 2021
01-03-2014 03:09 PM
EDIT pulldown menu: PASTESPEC is the command if you want to type it. It's just another option, a linked OLE object is the result.
01-07-2014 02:58 PM
I think we are not on the same page. If I am not wrong, you want to extract some values from Excel tables directly into existing Autocad tables. I have not tried that because I don't like using the Table function in AutoCad since it is very slow and very limited in function. I do all my tables and calculations/programming in Excel and then I would just paste them onto Autocad. You can highlight/copy the range in Excel and then right click in Autocad and it will allow you to paste the excel file as a one autocad entity. The problem with this is that if you update the Excel file, the one pasted on Autocad will not be updated. However, if, after you higlight/copy a range in Excel, go to your Autocad drawing but instead of right clicking, click on the Edit pulldown menu then click on paste special then click on paste link. It does create an OLE and each time you update and save the Excel file it will automatically be reflected on the Autocad.
06-10-2016 12:11 PM
Thanks, this worked perfectly for me.
02-28-2017 10:53 PM
when i paste the table from excel to auto-cad , the color of the text is black and the text style inside the table is standard , how can i change it to any other text style without edit cell by cell ?
03-01-2017 05:14 AM
What method of "pasting" did you do?
03-01-2017 05:36 AM
I SELECTED ALL THE CELLS I WANT THEN I COPED IT IN TO AUTO-CAD AS WRITTEN . THE TEXT COLOR IS BLACK AS IN THE EXCEL SHEET , TO SOLVE IT I CHANGED THE TEXT COLOR IN EXCEL THE I COPED IT TO AUTO-CAD , IS THAT RIGHT ?
06-06-2018 07:58 PM
The text appears black and cannot be changed all at once after pasting AutoCAD Entities. Is there a way to change it all at once to white?
I am unable to change all pasted cells to white, color 7, for some reason.
Please help?
09-23-2021 02:54 PM
I'm having the same trouble - Copy from Excel>Paste Special>ACAD Entities
The text color comes in as black 0,0,0 and does not correlate with the standard white (7) in my layer. To change the color, I have to change it via Text Edit by changing the text in each individual cell to By Layer (white). This is very time consuming... Is there a work around?
09-24-2021 01:16 AM
Unfortunately not in LT. In full AutoCad I believe there is a workaround which sorts the table all at once.
09-24-2021 01:20 AM
{ in full-AutoCAD i would use the tool STRIPMTEXT }
In LT i would change the color in Excel, of course it is still an internal truecolor mtext format,
but others way with a real solution is to much work or needs much knowledge how to edit
File content by workarounds (like ascii DXF or temporary inside another software)
- Sebastian - 
millertatifechand.blogspot.com
Source: https://forums.autodesk.com/t5/autocad-lt-forum/paste-range-of-cells-from-excel-into-autocad-table/td-p/4425873
0 Response to "Copy Tables From Excel Into Autocad Drawing"
Post a Comment