首页 > 编程 > C# > 正文

C#实现将数据导出到word或者Excel中的方法

2020-01-24 01:33:16
字体:
来源:转载
供稿:网友

本文实例讲述了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();  }  } }}

希望本文所述对大家的C#程序设计有所帮助。

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表