首页 > 代码库 > C#:将数据网格内的数据导出到Excel
C#:将数据网格内的数据导出到Excel
?
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 | public void ExportDataToExecel(DataGridView dataGridView1) { SaveFileDialog kk = new SaveFileDialog(); kk.Title = "保存EXECL文件" ; kk.Filter = "EXECL文件(*.xls) |*.xls |所有文件(*.*) |*.*" ; kk.FilterIndex = 1; if (kk.ShowDialog() == DialogResult.OK) { string FileName = kk.FileName.Trim(); if (File.Exists(FileName)) File.Delete(FileName); System.IO.FileStream objFileStream; StreamWriter objStreamWriter; string strLine = "" ; objFileStream = new System.IO.FileStream(FileName, FileMode.OpenOrCreate, FileAccess.Write); objStreamWriter = new StreamWriter(objFileStream, System.Text.Encoding.Unicode); for ( int i = 0; i < dataGridView1.Columns.Count; i++) { if (dataGridView1.Columns[i].Visible == true ) { strLine = strLine + dataGridView1.Columns[i].HeaderText.ToString() + Convert.ToChar(9); } } objStreamWriter.WriteLine(strLine); strLine = "" ; for ( int i = 0; i < dataGridView1.Rows.Count; i++) { if (dataGridView1.Columns[0].Visible == true ) { if (dataGridView1.Rows[i].Cells[0].Value =http://www.mamicode.com/= null ) strLine = strLine + " " + Convert.ToChar(9); else strLine = strLine + dataGridView1.Rows[i].Cells[0].Value.ToString() + Convert.ToChar(9); } for ( int j = 1; j < dataGridView1.Columns.Count; j++) { if (dataGridView1.Columns[j].Visible == true ) { if (dataGridView1.Rows[i].Cells[j].Value =http://www.mamicode.com/= null ) strLine = strLine + " " + Convert.ToChar(9); else { string rowstr = "" ; rowstr = dataGridView1.Rows[i].Cells[j].Value.ToString(); if (rowstr.IndexOf( "\r\n" ) > 0) rowstr = rowstr.Replace( "\r\n" , " " ); if (rowstr.IndexOf( "\t" ) > 0) rowstr = rowstr.Replace( "\t" , " " ); strLine = strLine + rowstr + Convert.ToChar(9); } } } objStreamWriter.WriteLine(strLine); strLine = "" ; } objStreamWriter.Close(); objFileStream.Close(); MessageBox.Show( this , "保存EXCEL成功" , "提示" , MessageBoxButtons.OK, MessageBoxIcon.Information); } } |
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。