neuri Posted January 11, 2021 Share Posted January 11, 2021 Hello, I need some help linking to specific cells in an excel spreadsheet. I have a large list of mechanical services that I need to plot in to a table for each equipment, I want to make a generic table and link each cell to a specific cell in my excel file. For example: I drew this table in excel, the Cell A1, G1, A24 and F24 refer to the cells in my excel spreadsheet. ________________________ |_Cell A1___|_Cell G1___| |_Cell A24__|__Cell F24_| So when I update the spreadsheet, the table also updates automatically. Right now i can use Data Link, but it links the entire excel sheet, blank MEP tables etc., I just want specific cells. Is this possible? I googled and saw something similar in the LISP forum but i don't even know how to begin to read LISP code. Quote Link to comment Share on other sites More sharing options...
BIGAL Posted January 11, 2021 Share Posted January 11, 2021 Your profile says you have LT correct ? That may be a problem. Quote Link to comment Share on other sites More sharing options...
neuri Posted January 11, 2021 Author Share Posted January 11, 2021 3 minutes ago, BIGAL said: Your profile says you have LT correct ? That may be a problem. Oh, didn't see my profile. My office just upgraded us to ACAD 2021 with new laptops. But even in 2014 LT, i was able to link excel sheets. Now, I just want to link to specific cells. Quote Link to comment Share on other sites More sharing options...
BIGAL Posted January 12, 2021 Share Posted January 12, 2021 Found a possible answer after googling. Copy a cell in excel Paste special in Autocad, choose link. Quote Link to comment Share on other sites More sharing options...
SLW210 Posted January 12, 2021 Share Posted January 12, 2021 Copy the cell(s) in Excel>Paste Special in AutoCAD>Paste Link>AutoCAD Entities>OK then place where desired. Quote Link to comment Share on other sites More sharing options...
BIGAL Posted January 13, 2021 Share Posted January 13, 2021 (edited) SLW210 your explanation was the same as mine but better described. Why not click cell excel then Ctrl+C Go to Autocad Alt+Ctrl+V hope I have enough fingers. Edited January 13, 2021 by BIGAL Quote Link to comment Share on other sites More sharing options...
neuri Posted January 13, 2021 Author Share Posted January 13, 2021 Oh.. there's multiple entries, steam/hot water/cold water/chilled water/gas/electricity/vacuum/air pressure etc. and there's roughly 60+ equipment. I was hoping there's an easy way but copy pasting for so many entries... oh man.. Quote Link to comment Share on other sites More sharing options...
BIGAL Posted January 14, 2021 Share Posted January 14, 2021 You can select cells from excel "B12" can make a clipboard entry, not sure about the paste special from lisp. Are there a way copy and paste via clipboard by lisp? - AutoLISP, Visual LISP & DCL - AutoCAD Forums (cadtutor.net) Solved: Paste range of cells from Excel into AutoCAD table - Autodesk Community - AutoCAD LT Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.