XML导出到Excel。 RT请问如果将XML导出到Excel,是用程序而不是用Excel本事。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 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> http://www.itwis.com/html/net/c/20080704/1935.html参考参考吧,我觉得可以读出xml直接写如excel,但是复杂格式的可能就不行了 http://blog.csdn.net/wkxgyg/archive/2008/11/10/3265252.aspx System.Text.Encoding.UTF8.GetBytes问题! 关于SSL 加密 Dictionary的使用,内部会按key排序吗? 设置了app.config中的probing字段为什么还是提示找不到关联 C#编码实现 EXE文件自动输入用户密码并登入 新手求助 VBNET有typeof...is...,C#中对应的是那个呢? 问一个字符串分割的问题,问玩就给分! 有没有用c#写的读取mp3的tag信息的例子啊? 彻底解决 CrystalReports 登录失败问题(海波.NET) 请问怎么设置TextBox(Winforms)中到文字垂直居中 智能手机 向服务器上传图片问题
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>
参考参考吧,我觉得可以读出xml直接写如excel,但是复杂格式的可能就不行了