使用C#使用Excel进行范围验证

using Excel = Microsoft.Office.Interop.Excel;

Excel.Application excel = new Excel.Application();
excel.Visible = true;

Excel.Workbook workbook = excel.Workbooks.Add(Type.Missing);
Excel.Worksheet worksheet = workbook.Sheets[1];

// 添加数据
worksheet.Cells[1, 1] = "A";
worksheet.Cells[1, 2] = "B";
worksheet.Cells[1, 3] = "C";

// 添加范围验证
Excel.Range range = worksheet.get_Range("A1", "C1");
Excel.Validation validation = range.Validation;

// 设置验证条件
validation.Add(Excel.XlDVType.xlValidateList, Excel.XlDVAlertStyle.xlValidAlertStop, Excel.XlFormatConditionOperator.xlBetween, "A,B,C", Type.Missing);

// 设置验证错误提示信息
validation.InputTitle = "输入错误";
validation.ErrorTitle = "错误";
validation.InputMessage = "请输入A、B或C";
validation.ErrorMessage = "输入错误，请输入A、B或C";

// 启用验证
validation.IgnoreBlank = true;
validation.InCellDropdown = true;

workbook.SaveAs("RangeValidation.xlsx");
workbook.Close();

// 退出Excel
excel.Quit();