GridView数据导出到EXCEL怎么做？还有using那里包含什么？
GridView数据导出到EXCEL怎么做？还有using那里包含什么？

------解决方案--------------------
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.IO;
using System.Windows.Forms;

namespace Search
{
class SaveExcel
{
/// <summary>
///
/// </summary>
/// <param name= "LineFirst "> </param>
/// <param name= "m_DataView "> </param>
/// <param name= "bTtile "> </param>
public void Excel(string[] LineFirst, System.Windows.Forms.DataGridView m_DataView,bool bTtile)
{
SaveFileDialog kk = new SaveFileDialog();
kk.Title = "保存EXECL文件 ";
kk.Filter = "EXECL文件|*.*|xls文件|*.xls|所有文件|*.* ";
kk.FilterIndex = 1;
if (kk.ShowDialog() == DialogResult.OK)
{
string FileName = kk.FileName + ".xls ";
FileStream objFileStream;
StreamWriter objStreamWriter;
string strLine = " ";
objFileStream = new FileStream(FileName, FileMode.OpenOrCreate, FileAccess.Write);
objStreamWriter = new StreamWriter(objFileStream, System.Text.Encoding.Unicode);
if (bTtile == true)
{
for (int i = 0; i < LineFirst.Length; i++)
{
strLine = LineFirst[i];

objStreamWriter.WriteLine(strLine);
strLine = " ";
}
}
for (int i = 0; i < m_DataView.Columns.Count; i++)
{
if (m_DataView.Columns[i].Visible == true)
{
strLine = strLine + m_DataView.Columns[i].HeaderText.ToString() + Convert.ToChar(9);
}
}
objStreamWriter.WriteLine(strLine);
strLine = " ";

for (int i = 0; i < m_DataView.Rows.Count; i++)
{
if (m_DataView.Columns[0].Visible == true)
{
strLine = strLine + m_DataView.Rows[i].Cells[0].Value.ToString() + Convert.ToChar(9);
}
for (int j = 1; j < m_DataView.Columns.Count; j++)
{
if (m_DataView.Columns[j].Visible == true)
{
strLine = strLine + m_DataView.Rows[i].Cells[j].Value.ToString() + Convert.ToChar(9);
}
}
objStreamWriter.WriteLine(strLine);
strLine = " ";
}
objStreamWriter.Close();
objFileStream.Close();
MessageBox.Show( "保存EXCEL成功 ");
}
else
{
;
}
}
}
}

------解决方案--------------------
Response.Clear();
Response.AddHeader( "content-disposition ", "attachment;filename=FileName.xls ");
Response.Charset = " ";
Response.ContentType = "application/vnd.xls ";