How to read excel file using xmldocument

Question

I need to read the Excel data using Xmldocument.Plz help me

Sorry, this is off-topic for this site. – SPDoctor Nov 05 '12 at 16:16 — SPDoctor, Nov 05 '12 at 16:16

score 0 · Answer 1 · answered Nov 05 '12 at 12:07

You shouldn't.

Better use Office Open XML libraries from Microsoft.

I can't give some code but, you have to extract xlsx contents with System.IO.Packaging, find the sheet you need, and then load it in XmlDocument.

But be advised that it is quite tricky and has many caveats to do so.

1 Answers1