Last post Sep 17, 2014 12:03 AM by leo_456
Aug 28, 2014 10:10 AM|youness78|LINK
I want to export an XML file to an Excel sheet by using DocumentFormat.OpenXML library. I have implemented XmlLoader but I am not able to transform XML to XLSX.
Can I have some help please ?
Aug 29, 2014 02:32 AM|Zhi Lv - MSFT|LINK
Thanks for your posting.
According to your description, you want to export XML file to Excel by using OpenXML. Here are some articles about it, you could refer to them:
Open XML Format SDK 2.0 Sample - Convert XML to Excel File:
Export xml data to Excel using OpenXML:
If there are large amounts of data you should export, you can refer to the following links for optimizing:
Increasing Word Automation Performance for Large Amounts of Data by Using Open XML SDK
Parsing and Reading Large Excel Files with the Open XML SDK
If you think OpenXML is too much to code, have a look at ClosedXML. It's free and works as wrapper to OpenXML.
ClosedXML - The easy way to OpenXML
If you have any further questions, please feel free to post in this forum.
Sep 17, 2014 12:03 AM|leo_456|LINK
You can also try the sample codes on MSDN
Open XML Format SDK 2.0 Sample - Convert XML to Excel File
Convert Excel to XML and vice versa in C# with third-party library