DataGridView导出到Excel

private void SaveAs() //另存新档按钮   导出成Excel
 
         {
 
             SaveFileDialog saveFileDialog = new SaveFileDialog();

            saveFileDialog.Filter = "Execl files (*.xls)|*.xls";

            saveFileDialog.FilterIndex = 0;

            saveFileDialog.RestoreDirectory = true;
 
             saveFileDialog.CreatePrompt = true;
 
            saveFileDialog.Title = "Export Excel File To";
 
 
           saveFileDialog.ShowDialog();
 
 
             Stream myStream;
 
             myStream = saveFileDialog.OpenFile();
 
             //StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
 
             StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));
 
             string str = "";
 
            try
 
            {
 
                 //写标题
 
                 for (int i = 0; i < dgvPatrol.ColumnCount; i++)
 
                {
 
                     if (i > 0)
 
                     {

                        str += "\t";

                   }
 
                    str += dgvPatrol.Columns[i].HeaderText;
 
                }
 
 
                 sw.WriteLine(str);
 
 
 
                //写内容
 
                 for (int j = 0; j < dgvPatrol.Rows.Count; j++)
 
                 {
 
                    string tempStr = "";
 
                     for (int k = 0; k < dgvPatrol.Columns.Count; k++)
 
                    {
 
                        if (k > 0)
 
                       {
 
                             tempStr += "\t";
 
                         }
 
                        tempStr += dgvPatrol.Rows[j].Cells[k].Value.ToString();
 
                     }
 
                    
 
                    sw.WriteLine(tempStr);                   
 
                 }
 
                 sw.Close();

              myStream.Close();

           }

           catch (Exception e)

            {

                MessageBox.Show(e.ToString());

            }

            finally

            {

                sw.Close();

                myStream.Close();

           }          

      }