Topic: Export PipeStructureTable to Excel

[cadplayer]

Hello!
I have created a tablestyle to PipeStructureTable which have
StructurName, X, Y, RIM-, SUMP-elevation
I want export table to Excel.

Or is there annother way to can export structureInformation to a file?

[Andrey Bushman]

It maybe interesting: I did it through CSV format - it is a plain text. Video of sample and code sources are here (first video only, second video is about export to MS Access).  Mouse double click opens necessary record of that file in the MS Excel and set this row as current. I exported information of block references, but the same principle as though I would use for tables: write to CSV.

P.S. the linked article has Russian text only,  but C# code and videos are clear for understanding in my opinion.

[Keith Brown]

P.S. the linked article has Russian text only,  but C# code and videos are clear for understanding in my opinion.

I reguarly visit your site Andrey as there is alot of good information there.  The Russian is not really a problem as Google Translate automatically translates it to English for me. 

[Andrey Bushman]

I reguarly visit your site Andrey as there is alot of good information there.  The Russian is not really a problem as Google Translate automatically translates it to English for me.

Thank you. Be careful, because it is old site. I wrote it when I was learning AutoCAD .NET API and C#, therefore often it has not optimal code. I write nothing there long ago. I am sure it has a lot of my errors. Today I would do a lot of things differently. My blog is newer than it.

[cadplayer]

Not I was asking for, but looks also interesting. The problem I have is not solved in Civil3d to can export Pipenetdatas to Excelsheet. Only that way I can create PipeStructurTable, a type of Civil3d-object. My dotNet-expierence comes not so long to can easy do something... So my two questions are. How can I export Structure data(sump and rim-height) in a excel-table or how can I export a PipeStructureTable to Excel ?
_AeccAddNetworkStructTable creates this type of table in Civil3d. I can explode this table and get TEXT-entities which I can collect in a csv-file (checking here

[kaefer]

[...] how can I export a PipeStructureTable to Excel ?

Do the issues now lie on the Civil side or on the Excel side? If the latter, you might search this forum for excel late binding.

[cadplayer]

Thank you.
First I have to think about how can I snap a ObjectName (RO) = "AeccDbPipeAndStructureTable" from Civil. I didnīt found it yet.

[Jeff_M]

The Civil3d table objects do not have any properties/methods to get the data in the table. The Structure and Pipe objects, however, are fully accessible so getting the date needed from them directly is certainly possible. There is sample code for the exchange with Excel in the C3D install folder.

[cadplayer]

Yes I see, but I didnīt get run them. Something wrong with

Code: [Select]

Predefined type 'Microsoft.CSharp.RuntimeBinder.Binder' is not defined or imported


[Jeff_M]

Which version of C3D? Which Sample are you trying? Which version of Visual Studio?

[cadplayer]

Hi Jeff!
I try it in Civil3d-2014 and VisualStudio2012.
I did not realy know if it have to do something with Excel.exe I have referenced in VS2012-projekt

[Jeff_M]

Dirk, you need to add a reference for the .NET library Microsoft.CSharp and also for the COM Excel type library.

[cadplayer]

Thanks for helping Jeff, I get it /D