如何使用c#将Winform下DataGridView中内容导出到Excel.docx

原文地址：/s/blog_6d1d71e00100o37f.html转：winform中将datagirdview中数据导出到EXCEL中作者：/u/1830646240雪枫如何使用c#将Winform下DataGridView中内容导出到Excel?方法1 ：添加dll引用右击选择你所在的项目的“引用”，选择“添加引用”。弹出“添加引用”对话框。选择“COM”选项卡。选择“Microsoft Excel 12.0 Object Library”单击“确定”按钮。说明：如何发现导入的程序集不能正常工作，可能是由于office安装的缘故，请确保自定义安装office时，选择“.net可编程性支持”：代码：public static bool ExportForDataGridview(DataGridView gridView, string fileName, bool isShowExcle){//建立Excel对象Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();try{if (app == null){return false;}app.Visible = isShowExcle;Workbooks workbooks = app.Workbooks;_Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet);Sheets sheets = workbook.Worksheets;_Worksheet worksheet = (_Worksheet)sheets.get_Item(1);if (worksheet == null){return false;}string sLen = ;//取得最后一列列名char H = (char)(64 + gridView.ColumnCount / 26);char L = (char)(64 + gridView.ColumnCount % 26);if (gridView.ColumnCount 26){sLen = L.ToString();}else{sLen = H.ToString() + L.ToString();}//标题string sTmp = sLen + 1;Range ranCaption = worksheet.get_Range(sTmp, A1);string[] asCaption = new string[gridView.ColumnCount];for (int i = 0; i gridView.ColumnCount; i++){asCaption[i] = gridView.Columns[i].HeaderText;}ranCaption.Value2 = asCaption;//数据object[] obj = new object[gridView.Columns.Count];for (int r = 0; r gridView.RowCount - 1; r++){for (int l = 0; l gridView.Columns.Count; l++){if (gridView[l, r].ValueType == typeof(DateTime)){obj[l] = gridView[l, r].Value.ToString();}else{obj[l] = gridView[l, r].Value;}}string cell1 = sLen + ((int)(r + 2)).ToString();string cell2 = A + ((int)(r + 2)).ToString();Range ran = worksheet.get_Range(cell1, cell2);ran.Value2 = obj;}//保存workbook.SaveCopyAs(fileName);workbook.Saved = true;}finally{//关闭app.UserControl = false;app.Quit();}return true;}方法2用流保存成xls文件. 这种方法比较好,不用引用Excel组件. 下面是具体例子,可以参考using System.IO;using System.Text;/// summary/// 另存新档按钮/// /summaryprivate void SaveAs() //另存新档按钮 导出成Excel{SaveFileDialog saveFile