topic Betreff: Insert text at coordinates from excel in Visual LISP, AutoLISP and General Customization Forum

Insert text at coordinates from excel

Anonymous — Tue, 02 Oct 2018 15:17:12 GMT

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

Re: Insert text at coordinates from excel

dbhunia — Tue, 02 Oct 2018 16:13:34 GMT

can you send the excel

Betreff: Insert text at coordinates from excel

cadffm — Tue, 02 Oct 2018 16:45:56 GMT

@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)

Re: Insert text at coordinates from excel

dbhunia — Tue, 02 Oct 2018 20:40:00 GMT

@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?

Re: Insert text at coordinates from excel

dbhunia — Wed, 03 Oct 2018 07:32:36 GMT

@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")

Betreff: Insert text at coordinates from excel

Anonymous — Wed, 03 Oct 2018 08:55:55 GMT

Thanks. This worked perfectly

Re: Insert text at coordinates from excel

Anonymous — Tue, 02 Apr 2019 20:18:26 GMT

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?

Betreff: Insert text at coordinates from excel

Anonymous — Tue, 23 Apr 2019 09:04:59 GMT

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

Re: Insert text at coordinates from excel

Anonymous — Wed, 10 Feb 2021 05:56:41 GMT

Can you explain how to use this?

Re: Insert text at coordinates from excel

Anonymous — Wed, 10 Feb 2021 05:58:48 GMT

how to use this?

Re: Insert text at coordinates from excel

ivoitiuk — Wed, 20 Mar 2024 15:33:50 GMT

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