Jump to content

Insert blocks from excel with attribute info


bigmaz

Recommended Posts

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

Link to comment
Share on other sites

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..."

Link to comment
Share on other sites

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 by BIGAL
Link to comment
Share on other sites

  • 1 year later...

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.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...