topic export object data to microsoft excel in AutoCAD Map 3D Forum

export object data to microsoft excel

Anonymous — Tue, 28 Feb 2012 21:03:30 GMT

Hi,

I have a object data table attached to many polygon. In this table i have 2 line of data. I want to export in a tabloid like microsoft excel. I know autocad have a command to do this...

Thanks a lot for your help

Re: export object data to microsoft excel

Alfred.NESWADBA — Tue, 28 Feb 2012 21:23:04 GMT

Hi,

the way I know is:

save your drawing and close it
create a new drawing
attach the previous drawing with command _ADEDRAWINGS
query the objects from the attached drawing (command _ADEQUERY) and create a list as a result (instead of querying the objects into the active/new drawing).

Good luck, - alfred -

Re: export object data to microsoft excel

Anonymous — Wed, 29 Feb 2012 07:15:03 GMT

Hi,

another way is to export your objects to ESRI SHP including the object data (command: _mapexport). It creates a DBase file (*.dbf) for the attribute data. The file can be opened in EXCEL.

Rob

Re: export object data to microsoft excel

antoniovinci — Wed, 29 Feb 2012 08:31:25 GMT

Well, the quickest way to get your goal is probably this:

1] issue the _MAPVIEWTBL command

2] OK

3] select all the rows, and then CTRL-C

4] in Excel, paste them

Re: export object data to microsoft excel

Anonymous — Wed, 11 Apr 2012 21:50:32 GMT

i have a problem like this issue...

i have more features with some data properties in their schema

like this

feature1 geometry, prop1 (string), prop2(string) etc.... etc...

feature2 geometry, prop2 (string), prop3(string), prop4(string) etc.... etc...

feature3 ......

so i like to have a table in wich i can view a complete report of all features whit their properties

a manual way to do this il opening all data tables, selecting coping and pasting in excel... but i'd like to find a command or macro way to do this automatically

is there a way to do this by a query ? or better whit a spatial query ?

thanks to all !

Re: export object data to microsoft excel

Alfred.NESWADBA — Thu, 12 Apr 2012 05:20:18 GMT

Hi,

you can try to use _MAPEXPORT to create a SHP-file, select your objectdata tables to be included in export.

After that is done you have 3 files created, a SHP, a SHX and a DBF ==> open the DBF in e.g. Excel.

Is that what you were looking for?

- alfred -

Re: export object data to microsoft excel

Anonymous — Thu, 12 Apr 2012 07:30:42 GMT

hi alfred

thank you very much for your answer

yes it could be a very good solution

but it does not work if i have only sdf geographical entityes in each feature. I've not defined any object classes, but only a schema and drawed geographical entities.

I'm an expert user in Autocad but i'm newbee in map, so i don't know if my metod is very good....

1) i've got cad drawings whit polilines and polygons,

2) i've created a query after having associated them,

3) i've exorted the queried entities to a sdf file,

4) i've modified the schema, adding some property data,

5) i've modified or added the geographical entities on each feature in the schema....

now i have to make a report of all the entityes in excel....

your method could be very good for me but it seems does not work whit sdf features....

Thanks

-marco-

Re: export object data to microsoft excel

Alfred.NESWADBA — Thu, 12 Apr 2012 07:50:14 GMT

Hi,

>> but it seems does not work whit sdf features....

Create a new drawing, us _MAPIMPORT to import your SDF and don't forget to create ODTables from the attribtive data in the SDF, then you can export as described.

And if you alread have SDF, you can open the datagrid for each sdf and use copy&paste or export (under options, button on bottom of grid-view).

Good luck, - alfred -

Re: export object data to microsoft excel

Anonymous — Tue, 24 Jun 2014 12:31:11 GMT

hi
how to creat the ode table from sdf file
it seems that the sdf when imported have a different language

Re: export object data to microsoft excel

Alfred.NESWADBA — Tue, 24 Jun 2014 17:03:06 GMT

Hi,

welcome @forums.autodesk.com!

>> how to creat the ode table from sdf file

When you have started _MAPIMPORT, selected the file to import the dialog appears showing the input layer in a list, the 4th column in the list is "Data" with content "<None>" for that layer, click onto that cell to make it active, you get a small "..." icon, click onto it and you get the options to convert the SDF-attributive data into ObjectData.

>> it seems that the sdf when imported have a different language

Sorry to not understand that, how can data have a languate (that's what I don't understand here).

HTH, - alfred -

Re: export object data to microsoft excel

Anonymous — Wed, 25 Jun 2014 06:29:10 GMT

Many thanks alfred for your support
ok i did that
then i defined object data from MAP Setup menu and in the object data field i select the field target but nothing appeared
shall i have to creat table from the home menue? because when i tried that ( to open data table you need to have a map layer).

exactly what i need
i have a dwg with mutiple lines
each one for sure has a start and end (xyz)
i need this data in table
start     end
x           x
y            y
z            z

thanks

Re: export object data to microsoft excel

Alfred.NESWADBA — Wed, 25 Jun 2014 13:20:35 GMT

Hi,

I'm not sure that I understood your question?

From your words:
>> ok i did that
>> then i defined object data

If you did _MAPIMPORT and followed my video you should not have to create a datatable, it should be created by the import!

What am I missing?

- alfred -

Re: export object data to microsoft excel

Anonymous — Thu, 26 Jun 2014 07:17:23 GMT

Hello,

Many thanks for your efforts, this is highly appreciated.

To put things in order
I will simplify my request.
I have a simple cad drawing contains a number of lines
I need to get an excel or text file that contains the start and end (x,y,z) for these lines.
can we go into steps.

Re: export object data to microsoft excel

Murph_Map — Thu, 26 Jun 2014 10:57:19 GMT

@Anonymous wrote:

Hello,

Many thanks for your efforts, this is highly appreciated.

To put things in order
I will simplify my request.
I have a simple cad drawing contains a number of lines
I need to get an excel or text file that contains the start and end (x,y,z) for these lines.
can we go into steps.

Use the Data Extration wizard,

http://www.youtube.com/watch?v=glziAlsuAX8

Just select the start X,Y,Z and end x,y,z for the lines under the geometry data.

Re: export object data to microsoft excel

Anonymous — Thu, 26 Jun 2014 14:18:00 GMT

I would like to thank everyone for help and support

Mohammad Atieh.

Re: export object data to microsoft excel

randybucao-SCG — Fri, 23 Jun 2023 14:55:02 GMT

yes.. 11 YEARS later.. LOL... Thanks for posts.