C#怎么将数据导出到word或Excel中例子代码,讲述了C#实现将数据导出到word或者Excel中的方法。分享给大家参考一下。代码:
|
void
OutToWord() { if
(dataGridView1.Rows.Count >= 1) { string
tempstr = "" ; Stream myStream; SaveFileDialog dlg = new
SaveFileDialog(); dlg.Filter = "(Word文件)*.doc|*.doc" ; //dlg.Filter = "(Word文件)*.xls|*.xls"; dlg.FilterIndex = 2; dlg.RestoreDirectory = true ; if
(dlg.ShowDialog() ==DialogResult.OK) { if
((myStream = dlg.OpenFile()) != null ) { StreamWriter sw = new
StreamWriter(myStream,Encoding.GetEncoding( "gb2312" )); string
str = "" ; try { for
( int
i = 0; i < dataGridView1.ColumnCount; i++) { if
(i > 0) str += "\t\t" ; str += dataGridView1.Columns[i].HeaderText; } sw.WriteLine(str); for
( int
j = 0; j < dataGridView1.Rows.Count - 1; j++) { tempstr = "" ; for
( int
k = 0; k < dataGridView1.Columns.Count; k++) { if
(k > 0) tempstr += "\t\t" ; tempstr += dataGridView1.Rows[j].Cells[k].Value.ToString(); } sw.WriteLine(tempstr); } sw.Close(); myStream.Close(); MessageBox.Show( "已将信息导出到word" , "提示" ); } catch
(Exception ex) { MessageBox.Show(ex.ToString()); } finally { sw.Close(); myStream.Close(); } } } } |