Author Topic: Export material report to Excel  (Read 1664 times)

0 Members and 1 Guest are viewing this topic.

cadplayer

  • Bull Frog
  • Posts: 390
  • Autocad Civil3d, OpenDCL.Runtime, LISP, .NET (C#)
Export material report to Excel
« 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!



It's Alive!

  • Retired
  • Needs a day job
  • Posts: 8691
  • AKA Daniel
Re: Export material report to Excel
« Reply #1 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