net core--Excel 三个列级联下拉查询（国家，省，市）

用到的组件是：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);
            }

View Code

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         }

SetCellDropdownList