topic Re: Import point number and xyz data from excel and display # in AutoCAD Forum

Import point number and xyz data from excel and display #

Anonymous — Fri, 10 Nov 2017 10:52:46 GMT

I would like to import a pont number, and x,y,z, data from excel to display a point node and the point number. Any help?

Re: Import point number and xyz data from excel and display #

imadHabash — Fri, 10 Nov 2017 11:00:11 GMT

Hi,

making script file will serve your issue. please read more here. >> Click <<

Regards,

Re: Import point number and xyz data from excel and display #

john.vellek — Fri, 10 Nov 2017 16:11:15 GMT

Hi @Anonymous,

Imad provided a great link that might get you started. I usually do this by using a CONCATENATE function in Excel. You are welcome to attach your Excel file and I can show you how this might be done. There are also a variety of add-ins available in the Autodesk App Store that might make this easier for you.

Please select the Accept as Solution button if my post solves your issue or answers your question.

Re: Import point number and xyz data from excel and display #

leeminardi — Fri, 10 Nov 2017 16:41:22 GMT

Assuming columns A,B,C contain the x,y,z coordinates and column D contains the label, and your data starts in row 2, place the following in cell E2 (the location of spaces is very critical):

=CONCATENATE("point ",A2,",",B2,",",C2," ","text ",A2,",",B2,",",C2," ",0.4," ",0," ",D2," ")

then fill down, copy column E to Notepad and save as a text file with the extension .scr. You can use the script command in AutoCAD to run this script. I have assumed a text height of 0.4 and an angle of 0. You can change these values in the Excel concatenate function

Re: Import point number and xyz data from excel and display #

Anonymous — Fri, 10 Nov 2017 16:48:39 GMT

excellent information everyone. But here is one more question?

Can you display a two lined label. For example display point number (d2 cell) followed in second line the z elevation?

Re: Import point number and xyz data from excel and display #

Alfred.NESWADBA — Fri, 10 Nov 2017 16:53:05 GMT

Hi,

>> display point number (d2 cell) followed in second line the z elevation

Create 2 attributes for that, one for point number, the other one for z elevation.

Then make sure ATTDIA is set to 0 otherwise it might option the attedit dialog.

- alfred -

Re: Import point number and xyz data from excel and display #

braudpat — Fri, 10 Nov 2017 17:03:39 GMT

Hello

Maybe you can look at the beautiful "Point Manager" Routine from Lee Mac !

http://lee-mac.com/ptmanager.html

Regards, Patrice

Re: Import point number and xyz data from excel and display #

Anonymous — Fri, 10 Nov 2017 17:32:52 GMT

Have you personally used this routine?

Re: Import point number and xyz data from excel and display #

Patchy — Fri, 10 Nov 2017 17:44:37 GMT

This only can show points, not numbers or descriptions.

There are other prog. can do it.

Let's see your excel file.

Re: Import point number and xyz data from excel and display #

Anonymous — Fri, 10 Nov 2017 17:56:04 GMT

I’ll post it tonight!

Re: Import point number and xyz data from excel and display #

leeminardi — Fri, 10 Nov 2017 19:25:11 GMT

Here's a modification to my post #4 that gives the TEXT command twice to enable two lines of text. I tried using the MTEXT command but had difficulty getting it to accept a new line in a script. I was able to do it with the TEXT command by using the unicode \U+000D for a carriage return. Note that 0.5 is subtracted from the y coordinate of the second text command to offset the second line of text. The 0.4 is the text height.

Here is the Excel formula to fill-down (spaces are critical).

=CONCATENATE("point ",A2,",",B2,",",C2," ","text ",A2,",",B2,",",C2," ",0.4," ",0," ",D2," \U+000Dtext ",A2,",",B2-0.5,",",C2," ",0.4," ",0," ",E2," ")

Again, copy the contents of column F to Notepad and Save As a text file with the extension .scr to run with SCRIPT.

Re: Import point number and xyz data from excel and display #

john.vellek — Mon, 13 Nov 2017 21:18:35 GMT

Hi @Anonymous,

I am checking back to see if my post or others helped you with your problem. Please mark a post or posts as accepted solutions if they resolved the issue or give me a bit more detail on this issue so we can continue to work towards getting this solved.

Please hit the Accept as Solution button if a post or posts solves your issue or answers your question.

Re: Import point number and xyz data from excel and display #

Anonymous — Tue, 14 Nov 2017 17:35:06 GMT

Running the formula as a script only drew one point and the point is very small. As I’m only a beginner in AutoCAD, I’m sure there is more explanition needed. I have my units set to feet since I’m working with surveying coordinates. I’ll Post some sample data when I’m at a desk top

Re: Import point number and xyz data from excel and display #

braudpat — Tue, 14 Nov 2017 18:07:03 GMT

Hello

Please run the command: DDPTYPE

Regards, Patrice

Re: Import point number and xyz data from excel and display #

leeminardi — Tue, 14 Nov 2017 22:20:18 GMT

Post the script file too so it can be analyzed to see why it is only creating one point.

Re: Import point number and xyz data from excel and display #

Anonymous — Tue, 14 Nov 2017 23:01:55 GMT

After some practice I think I found the answer. Thanks for all your help.

Re: Import point number and xyz data from excel and display #

Anonymous — Mon, 20 Nov 2017 18:51:28 GMT

How about this, if I was to associate an excel coordinator (xyz,label) with a code #, could I import points to a specific layer based on that code?

Or is there a way to automate importing points to different layers based on criteria?

Re: Import point number and xyz data from excel and display #

leeminardi — Mon, 20 Nov 2017 21:26:22 GMT

In sheet 1 of the attached Excel file are the location of the point, columns for two labels for the point, a code #, and the layer name corresponding to the code number.

The contents of cell H2 is:

=CONCATENATE("-layer"," s ",G2," point ",A2,",",B2,",",C2," ","text ",A2,",",B2,",",C2," ",0.4," ",0," ",D2," \U+000Dtext ",A2,",",B2-0.5,",",C2," ",0.4," ",0," ",E2," ")

Note that there are two blank spaces before the word point

The correlation between a code# and a layer name is defined on sheet 2 as noted below. This array of values is named "LabelTable" and is referenced via the Excel VLOOKUP function in column G of sheet 1.

Copy and paste column G to Notepad and save as a txt file with the extension .scr then run the script in AutoCAD. (Note, it has been stated that you can simply paste the contents of the clipboard into AutoCAD. This did not work for me but the script file does work.)

Here is the data in Notepad:

Here are the results in AutoCAD:

Re: Import point number and xyz data from excel and display #

Anonymous — Tue, 27 Apr 2021 13:06:03 GMT

Thanks a lot. It helps the time savings😍

Re: Import point number and xyz data from excel and display #

rohanQREWS — Thu, 08 Jun 2023 05:20:55 GMT

Hey guys, this has been exactly what I've been trying to find so thanks so much! However, I was wondering what I would need to add to the formula to add further vertically offset labels? I'm very new to AutoCAD, mainly using it for site engineering stuff as opposed to anything design related and want to hopefully learn to develop these myself when I need them.