EPPlus C# Tutorial: Excel File Handling

The following are some methods for using EPPlus, an open-source library for handling Excel files in C#.

1. Create a new Excel file.

using OfficeOpenXml;

// 创建一个新的Excel文件
using (ExcelPackage package = new ExcelPackage())
{
    ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Sheet1");
    worksheet.Cells["A1"].Value = "Hello, World!";
    package.SaveAs(new FileInfo("sample.xlsx"));
}

1. Read an existing Excel file:

using OfficeOpenXml;

// 读取一个已存在的Excel文件
using (ExcelPackage package = new ExcelPackage(new FileInfo("sample.xlsx")))
{
    ExcelWorksheet worksheet = package.Workbook.Worksheets[0];
    var cellValue = worksheet.Cells["A1"].Value;
    Console.WriteLine(cellValue);
}

1. Manipulating data in Excel.

using OfficeOpenXml;

// 操作Excel中的数据
using (ExcelPackage package = new ExcelPackage(new FileInfo("sample.xlsx")))
{
    ExcelWorksheet worksheet = package.Workbook.Worksheets[0];
    
    // 设置单元格的值
    worksheet.Cells["A2"].Value = 42;
    
    // 修改单元格的样式
    worksheet.Cells["A2"].Style.Font.Bold = true;
    
    package.Save();
}

These are some basic uses of EPPlus that can be further expanded and applied according to specific needs. EPPlus also offers a range of features and APIs to handle more complex Excel operations.