使用C#将DataGridView数据导出到Excel

DataGridView直接导出EXCEL
1.直接将DataGridView显示的内容导出Excel


 1public void DataToExcel(DataGridView m_DataView)
 2        {
 3            SaveFileDialog kk = new SaveFileDialog(); 
 4            kk.Title = "保存EXECL文件"; 
 5            kk.Filter = "EXECL文件(*.xls) |*.xls |所有文件(*.*) |*.*"; 
 6            kk.FilterIndex = 1;
 7            if (kk.ShowDialog() == DialogResult.OK) 
 8            { 
 9                string FileName = kk.FileName + ".xls";
10                if (File.Exists(FileName))
11                    File.Delete(FileName);
12                FileStream objFileStream; 
13                StreamWriter objStreamWriter; 
14                string strLine = ""; 
15                objFileStream = new FileStream(FileName, FileMode.OpenOrCreate, FileAccess.Write); 
16                objStreamWriter = new StreamWriter(objFileStream, System.Text.Encoding.Unicode);
17                for (int i = 0; i  < m_DataView.Columns.Count; i++) 
18                { 
19                    if (m_DataView.Columns[i].Visible == true) 
20                    { 
21                        strLine = strLine + m_DataView.Columns[i].HeaderText.ToString() + Convert.ToChar(9); 
22                    } 
23                } 
24                objStreamWriter.WriteLine(strLine); 
25                strLine = ""; 
26