datagridview列表导出到EXCEL方法

 

  /// <summary>
        /// 保存datagridview到excel
        /// </summary>
        /// <param name="dgv">datagridview列表</param>
        /// <param name="fileName">另存文件名</param>
        public static void SaveAs(DataGridView dgv) //另存新档按钮   导出成Excel
        {

            SaveFileDialog saveFileDialog = new SaveFileDialog();

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

            saveFileDialog.FilterIndex = 0;

            saveFileDialog.RestoreDirectory = true;

            saveFileDialog.CreatePrompt = true;
            saveFileDialog.Title = "导出文件到";
            if (saveFileDialog.ShowDialog() == DialogResult.Cancel)
                return;
           
            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
            {
                //写标题
                foreach (DataGridViewColumn dgvColumn in dgv.Columns)
                {
                    if (dgvColumn.Visible == true)
                    {
                        str += dgvColumn.HeaderText;
                        str += "/t";
                    }
                }
                sw.WriteLine(str);

                //写内容
                foreach (DataGridViewRow dgvRow in dgv.Rows)
                {
                    string tempStr = "";
                    foreach (DataGridViewCell dgvCell in dgvRow.Cells)
                    {
                        if (dgvCell.Visible == true)
                        {
                            tempStr += dgvCell.Value.ToString();
                            tempStr += "/t";
                        }
                    }
                    sw.WriteLine(tempStr);
                }
                sw.Close();
                myStream.Close();
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString());
            }
            finally
            {
                sw.Close();
                myStream.Close();
            }

        }