Export XML data dictionnary to XLSX worksheet using OpenXML [Answered]RSS

• • Reply
  youness78

  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

• • Reply
  Zhi Lv - MSF...

  All-Star

  45439 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

  MSDN Community Support
  Please remember to click "Mark as Answer" the responses that resolved your issue.
  If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
  
• • Reply
  leo_456

  Member

  80 Points

  59 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

  Thanks and Regards.
  Leo
  
  Life is made up of little things.