how to convert xml to excel sheet of same name using c#.net

Question

I use following code and its working. But every time it create an excel sheet with same name.

Can anybody tell me how export excel sheet with same name as XML sheet has???????

    private void button2_Click(object sender, EventArgs e)
    {
        MSDN.Sample.XMLToExcel.OpenXMLOffice objTest = new MSDN.Sample.XMLToExcel.OpenXMLOffice();
        objTest.XMLToExcel(textBox14.Text);
        MessageBox.Show("Umpire Report Extracted successfully.");
    }

I don't understand your question at all. Please revise it.

Moha Dehghan
– Moha Dehghan

2013-04-23 04:21:50 +00:00
Commented Apr 23, 2013 at 4:21 — Moha Dehghan
– Moha Dehghan, Commented Apr 23, 2013 at 4:21
see if this helps.

wy__
– wy__

2013-04-23 04:23:24 +00:00
Commented Apr 23, 2013 at 4:23 — wy__
– wy__, Commented Apr 23, 2013 at 4:23

Moha Dehghan · Accepted Answer · 2013-04-23 04:53:39Z

2

Your given sample uses DataSet.ReadXml to convert the XML file to a DataSet, and then uses the name of the DataSet (DataSet.DataSetName) for the file name, and the name of the table (DataTable.TableName) as the sheet name. ReadXml selects those names based the contents of the XML file. If you want to change that behavior, you have two options:

Create a method that creates the Excel as you wish:

Add this to OpenXMLOffice class:

public void XMLToExcel(string strXMLPath, string outputFileName, string sheetName)
{
    string strPath = Path.GetDirectoryName(strXMLPath);
    DataSet dsXML = new DataSet();
    dsXML.ReadXml(strXMLPath);
    strPath = strPath + "\\" + outputFileName + ".xlsx";
    DataTable tblXML = dsXML.Tables[0];
    tblXML.TableName = sheetName;
    DataTableToFilePath(tblXML, strPath);
}

and call it like this:

var objTest = new MSDN.Sample.XMLToExcel.OpenXMLOffice();
objTest.XMLToExcel(textBox14.Text, "My Excel", "My Sheet");

Change the contents of the XML file:
- Change the root node to change output file name.
- Change the second level node names to change the sheet name.

answered Apr 23, 2013 at 4:53

Moha Dehghan

18.5k3 gold badges60 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Moha Dehghan Over a year ago

@ShrirangWyawahare If the answers helped you, you should mark it as accepted answer. This way you (and me) earn reputation, and also it helps other people with same problem. Please read FAQ for more information.

Collectives™ on Stack Overflow

how to convert xml to excel sheet of same name using c#.net

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related