首先引入dl。org.in2bits.MyXls.dll
下载地址:http://download.csdn.net/detail/tesky0125/5300853
在页面上 一个按钮“导出”,按钮的单击事件 C#代码如下:
#region 导出Excel按钮事件 protected void ExportExcelStaff1Click(object sender, EventArgs e) { try { org.in2bits.MyXls.XlsDocument tz = new org.in2bits.MyXls.XlsDocument(); tz.FileName = DateTime.Now.ToString().Replace("-", "").Replace(":", "").Replace(" ", "") + ".xls";//excel文件名称 org.in2bits.MyXls.Worksheet sheet = tz.Workbook.Worksheets.AddNamed("sheet1");//Excel工作表名称 org.in2bits.MyXls.Cells cells = sheet.Cells; int colnum = GridView_Data.Columns.Count; //获取gridview列数 for (int i = 0; i < colnum; i++) { cells.AddValueCell(1, (i + 1), GridView_Data.Columns[i].HeaderText);//导出gridView列名 } for (int i = 0; i < GridView_Data.Rows.Count; i++) { for (int j = 0; j < colnum; j++) { cells.AddValueCell((i + 2), (j + 1), GridView_Data.Rows[i].Cells[j].Text.Trim()); } } //
tz.Save(@"D:\"); //保存到指定位置 tz.Send();//把写好的excel文件输出到客户端 } catch { } } #endregion 导出Excel按钮事件