XML导出到Excel。

[hunhun02]

RT
请问如果将XML导出到Excel，是用程序而不是用Excel本事。

[gislqy]

up

[hunhun02]

自己在up一下

[amingo]

Excel.Application excel;
Excel.Worksheet xSt;
Excel._Workbook xBk;
excel = new Excel.ApplicationClass();
xBk = excel.Workbooks.Add(true);

string mb_id,SqlMblb,SqldgData;
jl_id = Session["Project_id"].ToString();
dv = ( DataView ) Session["mydv"];

xSt = (Excel.Worksheet) xBk.Worksheets.Add( Missing.Value,Missing.Value,1,Missing.Value );

mb_value = "";
mb_id = dv[i]["mb_id"].ToString().Trim();
SqlMblb ="select mb_value,mblb_id from mb where mb_id="+mb_id;
SqlCommand mySQL = new SqlCommand( SqlMblb,myConn );
myConn.Open();
SqlDataReader mySDR = mySQL.ExecuteReader();
while ( mySDR.Read() )
{
mb_value = mySDR["mb_value"].ToString();
}
mySDR.Close();
XmlMap XM;
xBk.XmlImportXml( mb_value,out XM,true,"A1" );
xBk.SaveAs("c:\\我的实 验.xls",Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,XlSaveAsAccessMode.xlShared,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value );
myConn.Close();

mb_value变量里的数据是这样的：

<?xml version='1.0'?>
<?xml-stylesheet type='text/xsl' href='customers.xsl'?>
<NewDataSet>
<Table>
<CustomerID>ALFKI</CustomerID>
<CompanyName>Alfreds Futterkiste</CompanyName>
<ContactName>Maria Anders</ContactName>
<Country>Germany</Country>
<Phone>030-0074321</Phone>
</Table>
<Table>
<CustomerID>ANATR</CustomerID
><CompanyName>Ana Trujillo Emparedados y helados</CompanyName>
<ContactName>Ana Trujillo</ContactName>
<Country>Mexico</Country>
<Phone>(5) 555-4729</Phone>
</Table>
<Table>
<CustomerID>ANTON</CustomerID>
<CompanyName>Antonio Moreno Taquería</CompanyName>
<ContactName>Antonio Moreno</ContactName>
<Country>Mexico</Country>
<Phone>(5) 555-3932</Phone>
</Table>
</NewDataSet>

[shangwei97]

http://www.itwis.com/html/net/c/20080704/1935.html
参考参考吧，我觉得可以读出xml直接写如excel，但是复杂格式的可能就不行了

[twtetg]

mark

[hangang7403]

up

[500公里之外]

http://blog.csdn.net/wkxgyg/archive/2008/11/10/3265252.aspx

[hunhun02]

请问5楼的是一个类吗？要怎么引用啊。
小弟什么都不会的，请指教的详细一些，谢谢了

[YANGZHONGBAO411]

up