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.
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??
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?
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.
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.