EPPlus调用excel模板

最新推荐文章于 2023-07-14 10:23:17 发布

有一点太乖

最新推荐文章于 2023-07-14 10:23:17 发布

阅读量504

点赞数

文章标签： .net c#

本文链接：https://blog.csdn.net/qq_39218492/article/details/121072817

版权

			string text = @".\wwwroot\Excel\格式excel.xlsx";
            String MBPath = @".\wwwroot\Excel\格式excel.xlsx";//生成的模板路径
            ExcelPackage.LicenseContext = OfficeOpenXml.LicenseContext.NonCommercial;
            using (ExcelPackage App = new ExcelPackage(new FileInfo(MBPath)))
            {
                ExcelWorkbook workbook = App.Workbook;
                ExcelWorksheet sheet = workbook.Worksheets[0];
                sheet.Cells[4, 1].Value = "123";
                String savePath = @".\wwwroot\Excel\22222.xlsx";
                using (Stream stream = new FileStream(savePath, FileMode.OpenOrCreate))
                {
                    App.SaveAs(stream);
                }
                App.Dispose();

                GC.Collect();

            }