首先在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();
}
}
}