c#中datagridview数据导出到excel源码.doc

private void button5_Click_1(object sender, EventArgs e) /建立Excel对象 Excel.Application excel = new Excel.Application(); excel.Application.Workbooks.Add(true); /生成字段名称 for (int i = 0; i dataGridView2.ColumnCount; i+) excel.Cells1,i + 1 = dataGridView2.Columnsi.HeaderText; if (y = 0) y = 1; toolStripStatusLabel6.Text = 数据导入中，请等待!; /填充数据 for (int i = 0; i dataGridView2.RowCount - 1; i+) for (int j = 0; j dataGridView2.ColumnCount; j+) if (dataGridView2j, i.Value = typeof(string) excel.Cellsi + 2, j + 1 = + dataGridView2i, j.Value.ToString(); else excel.Cellsi + 2, j + 1 = dataGridView2j, i.Value.ToString(); excel.Visible = true; =原创万能，高效-C#导出数据到Excel2008年03月18日 星期二 下午 12:56 class CommanPrint / / 导出Excel / 版权所有 : 天山寒雪 QQ:757015000 MSN: / / 控件 DataGridView / 中英文对照的标题 public static void ExportTasks(DataGridView mydgv, Dictionary dic) / 定义要使用的Excel 组件接口 / 定义Application 对象,此对象表示整个Excel 程序 Microsoft.Office.Interop.Excel.Application excelApp = null; / 定义Workbook对象,此对象代表工作薄 Microsoft.Office.Interop.Excel.Workbook workBook; / 定义Worksheet 对象,此对象表示Execel 中的一张工作表 Microsoft.Office.Interop.Excel.Worksheet ws = null; /定义Range对象,此对象代表单元格区域 Microsoft.Office.Interop.Excel.Range range; int dcell = 1; int rowindex = 0; int colindex = 0; int rowcount = mydgv.Rows.Count; int colcount = mydgv.Columns.Count; int dispcolcount = dic.Count; try /初始化 Application 对象 excelApp excelApp = new Microsoft.Office.Interop.Excel.Application(); /在工作薄的第一个工作表上创建任务列表 workBook = excelApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet); ws = (Worksheet)workBook.Worksheets1; / 命名工作表的名称为 ws.Name = Sheet1; /创建缓存 Object, objdata = new objectrowcount + 1, colcount; /创建标题 foreach (string s in dic.Keys) objdatarowindex, colindex+ = dics.ToString(); /获取数据 for (int i = 0; i rowcount; i+) dcell = 0; foreach (string ss in dic.Keys) for (int j = 0; j colcount; j+) if (mydgv.Columnsj.Name = ss) objdatai + 1, dcell+ = mydgv.Rowsi.Cellsj.FormattedValue.ToString(); /得到样式之后的值 /写入Excel range = ws.get_Range(excelApp.Cells1, 1, excelApp.Cellsrowcount, dispcolcount); range.Value2 = objdata; System.Windows.Forms.Application.DoEvents(); /设置格式 excelApp.Cells.HorizontalAlignment = Microsoft.Office.Interop.Excel.Constants.xlLeft; /全局左对齐 excelApp.Cells.EntireColumn.AutoFit(); range = ws.get_Range(excelApp.Cells1, 1, excelApp.Cells1, colcount); range.Font.Bold = true; /标题粗体 /显示 Excel excelApp.Visible = true; catch (Exception ex) throw ex; =using System;using System.Collections.Generic;using System.Text;using System.Web.UI.WebControls;using System.Data;using System.Web.UI.HtmlControls;namespace Common public class ExcelHelper / Excel导出 public static void Export(GridView dgExport, DataTable dtData) System.Web.HttpContext curContext = System.Web.HttpContext.Current; / IO用于导出并返回excel文件 System.IO.StringWriter strWriter = null; System.Web.UI.HtmlTextWriter htmlWriter = null; if (dtData != null) / 设置编码和附件格式 curContext.Response.Clear(); curContext.Response.ClearContent(); curContext.Response.Buffer = true; curContext.Response.ContentType = application/vnd.ms-excel; curContext.Response.ContentEncoding = System.Text.Encoding.GetEncoding(utf-7); curContext.Response.Charset = GB2312; curContext.Response.AppendHeader(content-disposition, filename= + System.Web.HttpUtility.UrlEncode(dtData.TableName, System.Text.Encoding.UTF8) + .xls); / 导出excel文件 strWriter = new System.IO.StringWriter(); htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter); HtmlForm frm = new HtmlForm(); frm.Attributesrunat = server; frm.Controls.Add(dgExport