TheSwamp

Code Red => .NET => Topic started by: cadplayer on December 07, 2022, 11:16:48 AM

Title: Export material report to Excel
Post by: cadplayer on December 07, 2022, 11:16:48 AM

Hello!

I wondering if someone have tried to report quantities from samplelinegroup to Excel in Civil3d.
Usually you get an xml-file with using metod
 SampleLineGroup.ReportQuantities(oidSlg, mappingNams[0], "report-01.xml", "");

I want to convert this xml-file to Excel, this is quit difficult to configure this file because I get not the length between the sections.
Have anybody a idea to can solve this?

Attach my origin Schakt5.xml-fil converted to Schakt5.xmlMaterialCrossSect.xlsx (missing sectionnames) and converted to Schakt5.xmlCrossSect.xlsx(contents sectionnames)

Thank you for all help!

Title: Re: Export material report to Excel
Post by: It's Alive! on January 11, 2023, 04:23:09 AM

didn't look at the .xlsx, maybe you can export to .CSV?

Is this .NET? not familiar with Civil3d