求c# 对excel读取写入的代码 带注释最好

求c# 对excel读取写入的代码 带注释最好

string style = @"<style> .text { mso-number-format:\@; } </script> ";
//清空
response.ClearContent();
//导出格式
response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");
response.ContentType = "application/ms-excel";
response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
//创建流
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gv.RenderControl(htw);

response.Write(style);
response.Write(sw.ToString());
response.End();

//必须的方法
public override void VerifyRenderingInServerForm(Control control)
{

}
以上是导出
~~~~~~~~~
以下是导入
private DataSet CreateDataSource()
{
string strCon;
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("excel.xls") + "; Extended Properties=Excel 8.0;";
OleDbConnection olecon = new OleDbConnection(strCon);
OleDbDataAdapter myda = new OleDbDataAdapter("SELECt * FROM [Sheet1$]", strCon);
DataSet myds = new DataSet();
myda.Fill(myds);
return myds;
}
protected void Button1_Click(object sender, EventArgs e)
{
GridView1.DataSource = CreateDataSource();
GridView1.DataBind();
}

好吧，是不是很简单呢？

string style = @"<style> .text { mso-number-format:\@; } </script> "; //清空 response.clearcontent(); //导出格式 response.addheader("content-disposition", "attachment; filename=myexcelfile.xls"); response.contenttype = "application/ms-excel"; response.contentencoding = system.text.encoding.getencoding("gb2312"); //创建流 stringwriter sw = new stringwriter(); htmltextwriter htw = new htmltextwriter(sw); gv.rendercontrol(htw); response.write(style); response.write(sw.tostring()); response.end(); //必须的方法 public override void verifyrenderinginserverform(control control) { } 以上是导出 ~~~~~~~~~ 以下是导入 private dataset createdatasource()   {   string strcon;   strcon = "provider=microsoft.jet.oledb.4.0;data source=" + server.mappath("excel.xls") + "; extended properties=excel 8.0;";   oledbconnection olecon = new oledbconnection(strcon);   oledbdataadapter myda = new oledbdataadapter("select * from [sheet1$]", strcon);   dataset myds = new dataset();   myda.fill(myds);   return myds;   }   protected void button1_click(object sender, eventargs e)   {   gridview1.datasource = createdatasource();   gridview1.databind();   } 好吧，是不是很简单呢？