用到的组件是:NPOI
1.main中的方法
string filePathAndName = "D:\\" + Guid.NewGuid().ToString() + ".xls"; using (FileStream fs = new FileStream(filePathAndName, FileMode.Create, FileAccess.Write)) { HSSFWorkbook workbook = new HSSFWorkbook(); ISheet sheet = workbook.CreateSheet("sheet1"); SetCityCellDropdownList(workbook, sheet, "CityDictionary", 1, 2, 1); workbook.Write(fs); fs.Flush(true); }
2.主要实现代码
1 private static void SetCellDropdownList(ISheet sheet, int firstRow, int lastRow, int firstCol, int lastCol, string name) 2 { 3 CellRangeAddressList regions = new CellRangeAddressList(firstRow, lastRow, firstCol, lastCol); 4 DVConstraint constraint = DVConstraint.CreateFormulaListConstraint(name); 5 HSSFDataValidation dataValidate = new HSSFDataValidation(regions, constraint); 6 dataValidate.CreateErrorBox("输入不合法", "请输入或选择下拉列表中的值。"); 7 sheet.AddValidationData(dataValidate); 8 }