Excel 下拉框设置:
数据->有效性->序列
C# 代码操作:
单元格已经设置成下拉选项:
worksheet.get_Range(worksheet.Cells[1, 1], worksheet.Cells[1, 1]).Validation.Modify(Excel.XlDVType.xlValidateList,
Excel.XlDVAlertStyle.xlValidAlertStop, Type.Missing, "1,2,3", Type.Missing);
单元格未设置成下拉框:
worksheet.get_Range(worksheet.Cells[1, 1], worksheet.Cells[1, 1]).Validation.Add(Excel.XlDVType.xlValidateList,
Excel.XlDVAlertStyle.xlValidAlertStop, Type.Missing, "1,2,3", Type.Missing).