topic Re: AutoCAD Text export to Excel in AutoCAD Forum

AutoCAD Text export to Excel

Anonymous — Tue, 28 Feb 2017 05:52:55 GMT

I have to export xyz coordinates. But my z coordinates have not been input as coordinate but as a mtext.

How can I export my coordinates?

Can I convert the mtext file to text file and try exporting the text file and its corresponding x and y coordinates?

Thank you!

Re: AutoCAD Text export to Excel

Alfred.NESWADBA — Tue, 28 Feb 2017 06:16:29 GMT

Hi,

>> How can I export my coordinates?

Command _DATAEXTRACTION (>>>details<<<).

>> Can I convert the mtext file to text file

What is a "mtext file"?

- alfred -

Re: AutoCAD Text export to Excel

Anonymous — Tue, 28 Feb 2017 08:13:51 GMT

Hi,

It was ,multi-line text file, which i have now exploded to make a text file.

My problem is that my z coordinates are in text form and not as points.

Any suggestions as to what can be done?

Thank you!

Re: AutoCAD Text export to Excel

Alfred.NESWADBA — Tue, 28 Feb 2017 08:20:20 GMT

Hi,

>> It was ,multi-line text file, which i have now exploded to make a text file.

The word "file" makes me unsure about what you mean, a file is stored on your harddisk or network, but it's nothing used in AutoCAD.

Do you mean MTEXT as graphic object in AutoCAD?

>> My problem is that my z coordinates are in text form and not as points

Why not using _DATAEXTRACTION? You can export the text-content with that command too, so you have X and Y from the insertion point (or alignment point) and the Z-value from the text-content of your TEXT or MTEXT object.

- alfred -

Re: AutoCAD Text export to Excel

Anonymous — Tue, 28 Feb 2017 08:44:23 GMT

Yes, It works.

Does the data extracting points all be in the current layer?

Or can they be selected by swiping across them?

Because when I do that not all data are getting extracted.

Re: AutoCAD Text export to Excel

Alfred.NESWADBA — Tue, 28 Feb 2017 08:50:19 GMT

Hi,

>> Does the data extracting points all be in the current layer?

By default _DATAEXTRACTION does not look to layers, it takes all objects you select as object type independent of the layers they are sitting on.

However you can add the layer-name to the output-fields and then filter (on the wizard page where you get the preview of the data) based on specific layers.

Another option with _DATAEXTRACTION is to select the objects manually (I think it's on page 2 of the wizard), but that's unusual as you need to select objects whereas the function can select all by itself (and other reasons).

- alfred -

Re: AutoCAD Text export to Excel

Anonymous — Tue, 28 Feb 2017 09:08:32 GMT

Thank you Alfred.

I was able to successfully extract all my points!

Re: AutoCAD Text export to Excel

Alfred.NESWADBA — Tue, 28 Feb 2017 09:17:05 GMT

Thx for feedback, good to know you got it working, - alfred -

Re: AutoCAD Text export to Excel

Anonymous — Fri, 07 Apr 2017 11:21:40 GMT

Hello,

I have problems exporting into xlz txt file ...

I tried with dataextractin but I get dxe file.

I installed lps application in AutoCAD (I saw that's the solution here: http://lee-mac.com/ptmanager.html, but I still don't know how to export.

I need it, cuz I want to import the terrain later in ArchiCad.

Thank you for help!

Re: AutoCAD Text export to Excel

Alfred.NESWADBA — Fri, 07 Apr 2017 11:56:49 GMT

Hi,

>> I tried with dataextractin but I get dxe file.

Dataextraction creates 2 files:

DXE holds the definition for what to export, and the settings like which parameters, sorting, ... that does not hold the exported data
XLS or CSV or MDB which holds the exported data (as long as you have specified to export a file and not just import the data as AutoCAD Table object) ==> that is what you are looking for

- alfred -

Re: AutoCAD Text export to Excel

Anonymous — Fri, 07 Apr 2017 13:02:42 GMT

Thank you!