Wednesday, September 6, 2017

How to export with Aspose Cell C# Excel, Pdf, xlsx, ...

 public ActionResult Export()  
     {  
       try  
       {  
         WorkbookDesigner designer = new WorkbookDesigner();  
         var path = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/Download/"), "SimTemplate.xls");  
         designer.Workbook = new Workbook(path);  
         var worksheet = designer.Workbook.Worksheets[0];  
         var data = _systemService.GetSims();  
         designer.SetDataSource("Export", data);  
         //Process the markers  
         designer.Process(false);  
         //Save the Excel file.  
         System.IO.Stream stream = Response.OutputStream;  
         worksheet.Name = "DanhSachSim_" + DateTime.Now.ToString("yyyyMMddHHmmssfff");  
         Response.ContentType = "application/vnd.ms-excel";  
         Response.AddHeader("Content-disposition",  
           "attachment; filename=" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xls");  
         Response.Clear();  
         Response.BufferOutput = true;  
         designer.Workbook.Save(stream, SaveFormat.Excel97To2003);  
         Response.Flush();  
         return new EmptyResult();  
       }  
       catch (Exception)  
       {  
         return new EmptyResult();  
       }  
     }  
Data Source: &=Export.Name .....

No comments:
Write comments