Skip to main content
A
Abdul L Koyappayil
Inspiring
July 3, 2014
Question

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

  • July 3, 2014
  • 1 reply
  • 1405 views

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.

    This topic has been closed for replies.

    1 reply

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    July 3, 2014

    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.

    A
    Abdul L KoyappayilAuthor
    Inspiring
    July 4, 2014

    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
    Community Expert
    BKBKCommunity Expert
    Community Expert
    July 4, 2014

    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?

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices