把WinForm的DataGridView的数据导出到Excel三种方法.docVIP

推荐使用：.net 通过NPOI或MyXls把DataTable导出到Excel ///?summary??? ///?打开Excel并将DataGridView控件中数据导出到Excel?? ///?/summary??? ///?param?name=dgvDataGridView对象?/param??? ///?param?name=isShowExcle是否显示Excel界面?/param??? ///?remarks?? ///?add?com?Microsoft?Excel?11.0?Object?Library?? ///?using?Excel=Microsoft.Office.Interop.Excel;?? ///?/remarks?? ///?returns?/returns??? public?bool?DataGridviewShowToExcel(DataGridView?dgv,?bool?isShowExcle)?? {?? ????if?(dgv.Rows.Count?==?0)?? ????????return?false;?? ????//建立Excel对象??? ????Excel.Application?excel?=?new?Excel.Application();?? ????excel.Application.Workbooks.Add(true);?? ????excel.Visible?=?isShowExcle;?? ????//生成字段名称??? ????for?(int?i?=?0;?i??dgv.ColumnCount;?i++)?? ????{?? ????????excel.Cells[1,?i?+?1]?=?dgv.Columns[i].HeaderText;?? ????}?? ????//填充数据??? ????for?(int?i?=?0;?i??dgv.RowCount?-?1;?i++)?? ????{?? ????????for?(int爅??;爅?燿gv.ColumnCount;爅++)牋 牋牋牋牋{牋 牋牋牋牋牋牋if?dgv[j,爄].ValueType?=爐ypeof(string))牋 牋牋牋牋牋牋{牋 牋牋牋牋牋牋牋牋excel.Cells[i??,爅??]???燿gv[j,爄].Value.ToString();牋 牋牋牋牋牋牋}牋 牋牋牋牋牋牋else牋 牋牋牋牋牋牋{牋 牋牋牋牋牋牋牋牋excel.Cells[i??,爅??]?燿gv[j,爄].Value.ToString();牋 牋牋牋牋牋牋}牋 牋牋牋牋}牋 牋牋}牋 牋牋return爐rue;牋 }牋 #endregion牋??#region燚ateGridView导出到csv格式的Excel?? ///?summary?? ///?常用方法，列之间加\t，一行一行输出，此文件其实是csv文件，不过默认可以当成Excel打开。?? ///?/summary?? ///?remarks?? ///?using?System.IO;?? ///?/remarks?? ///?param?name=dgv/param?? private?void?DataGridViewToExcel(DataGridView?dgv)?? {?? ????SaveFileDialog?dlg?=?new?SaveFileDialog();?? ????dlg.Filter?=?Execl?files?(*.xls)|*.xls;?? ????dlg.FilterIndex?=?0;?? ????dlg.RestoreDirectory?=?true;?? ????dlg.CreatePrompt?=?true;?? ????dlg.Title?=?保存为Excel文件;?? ?? ????if?(dlg.ShowDialog()?==?DialogResult.OK)?? ????{?? ????????Stream?myStream;?? ????????myStream?=?dlg.OpenFile();?? ????????StreamWriter?sw?=?new?StreamWriter(myStream,?System.Text.Encoding.GetEncoding(-0));?? ????????string?columnTitle?=?;?? ???????