AutoCAD Text export to Excel

[Anonymous]

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!

[Alfred.NESWADBA]

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 -

[Anonymous]

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!

[Alfred.NESWADBA · Accepted solution]

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 -

[Anonymous]

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.

[Alfred.NESWADBA · Accepted solution]

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 -

[Anonymous]

Thank you Alfred.

I was able to successfully extract all my points!

[Alfred.NESWADBA]

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

[Anonymous]

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!

[Alfred.NESWADBA]

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 -

[Anonymous]

Thank you!