5 Replies Latest reply: Jul 8, 2014 12:07 AM by BKBK RSS

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

    Abdul L Koyappayil Community Member

      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.