How to create Excel file using OpenXML without creating a local file?

by

You could use the overload of SpreadsheetDocument.Create that takes a Stream and pass it a MemoryStream:

MemoryStream memoryStream = new MemoryStream();
SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create(memoryStream, SpreadsheetDocumentType.Workbook);

//add the excel contents...

//reset the position to the start of the stream
memoryStream.Seek(0, SeekOrigin.Begin);

return new FileStreamResult(memoryStream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");

Note that as per this StackOverflow question you don’t need to dispose the Stream as it will be done for you by the FileStreamResult class.

More Related Contents:

  1. Export DataTable to Excel with Open Xml SDK in c#
  2. Why appending AutoFilter corrupts my excel file in this example?
  3. How to export a JQgrid data to Excel using c#?
  4. How to access OpenXML content by page number?
  5. OpenXML SDK returning a number for CellValue instead of cells text
  6. Save modified WordprocessingDocument to new file
  7. Replace bookmark text in Word file using Open XML SDK
  8. How can I embed any file type into Microsoft Word using OpenXml 2.0
  9. Using OpenXmlReader
  10. open xml reading from excel file
  11. Optimal way to Read an Excel file (.xls/.xlsx)
  12. Applying % number format to a cell value using OpenXML
  13. Merge multiple word documents into one Open Xml
  14. From Excel to DataTable in C# with Open XML
  15. Cell styles in OpenXML spreadsheet (SpreadsheetML)
  16. Add HTML String to OpenXML (*.docx) Document
  17. Get the Column Index of a Cell in Excel using OpenXML C#
  18. openxml spreadsheat save-as
  19. How to convert a column number (e.g. 127) into an Excel column (e.g. AA)
  20. How to read an excel file in C# without using Microsoft.Office.Interop.Excel libraries
  21. What is the algorithm to convert an Excel Column Letter into its Number?
  22. How to use use late binding to get excel instance?
  23. Cell color changing in Excel using C#
  24. Why does Microsoft.Office.Interop.Excel.Application.Quit() leave the background process running?
  25. How do I import from Excel to a DataSet using Microsoft.Office.Interop.Excel?
  26. C# – How to copy a single Excel worksheet from one workbook to another?
  27. Query excel sheet in c#
  28. Scientific notation when importing from Excel in .Net
  29. Accessing an open Excel Workbook in C#
  30. Import Excel to Datagridview

Leave a Comment