MVC通过路径直接导出excel并赋值

最新推荐文章于 2024-09-22 17:06:00 发布

置顶大白1992

最新推荐文章于 2024-09-22 17:06:00 发布

阅读量1k

点赞数

分类专栏： HSSFWOrkbook 导出excel 文章标签： mvc excel path asp.net NPOI

本文链接：https://blog.csdn.net/u011936353/article/details/42169441

版权

HSSFWOrkbook 导出excel 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

          var path = Server.MapPath(@"\自考毕业审批.xls");
            var file = new FileStream(path, FileMode.Open, FileAccess.Read);
            var ws = new HSSFWorkbook(file);
            ISheet sheet = ws.GetSheet("页1");
            sheet.GetRow(12).CreateCell(14).SetCellValue(new HSSFRichTextString("张三"));

            using (var memory = new MemoryStream())
            {
                ws.Write(memory);
                Response.Clear();
                Response.ClearHeaders();
                Response.AddHeader("content-disposition", "attachment;filename=1.xls");
                Response.Buffer = true;
                Response.ContentType = "application/ms-excel";
                Response.BinaryWrite(memory.ToArray());

}

//注：无需返回值，直接void便可以

添加Npoi