I am trying to link an Excel Spreadsheet to AutoCAD. The problem I have is that only
half the spreadsheet is copied into AutoCAD. Does anyone have any suggestions?
|
I am trying to link an Excel Spreadsheet to AutoCAD. The problem I have is that only
half the spreadsheet is copied into AutoCAD. Does anyone have any suggestions?
What version of AutoCAD are you using?
R.K. McSwain | CAD Panacea |
I am using AutoCAD 2007, I am not sure what version of Excel
You can only LINK Excel as a an Excel spreadsheet in AutoCAD 2007 which has a limit on the amount of data. If you just copy/paste the spreadsheet as an AutoCAD identity you can better results. There is a limit of (I think) 10,000 or 20,000 thousand cells.
If you want to link in 2007 you may have to make two tables.
Thank you for your help. The spreadsheet is only 75 rows and maybe 20 columns.
I want to link it for the edit function, as we are using it for our building code analysis.
R2008 allows you to link an Excel spreadsheet to an AutoCAD Table entity. That doesn't help you any now, but it may down the road.
You might take a look at XL2CAD. We have used this with success in the past. Not that it doesn't still work, but our need to link spreadsheets has all but vanished recently.
R.K. McSwain | CAD Panacea |
Copy and paste works best for me....
I highlight the spread sheet in Excel, then in Autocad I use paste....hope this helps.