没有合适的资源?快使用搜索试试~ 我知道了~
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);
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);
资源评论
qq_16490613
- 粉丝: 1
- 资源: 3
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功