importing excel to xml file in c#

Sunil Goud14y ago

thanks its working

Hirendra Sisodiya15y ago

if you want to import xml from physical xml file into dataset than you can use this code snippet:

Dim dsPubs As New DataSet()

dsPubs.ReadXml(Filepath)

thanks

Please mark as answer if it help

vijay15y ago

hi..

if you get problem to get the data from excel file just follow this links its have result of conversion both .xls ans .xlsx conversion ..http://vbdotnetaddict.blogspot.com/2011/01/import-excel-table-into-sql-table.html

John Arcadella15y ago

You can import Excel in a DataSet and then use DataSet to export to Xml. OR you can also read Excel one by one and then create XML file and add data to it.