读取cxcel数据写入xml asp.net

[object_hellojie]

1.读取cxcel数据写入xml,最好提供下载案例
2.遍历xml代码

[机器人]

Excel -> DataTable or DataSet -> DataTable or DataSet.WriteXml

[高三石]

//从指定的excel读出信息 
string strConn="provider=Microsoft.Jet.OLEDB.4.0;data source=你的Excel文件.xls;Extended Properties=Excel 8.0;"; 
DataSet ds=new DataSet(); 
System.Data.OleDb.OleDbConnection oleConn=new System.Data.OleDb.OleDbConnection(strConn); 
System.Data.OleDb.OleDbDataAdapter oleDa=new System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]",oleConn); 
oleDa.Fill(ds,"INFO"); 
foreach(DataRow row in ds.Tables["INFO"].Rows) 
{ 
string userInfo=row[0].ToString().Trim(); 
} 

//下面是把信息写入到xml中 
DataSet ds=new DataSet(); 
oleDa.Fill(ds,"INFO"); //就是上面那个oleDa 
ds.WriteXml(文件名);

[jsm8610]

//从指定的excel读出信息
string strConn="provider=Microsoft.Jet.OLEDB.4.0;data source=你的Excel文件.xls;Extended Properties=Excel 8.0;";
DataSet ds=new DataSet();
System.Data.OleDb.OleDbConnection oleConn=new System.Data.OleDb.OleDbConnection(strConn);
System.Data.OleDb.OleDbDataAdapter oleDa=new System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]",oleConn);
oleDa.Fill(ds,"INFO");
foreach(DataRow row in ds.Tables["INFO"].Rows)
{
string userInfo=row[0].ToString().Trim();
}

//下面是把信息写入到xml中
DataSet ds=new DataSet();
oleDa.Fill(ds,"INFO"); //就是上面那个oleDa
ds.WriteXml(文件名);