topic Re: transfer identities from excel and draw the data in AutoCAD Forum

transfer identities from excel and draw the data

Anonymous — Mon, 16 Sep 2019 03:34:20 GMT

I have an excel spreedsheet with one identity... 30-40 points (lines) and 60-70 characteristics (columns).

I need to transfer this data to Autocad 2006 (no way to upgrade) and obtain the drawing as a result (points ans lines)

In the attachment, the yellow lines are the name of identity, east, north, lat, and post number (point)... the other columns are the characteristics who define complety the point

The drawing is the map of an electric grid in my city... uses posts and lines

I have tried some answers but can't obtain the drawing

Autocad versión is 2006 and excel 2013

Thanks

Re: transfer identities from excel and draw the data

Alfred.NESWADBA — Mon, 16 Sep 2019 14:23:57 GMT

Hi,

you might create a block, with attributes - one attribute for each of the data-columns in your XLS - and then use _INSERT with that block for each line in your XLS.

You can also create a script inside your XLS to run this automatically line-by-line, a sample can be found >>>here<<< (just need ATTREQ set to 1 and ATTDIA set to 0 so your attributes are transferred to the block-insertion).

- alfred -

Re: transfer identities from excel and draw the data

Anonymous — Mon, 16 Sep 2019 20:42:58 GMT

Alfred

Thanks for your reply

Is there another way, much simplier to do that?

Because I want to automate this.

In my company we upgrade and update 90% of the process but this remains as is, and the people are not so much tech to do it (15 field specialist).

The file attached show A as the identity and J as the number of it, C-D-E as que coordinates and from column K to JS as the atributes of J. This are obtained directly from ths GPS.

Is there a copy-paste method to do the drawing or another procedure?

Thanks

Re: transfer identities from excel and draw the data

Alfred.NESWADBA — Mon, 16 Sep 2019 20:46:54 GMT

Hi,

>> Is there another way, much simplier to do that?

You can write your tool that knows how to evaluate the content of the XLS and draw it into your drawing in the structure you like.

But there is no function OOTB that looks for your file and knows automatically what to do with that rows and columns.

- alfred -