C# 操作datagridview对excel的导入导出并实现打印功能

/// <summary> /// 将传入的数据保存在同一个Excel应用程序中 /// </summary> public void dgvToExcelNEW(DataGridView datadgvMain, string _nameM, DataGridView datadgvDay, string _nameDay, DataGridView datadgvDetail, string _nameDetail) { Application app = new Microsoft.Office.Interop.Excel.Application(); Workbook wb = app.Workbooks.Add(System.Reflection.Missing.Value); Worksheet ws = null; if (datadgvDay.RowCount >= 1) { if (datadgvDetail.RowCount >= 1) { ws = newWeeksheet(datadgvDetail, _nameDetail, wb, ws,1); ws = newWeeksheet(datadgvDay, _nameDay, wb, ws, 2); ws = newWeeksheet(datadgvMain, _nameM, wb, ws, 3); } else { ws = newWeeksheet(datadgvDay, _nameDay, wb, ws, 1); ws = newWeeksheet(datadgvMain, _nameM, wb, ws, 2); } } else { ws = newWeeksheet(datadgvMain, _nameM, wb, ws,1); } app.Visible = true; } /// <summary> /// Worksheet 添加数据 /// </summary> /// <param name="datagridview">DataGridView</param> /// <param name="SheetName">SheetName</param> /// <param name="wb">Workbook case</param> /// <param name="ws">Worksheet case</param> /// <param name="iRang">工作薄在Workbook 中的index</param> /// <returns></returns> private static Worksheet newWeeksheet(DataGridView datagridview, string SheetName, Workbook wb, Worksheet ws,int iRang) { DataSet ds =new DataSet(); DataTable table = new System.Data.DataTable(); int iRows = 0; int iCols = 0; int iTrueCols = 0; if (wb.Worksheets.Count > 0) { ws = (Worksheet)wb.Worksheets.get_Item(iRang); } else { wb.Worksheets.Add(System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value); ws = (Worksheet)wb.Worksheets.get_Item(1); } if (ws != null) { if (SheetName.Trim() != "") { ws.Name = SheetName; } iRows = datagridview.Rows.Count; //加上列头行 iTrueCols = datagridview.Columns.Count; //包含隐藏的列，一共有多少列 //求列数，省略Visible = false的列 for (int i = 0; i < datagridview.Columns.Count; i++) { if (datagridview.Columns[i].Visible) iCols++; } string[,] dimArray = new string[iRows + 1, iCols]; for (int j = 0, k = 0; j < iTrueCols; j++) { //省略Visible = false的列 if (datagridview.Columns[j].Visible) { dimArray[0, k] = datagridview.Columns[j].HeaderText; k++; } } for (int i = 0; i < iRows; i++) { for (int j = 0, k = 0; j < iTrueCols; j++) { //省略Visible = false的列 if (datagridview.Columns[j].Visible) { if (datagridview.Rows[i].Cells[j].Value != null) { dimArray[i + 1, k] = datagridview.Rows[i].Cells[j].Value.ToString(); } else { dimArray[i + 1, k] = ""; } k++; } } } ws.get_Range(ws.Cells[1, 1], ws.Cells[iRows + 1, iCols]).Value2 = dimArray; ws.get_Range(ws.Cells[1, 1], ws.Cells[1, iCols]).Font.Bold = true; ws.get_Range(ws.Cells[1, 1], ws.Cells[iRows + 1, iCols]).Font.Size = 10.0; ws.get_Range(ws.Cells[1, 1], ws.Cells[iRows + 1, iCols]).RowHeight = 14.25; //ws.Columns[.ColumnWidth = datagridview.Columns[0].Width; for (int j = 0, k = 0; j < iTrueCols; j++) { //省略Visible = false的列 if (datagridview.Columns[j].Visible) { ws.get_Range(ws.Cells[1, k + 1], ws.Cells[1, k + 1]).ColumnWidth = (datagridview.Columns[j].Width / 8.4) > 255 ? 255 : (datagridview.Columns[j].Width / 8.4); //ws.Columns.c = datagridview.Columns[j].Width; k++; } } } return ws; }