.NET component
Read / Write / Generate Excel XLSX XLS files

Excel Jetcell .NET

• File formats: Excel Spreadsheet XLSX, XLS, CSV.
• 100% managed .NET component.
• Doesn't require Microsoft Excel.
• High performance (~50000 records per second).
• Plain & Fair licensing.
• Royalty-Free. No extra cost for Server license.
• 6 Months: Free Support + Free Updates.
Evaluation Version
Download  |   Online Demo
Developer License - $175
Buy now  |   Price List

Skip Navigation LinksUser Experience > Show Excel Without Saving

Excel Jetcell .NET component



Learning Resources




FREE version

News & Releases

May 20, 2016
Version 3.1 Update
Excel Jetcell .NET component
March 24, 2016
Version 3.1 Update
Excel Jetcell .NET component
January 29, 2016
Version 3.1 Update
Excel Jetcell .NET component
October 14, 2015
Version 3.1 Update
Excel Jetcell .NET component
March 03, 2015
Version 3.1 Update
Excel Jetcell .NET component
May 15, 2013
Version 3.1 Update
Excel Jetcell .NET component
November 15, 2012
Version 3.1 Update
Excel Jetcell .NET component

Export to Excel without saving on server

"Hi, my ASP.NET application generates the report. I want to export data to excel file via Excel Jetcell .NET. The form has button for excel export. Can you stream to client without saving any data on server?"
William Goldsberry

Excel Jetcell .NET can save the Excel data to Excel files XLS, XSLX with help of function:
WriteXLS(string Excel_File)
WriteXSLX(string Excel_File)

Also you can save Excel data to MemoryStream using same functions without parameters:
MemoryStream WriteXSL()
MemoryStream WriteXSLX()

Use Response object to stream data to browser window. Note, there are different content types (mime) for XLS and XLSX formats.

  1. //Create a new Excel file
  2. ExcelWorkbook wbook = new ExcelWorkbook();
  3. ExcelCellCollection Cells = wbook.Worksheets.Add("sheet1").Cells;
  4.  
  5. // Add text to cell B2
  6. Cells["B2"].Value = "ASP.NET Test";
  7. Cells["B2"].Style.Font.Color = ColorPalette.Green;
  8.  
  9. // XLS
  10. // Save Excel Workbook (XLS) to MemoryStream
  11. byte[] bytes = wbook.WriteXLS().ToArray();
  12.  
  13. // Show Excel (XLS) in Browser window without saving on disk
  14. Response.ContentType = "application/vnd.ms-excel";
  15. Response.BinaryWrite(bytes);
  16. Response.Flush(); Response.End();
  17.  
  18. // XLSX
  19. // Save Excel Workbook (XLSX) to MemoryStream
  20. byte[] bytes = wbook.WriteXLSX().ToArray();
  21.  
  22. // Show Excel (XLSX) in Browser window without saving on disk
  23. Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
  24. Response.BinaryWrite(bytes);
  25. Response.Flush(); Response.End();