bigmaz Posted July 19, 2011 Share Posted July 19, 2011 Hi guys I have found a few things on here, but not exactly what I want. We have a excel spreadsheet with borehole references and coordinates. I need to be able to insert a block according to these coordinates and the borehole reference as the attribute. Can someone please help me with this? A lsp routine? Here is a sample of the excel: test.zip Quote Link to comment Share on other sites More sharing options...
ReMark Posted July 19, 2011 Share Posted July 19, 2011 Take a look at Lee Mac's lisp routine called Point Manager. http://lee-mac.com/ptmanager.html Quote Link to comment Share on other sites More sharing options...
bigmaz Posted July 19, 2011 Author Share Posted July 19, 2011 I did look at that, but it doesnt seem to have the option to insert the attibute reference in each block. Quote Link to comment Share on other sites More sharing options...
ReMark Posted July 19, 2011 Share Posted July 19, 2011 I did look at that, but it doesnt seem to have the option to insert the attibute reference in each block. I guess I misread the following line. "If attribute data follows the point data within a txt/csv file, the user may choose to populate block attributes with such data..." Quote Link to comment Share on other sites More sharing options...
BIGAL Posted July 21, 2011 Share Posted July 21, 2011 (edited) Because the data is in excel you could use excell to write a script its just a case of having the columns reflect a line in a script file and copying and pasting to say notepad then running. eg code _Insert boreblock x,y 1 0 for each borehole 1 after another. Have to go to meeting now will see if I can do the macro for you later. preset your insert parameters to pick insert point on screen set scale and rotation required. Please note these can be set also from excell but for simplicity left out. HAVE A LOOK AT THIS a block with 3 attributes borehole material 1 and material 2 put the concatenate to a cell to the right in your spreadsheet BORE1 23.456 123.45 LOOSE SOLID =CONCATENATE("_INSERT" "BOREHOLEBLOCK"," ",VALUE(A1)," ",value(A2)," ",VALUE(B2),",",VALUE(C2)," ",VALUE(D2)," ",VALUE(E2)) BORE2 52.145 145.256 COMPACT ROCK then copy down here just highlight the concatenate column and cut and paste to command line should work Edited July 21, 2011 by BIGAL Quote Link to comment Share on other sites More sharing options...
sanju2323 Posted March 12, 2013 Share Posted March 12, 2013 Dear sir, can you post me spreadsheet borehole excel to autocad my email id is sanju2323@yahoo.co.in 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.