Streaming a POI workbook to the servlet output stream.

Posted by The Machine on Stack Overflow See other posts from Stack Overflow or by The Machine
Published on 2010-04-20T08:49:02Z Indexed on 2010/04/20 8:53 UTC
Read the original article Hit count: 261

Filed under:

workbook

|

httpservletresponse

|

streaming

I build a very large POI workbook, on my web server. Holding the entire memory in workbook , will not scale for multiple concurrent requests. Is there a way i can progressively write the workbook to the servlet output stream. That should reduce the response time , as well as make the process memory efficient.

© Stack Overflow or respective owner

Related posts about workbook

vba access values from excel workbook from another excel workbook

as seen on Stack Overflow - Search for 'Stack Overflow'
Any ideas why this code will not work? Workbooks.Open Filename:="C:\a.xls" Workbooks("a.xls").Activate Worksheets("b").Select Dim OutputArray(10, 10) OutputArray(1, 1) = Workbooks("c.xls").Worksheets("worksheet_otherthan_default").Select.Range(A1).Value I'm trying to run a macro in one file (unnamed… >>> More
Updating target workbook - extracting data from source workbook

as seen on Stack Overflow - Search for 'Stack Overflow'
My question is as follows: I have given a workbook to multiple people. They have this workbook in a folder of their choice. The workbook name is the same for all people, but folder locations vary. Let's assume the common file name is MyData-1.xls. Now I have updated the workbook and want to give… >>> More
Copy first row in excel workbook to a new excel workbook

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I get the first row in an excel workbook & save it to a new excel workbook using .net c#? I dont know the amount of columns so need to get entire row. This what I have but the new workbook is blank (no row copied) Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(file); Excel._Worksheet… >>> More
Excel workbook event order and usage when closing Excel

as seen on Stack Overflow - Search for 'Stack Overflow'
Given the following workbook events: BeforeClose BeforeSave Please tell me: - The firing order in the case of multiple workbooks alreay opened (wb1, wb2 and wb3 are opened in this order) and the user closes Excel. You can assume all 3 needs saving. - What happen if user cancels one of the saving… >>> More
Problem with Refreshing entire excel workbook

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm trying to refresh a entire excel workbook using Application.CalculateFull function. However, I found that, the sheet does not get not updated ALL the time (sometimes it do). A random number of functions only get updated at sometimes. I'm using excel 2007, please tell me what's going on with… >>> More

Related posts about httpservletresponse

HttpServletResponse encoding problem @ WebSphere 6.1

as seen on Stack Overflow - Search for 'Stack Overflow'
My application is working fine with JBOSS 4.2.2 application server. However when I deploy same application at WebSphere 6.1. I get HttpServletResponse encoding problem. I am getting response on web browser as shown below:- ??][s?8?~N??0?uRY?d;?H?e??e??d6?%??A"yH????????M??x?? ??&A??h??ntCT??… >>> More
HttpServletResponse XML to Java

as seen on Stack Overflow - Search for 'Stack Overflow'
I am maintaining this servlet that has a HttpServletResponse response that replies back to the client an XML message. I want to take the XML message and convert it to JSON, then send the JSON back. I want to avoid writing my own JSON converter if possible. Does anyone have a good method of doing… >>> More
How to send HttpServletResponse in the PrintWriter having an HTML structure to a jsp

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to send a table in html code to a jsp using response.setContentType("text/html"); PrintWriter out = response.getWriter(); out.println("<html>")..... then using response.sendRedirect(jsp name) to send the table to the jsp; But this is never worked with me and I have a doubt… >>> More
Mockito: capturing HttpServletResponse#sendError()

as seen on Stack Overflow - Search for 'Stack Overflow'
Can I use Mockito to capture what was passed to the HttpServletResponse#sendError() method? I can't figure out how to do that. >>> More
How can I get the HTTP status code out of a ServletResponse in a ServletFilter?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to report on every HTTP status code returned from my webapp. However the status code does not appear to be accessible via the ServletResponse, or even if I cast it to a HttpServletResponse. Is there a way to get access to this value within a ServletFilter? >>> More