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.
If you have any further questions, please feel free to post in this forum.
Best Regards,
Dillion
.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today.
None
0 Points
1 Post
Export XML data dictionnary to XLSX worksheet using OpenXML
Aug 28, 2014 10:10 AM|youness78|LINK
Hi,
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 ?
Regards
All-Star
45489 Points
7008 Posts
Microsoft
Re: Export XML data dictionnary to XLSX worksheet using OpenXML
Aug 29, 2014 02:32 AM|Zhi Lv - MSFT|LINK
Hi youness78,
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: http://code.msdn.microsoft.com/windowsapps/Open-XML-Format-SDK-20-05b5e908
Export xml data to Excel using OpenXML: http://stackoverflow.com/questions/11411252/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.
Best Regards,
Dillion
Member
90 Points
61 Posts
Re: Export XML data dictionnary to XLSX worksheet using OpenXML
Sep 17, 2014 12:03 AM|leo_456|LINK
Hello,
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
Leo
Life is made up of little things.