I am using POI to create an Excel file using the data from SQL statement. First error scneario: I have roughly 40 columns and if I tried to run report of 900 rows, the web browser flashed by and displayed a blank page. No error message in server log, just showing getting a connection and hang in there... Largest value inserted into cells is like 200 byttes... Second error scenrio: A new requirement asks for 67 columns. Now even with just one row, the web browser flashed by and displayed a blank page. No error message in server log, just showing getting a connection and hang in there...
You should first try fetching your file with something like wget, and trying to open the saved file. That'll tell you if it's a problem with your excel generation, or with how you're passing it to the browser. If wget works, then you'll need to check the list archives. There's lots on there on the best way to tell browsers (especially IE) that it's an excel file. If it doesn't work via wget, then you need to fix your generation logic.