asp.net操作Excel，读取、导出，操作大全代码,Asp.Net代码库,德仔网

代码语言
代码分类
【Asp.Net】 asp.net操作Excel，读取、导出，操作大全
作者:Dezai.CN / 发布于2011/5/4/ 614
<div>先引入：using System.Runtime.InteropServices; 
 using System.Data.OracleClient;
读取代码
</div>
<div>DataTable mytable =new System.Data.DataTable();
 DataSet DS = new System.Data.DataSet();
 string path="",f_folder,f_name,strConn,sql;
 try
 {
 path=File1.Value.ToString(); 
 if( path =="")
 {
 Response.Write("<script>alert('请选择Excel文件路径!')</script>");
 return;
 }
 f_folder = Server.MapPath("upfile\") ;
 f_name = System.DateTime.Now.ToString() ;</div>
<div> f_name = f_name.Replace(" ", "");
 f_name = f_name.Replace("-", "");
 f_name = f_name.Replace(":", "");
 f_name = f_folder + f_name + ".xls"; 
 File1.PostedFile.SaveAs(f_name);</div>
<div> strConn = "Provider=Microsoft.Jet.OleDb.4.0;data source=" + f_name + ";Extended Properties=Excel 8.0";
 
 sql = "Select * FROM [Sheet1$]";
 
 
 System.Data.OleDb.OleDbConnection objConn= new System.Data.OleDb.OleDbConnection(strConn);
 objConn.Open();
 System.Data.OleDb.OleDbDataAdapter obj= new System.Data.OleDb.OleDbDataAdapter(sql, objConn);
 
 obj.Fill(DS, "EXCELDATA"); 
 obj.Dispose();
 objConn.Close();

 mytable = DS.Tables["EXCELDATA"]; 
 int s=mytable.Rows.Count; 
 DataGrid1.DataSource = mytable.DefaultView;
 DataGrid1.DataBind();</div>
<div>导出Excel：
</div>
<div>string sData= DateTime.Today.ToString("yyyy-MM-dd");
 Response.Clear();
 Response.Buffer = true;
 Response.Charset = "utf-8";</div>
<div> Response.AppendHeader("Content-Disposition","attachment;filename=WDExcel_"+sData+".xls");
 Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");</div>
<div> Response.ContentType = "application/ms-excel";
 this.EnableViewState = false;</div>
<div> System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
 HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);</div>
<div> Datagrid1.RenderControl(oHtmlTextWriter);
 Response.Write(oStringWriter.ToString());
 Response.End();

写入Excel文档： 
</div>
<div>public bool SaveFP2toExcel(string Path)
 {
 try
 {
 string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source="+ Path +";"+"Extended Properties=Excel 8.0;";
 OleDbConnection conn = new OleDbConnection(strConn);
 conn.Open(); 
 System.Data.OleDb.OleDbCommand cmd=new OleDbCommand ();
 cmd.Connection =conn;
 //cmd.CommandText ="UPDATE [sheet1$] SET 姓名=&prime;2005-01-01&prime; WHERE 工号=&prime;日期&prime;";
 //cmd.ExecuteNonQuery ();
 for(int i=0;i<fp2.Sheets [0].RowCount -1;i++)
 {
 if(fp2.Sheets [0].Cells[i,0].Text!="")
 {
 cmd.CommandText ="INSERT INTO [sheet1$] (工号,姓名,部门,职务,日期,时间) VALUES(&prime;"+fp2.Sheets [0].Cells[i,0].Text+ "&prime;,&prime;"+
 fp2.Sheets [0].Cells[i,1].Text+"&prime;,&prime;"+fp2.Sheets [0].Cells[i,2].Text+"&prime;,&prime;"+fp2.Sheets [0].Cells[i,3].Text+
 "&prime;,&prime;"+fp2.Sheets [0].Cells[i,4].Text+"&prime;,&prime;"+fp2.Sheets [0].Cells[i,5].Text+"&prime;)";
 cmd.ExecuteNonQuery ();
 }
 }
 conn.Close ();
 return true;
 }
 catch(System.Data.OleDb.OleDbException ex)
 {
 System.Diagnostics.Debug.WriteLine ("写入Excel发生错误："+ex.Message );
 }
 return false;
 }
<div></div>
试试其它关键字
　操作Excel　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)