importing excel to xml file in c#

Question

importing excel file

Sunil Goud · Answer

thanks its working

Hirendra Sisodiya · Answer

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

vijay · Answer

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 Arcadella · Answer

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.