C# EPPlus创建excel、读写excel，设置表格样式

首先在NuGet下载EPPlus包

创建Excel并写入内容

  /// <summary>
        /// 创建Excel
        /// </summary>
        public void CrateExcel()
        {
            //文件保存路径
            string path = "F:/text.xlsx";
            FileInfo fileInfo = new FileInfo(path);
            using (ExcelPackage package = new ExcelPackage(fileInfo))
            {
                //创建sheet1
                ExcelWorksheet sheet = package.Workbook.Worksheets.Add("sheet1");
                //设置基本样式
                sheet.Cells.Style.Font.Name = "宋体";
                sheet.Cells.Style.Font.Size = 11F;
                sheet.Cells.Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
                sheet.Cells.Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
                //设置指定单元格内容
                sheet.Cells[1, 1].Value = "降板高度";
                sheet.Cells[1, 2].Value = "生成填充区域";
                sheet.Cells[1, 3].Value = "颜色R";
                sheet.Cells[1, 4].Value = "颜色G";
                sheet.Cells[1, 5].Value = "颜色B";
                sheet.Cells[1, 6].Value = "RGB值";
                sheet.Cells[1, 7].Value = "填充样式";
                //设置行高
                sheet.Row(1).Height = 19.5;
                //设置区域背景颜色（设置背景颜色之前一定要设置PatternType）
                sheet.Cells["A1:G1"].Style.Fill.PatternType = ExcelFillStyle.Solid;
                sheet.Cells["A1:G1"].Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.FromArgb(232, 232, 232));

                for (int i = 1; i <= 7; i++)
                {
                    //设置单元格区域的边框
                    sheet.Cells[1, i].Style.Border.BorderAround(OfficeOpenXml.Style.ExcelBorderStyle.Thin, System.Drawing.Color.Black);
                }
                //保存
                package.Save();
            }
        }

EPPlus读取excel内容

 /// <summary>
        /// 读取Excel表格内容
        /// </summary>
        public void ReadExcel()
        {
            //文件路径
            string path = "F:/text.xlsx";
            FileStream fs = new FileStream(path, FileMode.Open);
            using (ExcelPackage package = new ExcelPackage(fs))
            {
                ExcelWorksheet sheet = package.Workbook.Worksheets[1];
                int n = sheet.Dimension.End.Row;
                for (int i = 2; i <= n; i++)
                {
                    var test = sheet.GetValue(i, 1).ToString();
                }
            }
        }