Hi, I’m searching a method to import the data from a XML file to an Excel file (or DataTable), I try first to read the XML as a text and deserialize the XML string, and for each node print the name of the node with a message box but my problem is when the node is a parent it print all the data in t…

Import XML to Excel

aksh1yadav (AKSHAY YADAV) September 20, 2017, 11:59am 2

It is easy to use with Dataset because their is already an extension method available to ReadXml.

Please see attached Sample for you:
XML_2_DT.zip (3.7 KB)

Regards…!!
Aksh

3 Likes

Reading the XML file

Topic		Replies	Views
How to change a XML file to excel format Help	10	2588	August 26, 2019
Reading xml file into dataset/datatable Help datatable , studio	3	8492	January 8, 2018
Issue with reading a large XML file Help studio	4	2637	September 1, 2020
Conversion of XML to EXCEL Studio	2	1304	May 23, 2022
Import data from XML to Excel Help studio	2	1284	September 16, 2019