首页 / ASP / aspose.cells导出Demo
aspose.cells导出Demo
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了aspose.cells导出Demo,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含4123字,纯文字阅读大概需要6分钟。
内容图文
![aspose.cells导出Demo](/upload/InfoBanner/zyjiaocheng/1208/6dcf626d7f7e45f28a3d6f80bab8a5f1.jpg)
/// <summary> /// 导出excel /// </summary> /// <param name="list"></param> private void ExportExcel(IList<CV_SaaS_POM_ProductionOrder> list) { try { SaveFileDialog Dialog = new SaveFileDialog(); Dialog.Filter = "Excel文件(*.xlsx)|*.xlsx|Excel文件(*.xls)|*.xls"; Dialog.FileName = "SAP生产工单_" + DateTime.Now.ToString("MMdd") + ".xlsx"; if (Dialog.ShowDialog() == DialogResult.OK) { Workbook workbook = new Workbook(); //工作簿 Worksheet sheet = workbook.Worksheets[0]; //工作表 Cells cells = sheet.Cells;//单元格 #region 文字样式 Style style = new Style(); style.HorizontalAlignment = TextAlignmentType.Center;//文字居中 style.VerticalAlignment = TextAlignmentType.Center; style.Font.Name = "宋体";//文字字体 style.Font.Size = 13; // Style style1 = new Style(); style1.HorizontalAlignment = TextAlignmentType.Center;//文字居中 style1.VerticalAlignment = TextAlignmentType.Center; style1.Font.Name = "宋体";//文字字体 style1.Font.Size = 13; style1.Custom = "MM/dd"; // Style style2 = new Style(); style2.HorizontalAlignment = TextAlignmentType.Center;//文字居中 style2.VerticalAlignment = TextAlignmentType.Center; style2.Font.Name = "宋体";//文字字体 style2.Font.Size = 13; style2.Custom = "yyyy/mm/dd"; #endregion//生成行2 列名行 cells[0, 0].PutValue("SAP工单号"); cells[0, 0].SetStyle(style); cells[0, 1].PutValue("物料编码"); cells[0, 1].SetStyle(style); cells[0, 2].PutValue("物料描述"); cells[0, 2].SetStyle(style); cells[0, 3].PutValue("BOM版本"); cells[0, 3].SetStyle(style); cells[0, 4].PutValue("工单组件"); cells[0, 4].SetStyle(style); cells[0, 5].PutValue("工单类型"); cells[0, 5].SetStyle(style); cells[0, 6].PutValue("工艺路径"); cells[0, 6].SetStyle(style); cells[0, 7].PutValue("工单数量"); cells[0, 7].SetStyle(style); cells[0, 8].PutValue("计划开始时间"); cells[0, 8].SetStyle(style); cells[0, 9].PutValue("计划完成时间(交期)"); cells[0, 9].SetStyle(style); //根据当前日期生成一年的日期列int cellIndex = 9; DateTime today = Convert.ToDateTime(DateTime.Now.ToString(@"yyyy-MM-dd")); DateTime endday = today.AddMonths(2); for (; today < endday; today = today.AddDays(1)) { cellIndex++; cells[0, cellIndex].PutValue(today); cells[0, cellIndex].SetStyle(style1);//定义后续两个月日期的格式 } //设置下拉列表框格式 ValidationCollection validations = sheet.Validations; Validation validation = validations[validations.Add()]; validation.Type = Aspose.Cells.ValidationType.List; validation.Operator = OperatorType.None; validation.InCellDropDown = true; validation.Formula1 = GetOrderFamilyName();//逗号分隔字符串 validation.ShowError = true; validation.AlertStyle = ValidationAlertType.Stop; validation.ErrorTitle = "Error"; validation.ErrorMessage = "请选择工单组件"; CellArea area; area.StartRow = 1; area.EndRow = 9999; area.StartColumn = 4; area.EndColumn = 4; validation.AreaList.Add(area); //写入工单数据 CV_SaaS_POM_ProductionOrder order = null; for (int i = 0; i < list.Count; i++) { order = list[i]; cells[i + 1, 0].PutValue(order.ProductionOrderNO); cells[i + 1, 0].SetStyle(style); cells[i + 1, 1].PutValue(order.DefID); cells[i + 1, 1].SetStyle(style); cells[i + 1, 2].PutValue(order.DefName); cells[i + 1, 2].SetStyle(style); cells[i + 1, 3].PutValue(""); cells[i + 1, 3].SetStyle(style); cells[i + 1, 4].PutValue(order.OrderGroup); cells[i + 1, 4].SetStyle(style); cells[i + 1, 5].PutValue(order.OderType); cells[i + 1, 5].SetStyle(style); cells[i + 1, 6].PutValue(order.PPRCode); cells[i + 1, 6].SetStyle(style); cells[i + 1, 7].PutValue(order.Quantity - order.AssignedQuantity); cells[i + 1, 7].SetStyle(style); cells[i + 1, 8].PutValue(order.StartTime); cells[i + 1, 8].SetStyle(style2); cells[i + 1, 9].PutValue(order.EndTime); cells[i + 1, 9].SetStyle(style2); } int columnCount = cells.MaxColumn; //获取表页的最大列数int rowCount = cells.MaxRow; //获取表页的最大行数for (int col = 0; col < columnCount; col++) { sheet.AutoFitColumn(col, 0, rowCount); } for (int col = 0; col < columnCount; col++) { cells.SetColumnWidthPixel(col, cells.GetColumnWidthPixel(col) + 30); } workbook.Save(Dialog.FileName); MessageBox.Show("导出成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception exception) { SaMessageBox.ShowError(exception); } }
原文:https://www.cnblogs.com/yueyan/p/11888760.html
内容总结
以上是互联网集市为您收集整理的aspose.cells导出Demo全部内容,希望文章能够帮你解决aspose.cells导出Demo所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。