c# 将gridview保存为excel 2007

2014-05-26 11:25:43 299 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

C# 导出 Excel 的各种方法总结第一种：使用 Microsoft.Office.Interop.Excel.dll 首先需要安装 office 的 excel，然后再找到Microsoft.Office.Interop.Excel.dll 组件，添加到引用。 View Code View Code 第一种方法性能实在是不敢恭维，而且局限性太多。首先必须要安装 office（如果计算机上面没有的话），而且导出时需要指定文件保存的路径。也可以输出到浏览器下载，当然前提是已经保存写入数据。第二种：使用Aspose.... 阅读详情

本人自己写的保存为2003版本的格式的，可是用2007的打开总是有乱码，而且弹出格式不对的对话框，如何保存为2007版本的呀？
我的代码如下：

 protected void Button1_Click(object sender, EventArgs e)

        {

            string XX = Label1.Text + Label3.Text;

            Export("application/ms-excel", XX + "月份采购计划.xls");

        }





        public override void VerifyRenderingInServerForm(Control control)

        {



        }



        private void Export(string FileType, string FileName)

        {

            Response.Charset = "GB2312";

            Response.ContentEncoding = System.Text.Encoding.UTF8;

            Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());

            Response.ContentType = FileType;

            this.EnableViewState = false;

            StringWriter tw = new StringWriter();

            HtmlTextWriter hw = new HtmlTextWriter(tw);

            GridView1.RenderControl(hw);

            Response.Write(tw.ToString());

            Response.End();

        }

...全文

SAP EWM 内向交货流程（一）本文介绍了SAP EWM系统中内向交货单的基本配置与操作流程。阅读详情

时间都去哪了啊

C# 111,129 成员 642,538 内容

+ 关注 + 加入社区

切换为时间正序

时间都去哪了啊 2014-06-03

打赏
举报

引用 2 楼 kingredapple 的回复:

Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; 试试

试了不行呀.....

郑州高新区WPF小王子 2014-05-26

打赏
举报

测试这段代码


 GridView gv = new GridView();  
                     gv.DataSource = dtError;  
                      gv.DataBind();  
                    gv.Attributes.Add("style", "vnd.ms-excel.numberformat:@");  

                      HttpResponse hResponse = this.Response;  
                   string fileName1 = "新员工格式验证错误统计" + DateTime.Now.ToString("yyyyMMdd");  
  
                    hResponse.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(fileName1, System.Text.Encoding.UTF8) + ".xls");  
                    hResponse.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");  
                    hResponse.ContentType = "application/ms-excel";  
                       this.EnableViewState = false;  

                  StringWriter tw = new StringWriter();  
                    System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);  
                gv.RenderControl(hw);  

                    hResponse.Write(tw);  
                     hResponse.End();

kingredapple 2014-05-26

打赏
举报

Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; 试试

by_封爱版主 2014-05-26

打赏
举报


using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;


/// <summary>
        /// 将DataTable数据导出到Excel文件中(xlsx)
        /// </summary>
        /// <param name="dt"></param>
        /// <param name="file"></param>
        public static void TableToExcelForXLSX(DataTable dt, string file)
        {
            XSSFWorkbook xssfworkbook = new XSSFWorkbook();
            ISheet sheet = xssfworkbook.CreateSheet("Test");

            //表头
            IRow row = sheet.CreateRow(0);
            for (int i = 0; i < dt.Columns.Count; i++)
            {
                ICell cell = row.CreateCell(i);
                cell.SetCellValue(dt.Columns[i].ColumnName);
            }

            //数据
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                IRow row1 = sheet.CreateRow(i + 1);
                for (int j = 0; j < dt.Columns.Count; j++)
                {
                    ICell cell = row1.CreateCell(j);
                    cell.SetCellValue(dt.Rows[i][j].ToString());
                }
            }

            //转为字节数组
            MemoryStream stream = new MemoryStream();
            xssfworkbook.Write(stream);
            var buf = stream.ToArray();

            //保存为Excel文件
            using (FileStream fs = new FileStream(file, FileMode.Create, FileAccess.Write))
            {
                fs.Write(buf, 0, buf.Length);
                fs.Flush();
            }
        }

自己去下载NPOI.dll

c# 将gridview保存为excel 2007

相关推荐