//sheet中添加数据验证
ValidationCollection validations = sheet.Validations;
//进行添加
Validation validation = validations[validations.Add()];
//设置数据验证为List
validation.Type = Aspose.Cells.ValidationType.List;
validation.Operator = OperatorType.None;
validation.InCellDropDown = true;
//设置验证的集合(用逗号隔开)
validation.Formula1 = UserName;
//开启错误提示
validation.ShowError = true;
//提示类型
validation.AlertStyle = ValidationAlertType.Stop;
//提示标题
validation.ErrorTitle = "Error";
//提示内容
validation.ErrorMessage = "Please select a correct tax rate from the list";
//声明区域
CellArea area;
//开始行
area.StartRow = 1;
//结束行
area.EndRow = 1000;
//开始列
area.StartColumn = i;
//结束列
area.EndColumn = i;
validation.AreaList.Add(area);
Aspose.Cells解决导入时数据验证问题(版本5.3.1.0)
于 2022-08-08 16:47:36 首次发布