【机房合作】——导出Excel表格

   在

  public ExportToExcel(DataGridView datagridview)
      {
 //创建一个新的Excel
            //Microsoft.Office.Interop.Excel.Application myExcel = new Microsoft.Office.Interop.Excel.Application();
            打开excel工作簿，显示excel界面
            //myExcel.Application.Workbooks.Add(true);
            获取桌面路径
            //string path = System.Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
            将excel保存在桌面
            //myExcel.ActiveWorkbook.SaveAs(path + Name, ReadOnlyRecommended: false);
            //StreamWriter sw = new StreamWriter(path + Name, false, System.Text.Encoding.Default);
            SaveFileDialog saveFileDialog = new SaveFileDialog();
            saveFileDialog.Filter = "Execl files (*.xls)|*.xls";
            saveFileDialog.FilterIndex = 0;
            saveFileDialog.RestoreDirectory = true;
            saveFileDialog.CreatePrompt = false;
            saveFileDialog.Title = "导出Excel文件到";
            // saveFileDialog.FileName = text;
            DialogResult result = saveFileDialog.ShowDialog();
            //string str = "";
            if (result == DialogResult.OK)
            {
                Stream myStream;
                myStream = saveFileDialog.OpenFile();
                StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
                string str = "";
                try
                {
                    for (int i = 0; i < datagridview.ColumnCount; i++)
                    {
                        if (i > 0)
                        {
                            str += "\t";
                        }
                        str += datagridview.Columns[i].HeaderText;
                    }
                    sw.WriteLine(str);
                   
                    for (int j = 1; j < datagridview.Rows.Count; j++)
                    {
                        string tempStr = "";
                        for (int k = 0; k < datagridview.Columns.Count; k++)
                        {
                            if (k > 0)
                            {
                                tempStr += "\t";
                            }
                            tempStr += datagridview.Rows[j - 1].Cells[k].Value.ToString();

                        }
                        sw.WriteLine(tempStr);
                    }                    

                }

                catch (Exception)
                {

                    MessageBox.Show("导出遇到异常", "失败提示");
                }
                finally
                {
                    MessageBox.Show("成功导出到excel", "提示");
                    sw.Close();
                    myStream.Close();
                    }
            }
        }