Jump to content
ktd27

How to insert many text objects from CSV or XLSX to specific x,y locations?

Recommended Posts

ktd27

I'm about to receive a bunch of borehole data for a bigger project with x,y coordinates in state plane for each hole and I believe it will be sent as an Excel file. I'd like to add a center-justified text consisting of the borehole name at the x,y coordinate where it should go so I can quickly check out the location of a hole and then look up its other properties by name in the Excel sheet. So far, I'm thinking about concatenating the cells and adding spaces in a separate column in excel so that for each hole I have something like:

 

text j mc 0 x-coordinate,y-coordinate BH120

 

in a single cell. That way I can copy and paste that line at the CAD command prompt and skip a ton of key strokes going through the text options.

 

I've done a similar workaround, inspired by someone here on the forums, when working with line segments where clients have sent me endpoints in Excel format. It's been great because it's transparent enough that I can forward my spreadsheet on to any one of my coworkers and have them duplicate the process without having to worry about a couple of people in my work group who only have LT and can't use LISPs (I think?). The difference is that while you can exit a line command by putting a space after that entry above, I think the only way to end the text command might be by pressing enter twice and I don't know if there's a way to just concatenate a couple of enters at the end of a line like I can a couple of spaces.

 

The question is, is there a quick cheat that would let me do everything by copying and pasting multiple lines formatted as above all at once from excel without having to press enter after each hole? Is there an arraypath type command that's more well-suited to this instead, since I do have x,y coordinates?

Share this post


Link to post
Share on other sites
BIGAL
text j mc 0 x-coordinate,y-coordinate BH120
We have a winner

 

The extra press enters may be spaces on the end of the line, you need to be careful of that, or try -text. As text now expects a new line like mtext.

To end, a blank line should work as Enter. Carefully check the lines copy and paste to notepad as a check.

Share this post


Link to post
Share on other sites
ktd27

I do not know why I never considered adding a blank line...doing both that and -text instead of text is going to work perfectly. Thank you for saving me many hours of frustration!

Share this post


Link to post
Share on other sites
ktd27

Mistakes were made. The original post above should have:

 

text j mc x-coordinate,y-coordinate 0 BH120

Share this post


Link to post
Share on other sites
BIGAL

Just watch out for the two ways to do text compare text style with height = 0 to height is a value, the 2nd it will not prompt for height so script stuffs up.

 

text j mc x-coordinate,y-coordinate 2.5 0 BH120

text j mc x-coordinate,y-coordinate 0 BH120

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×