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

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

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.

Answers

importing excel to xml file in c#

Sunil Goud

14y

importing excel file

Answers (4)

Next Recommended Forum

importing excel file in c#

adding combobox dynamically to datagridview

Forum Statistics

Please welcome our newest member ric figueroa.
3,090,971 users have contributed to 147,405 threads and 483,581
In the past 24 hours, we have 2 new threads, 6 new posts, and 163 new users.
In last week, the most popular thread is 'C# - Chapter - How to start a Chapter in Florida, USA'.

Upcoming Events

View all

Web3 & AI Connect - Blockchain Day
Live Discussion on Startups, AI, and Career Growth
Prompt Engineering: A Must Have Skill for Everyone