使用Aspose.Cell动态创建Excel下拉列表

    CellArea area;
                System.Data.DataTable dt = enBll.GetListByPage("", "enterprise_id,risk_state, id desc").Tables[0];
                Aspose.Cells.Workbook workbook = new AsposeExcel().Export(dt);
                Aspose.Cells.Worksheet worksheet = workbook.Worksheets[0];
                //1-4行两列的下拉列表 zys
                ValidationCollection validations = worksheet.Validations;
                Aspose.Cells.Validation validation = validations[validations.Add()];
                validation.Type = Aspose.Cells.ValidationType.List;
                validation.Formula1 = "1,2,3,4";//数据以逗号分隔
                area.StartRow = 0;
                area.EndRow = 4;
                area.StartColumn = 0;
                area.EndColumn = 2;
                validation.AreaList.Add(area);


                //5-10行两列的下拉列表
                ValidationCollection validations1 = worksheet.Validations;
                Aspose.Cells.Validation validation1 = validations1[validations1.Add()];
                validation1.Type = Aspose.Cells.ValidationType.List;
                validation1.Formula1 = "a,b,c,d";//数据以逗号分隔
                area.StartRow = 5;
                area.EndRow = 10;
                area.StartColumn = 0;
                area.EndColumn = 2;
                validation1.AreaList.Add(area);