How to write an Excel workbook to a MemoryStream in .NET?

by

I have done extensive work with the PIA and with storing Excel files in a document repository and streaming it out to the browser, and I have not been able to find a solution to using the PIA without first writing the contents to the file system first.

I think that you are going to have to swallow the bullet and deal with the file system as an intermediary. The good news is that you can just give the file a unique name like a guid or use some other tempfilename method (not sure if one exists in .net) and just delete the contents when you are done.

More Related Contents:

  1. Clean up Excel Interop Objects with IDisposable
  2. ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
  3. The proper way to dispose Excel com object using VB.NET?
  4. How to count the number of rows in excel with data?
  5. How do I convert an Excel serial date number to a .NET DateTime?
  6. VB.Net – Excel COM Object not getting released [duplicate]
  7. How to get COM Server for Excel written in VB.NET installed and registered in Automation Servers list?
  8. OpenXML SDK: Make Excel recalculate formula
  9. Windows 7 .net Excel .SaveAs() Error Exception from HRESULT: 0x800A03EC
  10. Translate a column index into an Excel Column Name
  11. VB.NET Excel Program Leaves EXCEL.EXE floating after completion
  12. Html.Partial vs Html.RenderPartial & Html.Action vs Html.RenderAction
  13. Where Is Machine.Config?
  14. Should we switch to use async I/O by default?
  15. How to connect to Oracle 11 database from . net
  16. How can I get my webapp’s base URL in ASP.NET MVC?
  17. Any decent text diff/merge engine for .NET? [closed]
  18. Get Database Table Name from Entity Framework MetaData
  19. Can I set Option Explicit and Option Strict on a Project/Solution level?
  20. How to repair COMException error 80040154?
  21. How do I set a number of retry attempts in RabbitMQ?
  22. JavaScriptSerializer UTC DateTime issues
  23. How to troubleshoot and debug Visual Studio design mode errors?
  24. How should I cast in VB.NET?
  25. Use Visual Studio Setup Project to automatically register and GAC a COM Interop DLL
  26. Use a StyleSelector for a button
  27. .NET core 3.0 and MS Office Interop
  28. .NET — Textbox control – wait till user is done typing
  29. How to serialize a large graph of .NET objects into a SQL Server BLOB without creating a large buffer?
  30. Best way to detect a release build from a debug build? .net

Leave a Comment