Excel Report returning 40,000 rows

Hi,

I am generating excel reports in coldfusion using CFContent tag, which works fine if get around 5000 rows. In one of my report I am getting about 40,000 rows from oracle database,
so the page is not processing and it freezes the computer if I run the code.

Is there any way to generate excel report with 40,000 rows?
I even tried splitting the datas into 20,000 rows per file and created two file but it still does the same to even process 20,000 rows.

I would really appreciate any help reg this.

Thanks,
Arun

I've used cfcontent to generate excel files with more than 40,000 rows. Is the CF server crashing, or is the computer that you are trying to open the Excel file with crashing? Remember that if you are generating HTML tables and pushing that to the browser with cfcontent to force Excel to render it, it can take several minutes for Excel to process all the table tags and show the data within Excel.

No, even I tried in other computer it is the same... is there any way for me to generate a file and upload it in the webserver....

I would really appreciate any help reg this..

Thanks,
Arun

I don't know what you mean. Clearly, you can pre-generate an Excel file and upload it to the web server. You can also look into using something like Apache POI to generate a true binary Excel file.