AutoCAD Map 3D General

Reply
Member
GhyslainBaril2008
Posts: 5
Registered: ‎02-16-2012
Message 1 of 8 (2,732 Views)
Accepted Solution

export object data to microsoft excel

2732 Views, 7 Replies
02-28-2012 01:03 PM

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

*Expert Elite*
Alfred.NESWADBA
Posts: 8,530
Registered: ‎06-29-2007
Message 2 of 8 (2,730 Views)

Re: export object data to microsoft excel

02-28-2012 01:20 PM in reply to: GhyslainBaril2008

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 -

-------------------------------------------------------------------------
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
Distinguished Contributor
Robert_Fritz
Posts: 137
Registered: ‎12-08-2011
Message 3 of 8 (2,710 Views)

Re: export object data to microsoft excel

02-28-2012 11:15 PM in reply to: GhyslainBaril2008

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

http://raumpatrouille3d.blogspot.ch/
*Expert Elite*
antoniovinci
Posts: 1,497
Registered: ‎06-03-2011
Message 4 of 8 (2,704 Views)

Re: export object data to microsoft excel

02-29-2012 12:31 AM in reply to: GhyslainBaril2008

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 

Member
Posts: 3
Registered: ‎04-11-2012
Message 5 of 8 (2,601 Views)

Re: export object data to microsoft excel

04-11-2012 02:49 PM in reply to: antoniovinci

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 !

 

 

 

 

 

*Expert Elite*
Alfred.NESWADBA
Posts: 8,530
Registered: ‎06-29-2007
Message 6 of 8 (2,595 Views)

Re: export object data to microsoft excel

04-11-2012 10:20 PM in reply to: harryplotter

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 -

-------------------------------------------------------------------------
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
Member
Posts: 3
Registered: ‎04-11-2012
Message 7 of 8 (2,590 Views)

Re: export object data to microsoft excel

04-12-2012 12:30 AM in reply to: Alfred.NESWADBA

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-

 

*Expert Elite*
Alfred.NESWADBA
Posts: 8,530
Registered: ‎06-29-2007
Message 8 of 8 (2,587 Views)

Re: export object data to microsoft excel

04-12-2012 12:50 AM in reply to: harryplotter

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 -

-------------------------------------------------------------------------
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Welcome to the new Autodesk Community!
If this is your first visit, click here to get started and make the most of the Community. Let us know what you think of the new experience in the Community Feedback Forum.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community