The best approach to write more than 1 Lakh data into an Excel Sheet.

[Abdul L Koyappayil]

Hi All,

In one of my application I need to generate report in Excel file where data contains huge,more than one lakh. Currently I am querying this from database and looping through a cfoutput tag to write data into an excel sheet. But the problem with this method is Timeout issue or java heapsize is very less.

I think this is a drawback of coldfusion to write data in to Excel sheet. Right?? .  In this time we need to depend on Java to write huge data into Excel sheet.

Why we cant achieve this in ColdFusion , eventhough CF is built on Java platform.

Any one have any suggestions or any thoughts on this.Please share.

Your timely help is greatly appreciated.

Thanks in advance.

[BKBK]

That Coldfusion itself is a Java application has one advantage. You can transfer all the Java code you now use to Coldfusion, with few or no changes.

[Abdul L Koyappayil]

So You agree that this is not possible in Coldfusion (writing more than 1 Lakh data into an Excel Sheet) without java help. So I think no other way. Am i right??

[BKBK]

I was neither agreeing nor disagreeing. You asked for suggesions, and I gave you one. By the way, how much is 1 Lakh in bytes?

[Abdul L Koyappayil]

Yes BK .... I am not arguing here. Sorry if u felt so.....

I think 1 Lakh data may come around more than 5MB approximate.

I was trying to implement some re-usable function in coldfusion to write huge data into Excel Sheet.

So here let me ask u one thing , cant we do this in ColdFusion without any time out error or Java heap size issues??. If possible can you please guide me to create re-usable method in coldfusion , if not possible then also I would like to seek your help to write a method which uses some java code to write huge data into Excel sheet.

[BKBK]

I don't feel you are arguing. We are just discussing.

Could you show us the ColdFusion code you are using to write the Excel sheet? We will then share ideas on how to improve it, if that is possible.