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();  }  } }}

希望本文所述對大家的C#程式設計有所協助。