C#输出DataGridView内容

对于查询结果经常需要输出，常用的有两种方式：

一是通过Microsoft.Office.Interop.Excel.Application来实现输出

public static bool ExportForDataGridview(DataGridView gridView, string fileName, bool isShowExcle) { 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; } private void SaveAs() { SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.Filter = "Execl files (*.xls)|*.xls"; saveFileDialog.FilterIndex = 0; saveFileDialog.RestoreDirectory = true; saveFileDialog.CreatePrompt = true saveFileDialog.Title = ""; saveFileDialog.ShowDialog(); Stream myStream; myStream = saveFileDialog.OpenFile(); StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0)); string str = ""; try { for (int i = 0; i < dgv.ColumnCount; i++) { if (i > 0) { str += "/t"; } str += dgv.Columns[i].HeaderText; } sw.WriteLine(str); for (int j = 0; j < dgvAgeWeekSex.Rows.Count; j++) { string tempStr = ""; for (int k = 0; k < dgv.Columns.Count; k++) { if (k > 0) { tempStr += "/t"; } tempStr += dgv.Rows[j].Cells[k].Value.ToString(); } sw.WriteLine(tempStr); } sw.Close(); myStream.Close(); } catch (Exception e) { MessageBox.Show(e.ToString()); } finally { sw.Close(); myStream.Close(); } } Excel.Application myexcel = new Excel.Application(); Excel.Workbook mybook = default(Excel.Workbook); Excel.Worksheet mysheet = default(Excel.Worksheet); mybook = myexcel.Workbooks.Add("ExcelFilename"); mysheet = mybook.Worksheets("sheet1"); mysheet.Activate(); mysheet.Range("A1").Select(); DataGridView.SelectAll(); System.Windows.Forms.DataObject t = new System.Windows.Forms.DataObject(); t = dv.GetClipboardContent(); System.Windows.Forms.Clipboard.SetDataObject(t); mysheet.PasteSpecial(Format = "文本", Link = false, DisplayAsIcon = false);

 

二是用数据流完成导出到EXCEL

 

private void Datagridview_toExcel(DataGridView dgv) { SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.Filter = "Execl files (*.xls)|*.xls"; saveFileDialog.FilterIndex = 0; saveFileDialog.RestoreDirectory = true; saveFileDialog.CreatePrompt = true; saveFileDialog.Title = "Export Excel File To"; Stream myStream; if (saveFileDialog.ShowDialog() == DialogResult.OK) { myStream = saveFileDialog.OpenFile(); } else { return; } //StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312")); StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0)); string str = ""; try { //写标题 for (int i = 0; i < dgv.ColumnCount; i++) { if (i > 0) { str += "/t"; } str += dgv.Columns[i].HeaderText; } sw.WriteLine(str); //写内容 for (int j = 0; j < dgv.Rows.Count; j++) { string tempStr = ""; for (int k = 0; k < dgv.Columns.Count; k++) { if (k > 0) { tempStr += "/t"; } tempStr +=dgv.Rows[j].Cells[k].Value.ToString(); } sw.WriteLine(tempStr); } sw.Close(); myStream.Close(); MessageBox.Show("数据导出成功！"); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sw.Close(); myStream.Close(); } }

 

经过我的对比，采用数据流的方式，性能比较高