Asp.net C# Stream to WorkBook

Hi,

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

Thanks
Stream.jpg
Jamil MuammarAsked:
Who is Participating?
 
Steven KribbeConnect With a Mentor Software EngineerCommented:
0
 
Steven KribbeConnect With a Mentor Software EngineerCommented:
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?
0
 
Jamil MuammarAuthor Commented:
it's C#

can you please supply example

Thanks
0
 
Jamil MuammarAuthor Commented:
can you please give an example how to use ChunkedMemoryStream by writing to Excel

Thanks
0
 
Jamil MuammarAuthor 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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.