如何在使用NPOI创建的Excel中设置单元格的验证 [英] How to set Validation for a cell in Excel created using NPOI

问题描述

我已使用NPOI使用以下代码创建了一个excell文件

I have created an excell file using NPOI using following code

            var workbook = new HSSFWorkbook();
            var sheet = workbook.CreateSheet("Candidate");

            // Add header labels
            var rowIndex = 0;
            var row = sheet.CreateRow(rowIndex);
            row.CreateCell(0).SetCellValue("Name");
            row.CreateCell(1).SetCellValue("1,2,3");
            row.CreateCell(2).SetCellValue("4,5,6");
            row.CreateCell(3).SetCellValue("7,8,9");
            rowIndex++;


            // Add data rows
            for (int i = 1; i <= 5; i++)
            {
                row = sheet.CreateRow(rowIndex);
                row.CreateCell(0).SetCellValue("Candidate" + i.ToString());
                row.CreateCell(1).SetCellValue("");
                row.CreateCell(2).SetCellValue("");
                row.CreateCell(3).SetCellValue("");
                rowIndex++;
            }

我只想在每个单元格中添加一些验证. 例如:restrict cell 2 with inputs only 1,2,3

I just wanted to add some validation in each cell. For eg: restrict cell 2 with inputs only 1,2,3

在Excel we can Set Data Validation至whole number中并且可以specify Min and Max Value.

任何实现此目标的想法都会有很大帮助.

Any idea for achieving this will be a great help.

推荐答案

我发现了这一点，并在以下代码中发挥了很大的作用.

I find out this and working greatly with following code.

    var markConstraint = DVConstraint.CreateExplicitListConstraint(new string[]{"1","2","3"});
    var markColumn = new CellRangeAddressList(1, 5, 1, 1);
    var markdv = new HSSFDataValidation(markColumn, markConstraint);
    markdv.EmptyCellAllowed = true;
    markdv.CreateErrorBox("Wrong Value", "Please Enter a correct value");
    sheet.AddValidationData(markdv);

这篇关于如何在使用NPOI创建的Excel中设置单元格的验证的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！