更新时间:2023-02-16 16:08:28
using (ExcelPackage p = new ExcelPackage()) {
ExcelWorksheet ws = obj.CreateSheet(p, "sheetname", 1, true);
var unitmeasure = ws.DataValidations.AddListValidation("a1");
unitmeasure.Formula.Values.Add("Sq Ft");
unitmeasure.Formula.Values.Add("Meter");
}