winform中，怎样把gridview的内容导出为excel文件呢？

Question

如题。想添加一个功能把gridview的表格内容导出为excel的文件格式，请问这个怎么做？？
比如用一个按钮来完成。

Answer 1

http://msdn.microsoft.com/zh-cn/architecture/microsoft.office.tools.excel.chart_members.aspx 

Answer 2

http://hi.baidu.com/yinser/blog/item/87ea5a586f9e068a800a18f1.html

Answer 3

参考:如何使用c#将Winform下DataGridView中内容导出到Excel?

Answer 4

  DataGrid导出到Excel代码 收藏
导出的函数：
public void ToExcel(System.Web.UI.WebControls dg)
{
 HttpContext.Current.Response.AppendHeader("Content-Disposition","attachment;filename=Excel.xls"); 
 HttpContext.Current.Response.Charset ="UTF-8"; 
 HttpContext.Current.Response.ContentEncoding =System.Text.Encoding.Default; 
 HttpContext.Current.Response.ContentType ="application/ms-excel";//image/JPEG;text/HTML;image/GIF;vnd.ms-excel/msword 
 dg.Page.EnableViewState =false; 
 System.IO.StringWriter tw = new System.IO.StringWriter() ; 
 System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter (tw); 
 dg.RenderControl(hw); 
 HttpContext.Current.Response.Write(tw.ToString()); 
 HttpContext.Current.Response.End(); 
}
调用：
ToExcel(DataGrid1);

Answer 5

Win 有gridview？？
直接将DataTable使用第三方控件（myxls）生成Excel

Answer 6

http://www.cnblogs.com/lovecherry/archive/2005/03/25/125519.html

Answer 7

导出excel
http://topic.csdn.net/u/20100804/11/59ba57fe-907a-41ff-96dd-7ee31bc4cfd8.html

Answer 8

http://www.shilidata.com/showforum-44.aspxoffice开发的专题，都可以参照

Answer 9

大家注意，是winform中，不是web

Answer 10

//导出EXCEL
        public static void ExportMes(DataGridView dgv)
        {
            SaveFileDialog saveFileDialog = new SaveFileDialog();
            saveFileDialog.Filter = "Execl  files  (*.xls)|*.xls";
            saveFileDialog.FilterIndex = 0;
            saveFileDialog.RestoreDirectory = true;
            saveFileDialog.CreatePrompt = true;
            saveFileDialog.Title = "导出Excel文件到";            DateTime now = DateTime.Now;
            saveFileDialog.FileName = now.Year.ToString().PadLeft(2) + "-" + now.Month.ToString().PadLeft(2, '0') + "-" + now.Day.ToString().PadLeft(2, '0') + " " + now.Hour.ToString().PadLeft(2, '0') + "点" + now.Minute.ToString().PadLeft(2, '0') + "分";
            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 < dgv.ColumnCount; i++)
                {
                    if (i > 0)
                    {
                        str += "\t";
                    }
                    str += dgv.Columns[i].HeaderText;
                }
                sw.WriteLine(str);
                //写内容    
                for (int j = 0; j < dgv.Rows.Count; j++)
                {
                    string tempStr = "";
                    for (int k = 0; k < dgv.Columns.Count; k++)
                    {
                        if (k > 0)
                        {
                            tempStr += "\t";
                        }
                        tempStr += dgv.Rows[j].Cells[k].Value.ToString();
                    }
                    sw.WriteLine(tempStr);
                }
                sw.Close();
                myStream.Close();
                //MessageBox.Show("导出成功");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            finally
            {
                sw.Close();
                myStream.Close();
            }
        }