Excel 和 EPPlus .NET 库：高级下拉列表验证

csharp
using OfficeOpenXML;
using System;
class Program
{
    static void MAIn(string[] args)
    {
        // 创建excel文件
        using (var package = new excelPackage())
        {
            var workbook = package.Workbook;
            var worksheet = workbook.Worksheets.Add("Sheet1");
            // 设置下拉列表的选项
            var options = new[] { "选项1", "选项2", "选项3" };
            // 创建命名的区域
            var namedRange = worksheet.Names.Add("下拉列表");
            namedRange.Value = string.Join(",", options);
            // 创建数据验证规则
            var validation = worksheet.DataValidations.AddListValidation("A1");
            validation.Formula.excelFormula = $"下拉列表";
            // 保存excel文件
            package.SaveAs(new System.IO.FileInfo("Sample.xlsx"));
        }
    }
}

csharp
var validation = worksheet.DataValidations["A1"];
validation.Formula.excelFormula = $"新的下拉列表";

csharp
worksheet.DataValidations.Remove("A1");