如何将datagridview中的数据导出到Excel中？

[FlyBird2004]

如何将datagridview(动态生成、非数据源读取)中的数据导出到Excel中？

[ahniyilin]

到百度里搜一下就可以！在CSDN搜索也可以找的到的！

[lostowner]

using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms ;
using System.IO;

namespace OutputToExecl
{
public class ExportXLS
{
public ExportXLS()
{

}
public static void ExportDataGridViewToExcel(DataGridView dataGridview1)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Execl files (*.xls)|*.xls";
saveFileDialog.FilterIndex = 0;
saveFileDialog.RestoreDirectory = true;
saveFileDialog.CreatePrompt = true;
saveFileDialog.Title = "导出Excel文件到";

saveFileDialog.ShowDialog();

Stream myStream;
myStream = saveFileDialog.OpenFile();
StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
string str = "";
try
{
//写标题
for (int i = 0; i < dataGridview1.ColumnCount; i++)
{
if (i > 0)
{
str += "\t";
}
str += dataGridview1.Columns[i].HeaderText;
}

sw.WriteLine(str);
//写内容
for (int j = 0; j < dataGridview1.Rows.Count; j++)
{
string tempStr = "";
for (int k = 0; k < dataGridview1.Columns.Count; k++)
{
if (k > 0)
{
tempStr += "\t";
}
tempStr += dataGridview1.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();
}
}

}
}
以上程序屏蔽了Excel版本问题,在VS2005下测试通过

[dstw121]

怎么加代码呀

[dstw121]

我想做excel导出 怎么做呀

[dstw121]

private void tooExcel_Click(object sender, EventArgs e)
{

}

这个事件怎么写 有做的吗参考下 按上面的做的