请使用以下代码生成基于xml的excel文件。





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）;

}

Please use the following code generating excel file based on the xml.


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);
}