• Asp.net MVC 利用 Nopi 导出 Excel


    /// <summary>
    		/// 导出认账流水
    		/// </summary>
    		/// <returns></returns>
    		public ActionResult ExportAdmitBankTrans(BankTransQueryModel queryModel)
    		{
    			HSSFWorkbook workBook = new HSSFWorkbook();
    			ISheet sheet = workBook.CreateSheet("商务报表"); 
    			IRow row = sheet.CreateRow(0);
    
    			// 获取样式
    			Func<ICellStyle> getCellStyle = () =>
    			{
    				ICellStyle cellStyle = workBook.CreateCellStyle();
    				cellStyle.Alignment = HorizontalAlignment.Center;
    				return cellStyle;
    			};
    
    			ICellStyle headerStyle = getCellStyle();
    			IFont fontHeade = workBook.CreateFont();
    			fontHeade.FontHeightInPoints = 11;
    			fontHeade.FontName = "微软雅黑";
    			fontHeade.Boldweight = (short)FontBoldWeight.Bold;
    			headerStyle.SetFont(fontHeade);
    
    			Func<string, int, ICell> setCellStyle = (string cellText, int colindex) =>
    			{
    				ICell cell = row.CreateCell(colindex);
    				sheet.SetColumnWidth(colindex, 9000);
    				cell.SetCellValue(cellText);
    				cell.CellStyle = headerStyle;
    				return cell;
    			};
    			setCellStyle("供应商名称", 0);
    			setCellStyle("采购编号", 1);
    			setCellStyle("实际到账", 2);
    			setCellStyle("到账日期", 3);
    			int rowStart = 1;
    
    			var list = BankTransBll.Instance.GetAllBankTransRealList(queryModel);
    			if (list != null)
    			{
    				foreach (var item in list)
    				{
    					IRow myrow = sheet.CreateRow(rowStart);
    					myrow.CreateCell(0).SetCellValue(item.CompanyName);
    					myrow.CreateCell(1).SetCellValue(item.ContractNo);
    					myrow.CreateCell(2).SetCellValue(item.Amount.ToString("f2"));
    					myrow.CreateCell(3).SetCellValue(item.REC_CREATETIME.ToShortDateString());
    
    					rowStart++;
    				}
    			}
    
    			using (MemoryStream ms = new MemoryStream())
    			{
    				workBook.Write(ms);
    				byte[] buffers = ms.ToArray();
    
    				return File(buffers, "application/vnd.ms-excel", string.Format("{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss")));
    
    			}
    		}
    

      

  • 相关阅读:
    xp安装IIS admexs.dll问题
    MySql 牛哥推荐有空看看
    PHP常用类型判断函数
    GET和POST的真正区别
    许多真理
    PHP file_put_contents() 函数
    Intellijidea建javaWeb以及Servlet简单实现
    新手上路,配置阿里云CentOS服务器LAMP
    php的socket通信
    PHP常用的一些数组操作总结
  • 原文地址:https://www.cnblogs.com/AskySun/p/5067509.html
Copyright © 2020-2023  润新知