C# 导出数据到指定Excel模板

添加EPPlus引用

public void DataToExcel()
        {
           var ModelPath = System.Web.Hosting.HostingEnvironment.MapPath("~/");//程序运行路径
            var stream = FileToStream(ModelPath + "Files\\Model\\模板.xlsx");//读取模板
            var date = DateTime.Now.ToString("yyyyMMdd");
            var url = ModelPath + "Files\\Uploads\\" + date + "\\";
            var FileName = url + "测试.xlsx";
            string dicrctoryName = Path.GetDirectoryName(url);
            //如果路径不存在，创建路径
            if (!string.IsNullOrEmpty(dicrctoryName))
            {
                Directory.CreateDirectory(dicrctoryName);
            }
            //删除相同文件名的文件
            if (File.Exists(FileName))
            {
                File.Delete(FileName);
            }
            using (ExcelPackage package = new ExcelPackage(stream))
            {
                ExcelWorksheet worksheet = package.Workbook.Worksheets[1];
                worksheet.Cells[1, 2].Value ="";//第一行第二列
                worksheet.Cells[2, 1].Value = "";//第二行第一列
                worksheet.Cells[3, 3].Value= "";//第三行第三列
                //循环赋值
                //for (int i = 0; i < list.length; i++)
                //{
                    //worksheet.Cells[i, 1].Value = list[i].NAME;
                    //worksheet.Cells[i, 2].Value = list[i].Age;
                    //worksheet.Cells[i, 3].Value = list[i].Class;
               // }
                FileInfo fs = new FileInfo(FileName);
                package.SaveAs(fs);
            }
        }

读取文件

public static Stream FileToStream(string filePath)
        {
            FileStream fileStream = new FileStream(filePath, FileMode.Open, FileAccess.Read, FileShare.Read); //打开文件

            // 读取文件Byte[]
            byte[] bytes = new byte[fileStream.Length];
            fileStream.Read(bytes, 0, bytes.Length);
            fileStream.Close();

            Stream stream = new MemoryStream(bytes); //byte[]转换为Stream
            return stream;
        }