Import XML file to excel with existing map using ExcelPackage in C#

Question

How can I import xml file to existing excel template. I have a map (xsd).

It has to be done on server. I used excelPackage , but couldnt find any documentation for the classes.

More specific question: how do I write in C# the following code from VB.NET

Dim xmlSchema As String = "c:\Schema1.xsd" 
Map = XL.ActiveWorkbook.XmlMaps.Add(xmlSchema) 
Wb.XmlImportXml(xmlStr, oMap)

marc_s · Accepted Answer · 2010-01-27 05:50:04Z

1

There is extensive documentation and tutorials and everything on the Codeplex site for ExcelPackage:

http://excelpackage.codeplex.com/

As for your question:

if you have a XSD file, you can easily deserialize your XML file into an object graph
parse the objects as needed and insert the relevant information into a new Excel sheet based on your template

Your question is way too broad and not specific enough to be able to help with it - you'll need to make your question more specific and provide more information!

answered Jan 27, 2010 at 5:50

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

xml Over a year ago

more specific question: how do I write in C# the following code from vb: Dim xmlSchema As String = "c:\Schema1.xsd" Map = XL.ActiveWorkbook.XmlMaps.Add(xmlSchema) Wb.XmlImportXml(xmlStr, oMap)

Collectives™ on Stack Overflow

Import XML file to excel with existing map using ExcelPackage in C#

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related