Insert text at coordinates from excel

[Anonymous]

Hi 

I have an excel file that I have the X,Y,Z coordinates of a pipeline and I need to insert some text also contained in the excel file at these coordinates. Is there any way to insert a leader at the coordinate and use the text in the excel file as the leader text? I have over 1000 of these points to do. I'm not very familiar with LISP files so that may be too difficult for me. Even if i could just insert the text at the coordinates that would be better than having to insert each one individually. Any help appreciated

Thanks

[dbhunia]

can you send the excel

[cadffm · Accepted solution]

@Anonymous

without Lisp check out your steps in commandline to create an mleader,

then built an script und start the scriptfile.scr with command SCRIPT.

Sample attached, this works with a Standard dwg(no template or just  acad.dwt)

[dbhunia]

---

@Anonymous wrote:

Hi 

I have an excel file that I have the X,Y,Z coordinates of a pipeline and I need to insert some text also contained in the excel file at these coordinates. Is there any way to insert a leader at the coordinate and use the text in the excel file as the leader text? I have over 1000 of these points to do. I'm not very familiar with LISP files so that may be too difficult for me. Even if i could just insert the text at the coordinates that would be better than having to insert each one individually. Any help appreciated

---

Hi,

If your Excel is like this format

Then go through the attached code....

Another thing Keep the Excel file close.

And for Leader what should be its direction?

[dbhunia]

---

@Anonymous wrote:

Hi 

I have an excel file that I have the X,Y,Z coordinates of a pipeline and I need to insert some text also contained in the excel file at these coordinates. Is there any way to insert a leader at the coordinate and use the text in the excel file as the leader text? I have over 1000 of these points to do. I'm not very familiar with LISP files so that may be too difficult for me. Even if i could just insert the text at the coordinates that would be better than having to insert each one individually. Any help appreciated

Thanks

---

Hi,

If your Excel is like this format

 

Then go through the attached code....

Another things-

1. Keep the Excel file close.

2. If your Excel file contains any text in first row, like 

 

Then make change in the line, from - (setq address "A1:D50000")  To (setq address "A2:D50000")

[Anonymous]

Thanks. This worked perfectly

[Anonymous]

Hi. I'm looking for the same thing but in some cells I have a single line text and in some cells I have a multiline text. For example 

Is there a way to insert multiline text? I'm trying to find it but I can't.

A long time ago I found somewhere you could copy a line from notepad to command line where you wrote

command, first corner, second corner, text

mtext 100,100 200,200 ......

but i forgot how to write the command for text. do you have to use quation marks or what. does anyone have an idea?

[Anonymous]

Thank q very much . It help me lot i mean it.

[Anonymous]

Can you explain how to use this?

[Anonymous]

how to use this?

[ivoitiuk]

How to insert multiline text the same way as in example?