Asp.net C# Stream to WorkBook

Jamil Muammar
Jamil Muammar used Ask the Experts™
on
Hi,

 I'm writing to Excel large Data, but I'm getting the attached dump

Thanks
Stream.jpg
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Steven KribbeSoftware Engineer
Commented:
What is the size of the data you are trying to stream? If it is too big it does not fit in memory. In order to stream large files without using a lot of memory, you need to apply a chunking technique. Chopping up the data in small pieces for the client to consume. How exactly are you calling this code. VBA?

Author

Commented:
it's C#

can you please supply example

Thanks
Software Engineer
Commented:

Author

Commented:
can you please give an example how to use ChunkedMemoryStream by writing to Excel

Thanks

Author

Commented:
When I usee the XSSF in NPOI.DLL

In workbook.write, I got the dump

System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.


attached screenshot
Untitled.png

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial