C# .NET - How we create xml file through Excel file!

How we create xml file through Excel file!

See this code:

            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"..\..\test.xls");
            workbook.SaveAsXml("sample.xml");

but you need to use an MS Excel component to realize it:http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html

For this follow these steps-

1. First read that excel file and store in one dataset object.

2. After storing data to DataSet object you can use WriteXml() method of dataset object to create XML file.

Try this and let me know.