Skip to main content
Inspiring
October 15, 2013
Question

Read large Excel file with huge data

  • October 15, 2013
  • 2 replies
  • 2380 views

Please suggest if any one have any suggestion to read MS Excel file with huge data. Do I need to go with cfspreadsheet or Java code.

    This topic has been closed for replies.

    2 replies

    Known Participant
    October 18, 2013

    Do google searches for APACHE POI and for POIUTILITY.CFC, but I do not know if that is a better solution for what you are trying to do.

    Participating Frequently
    October 15, 2013

    Define 'huge'.  What have you tried so far?  Are you experiencing errors due to the size of the dataset, or just haven't done anything yet and want to know what's the best option?

    Inspiring
    October 16, 2013

    With 'huge' what I meant to say here is the excel file which I wanna read contains more than 1000 rows.I didnt try with any thing , but as far as I know using CFSPREADSHEET will take long time. SO I am looking for a better option to achieve this.

    Thanks

    Inspiring
    October 18, 2013

    If you're only talking about a couple of thousand rows, then CFSPREADSHEET should be fine.  I read that size spreadsheets all the time, with no problems. If you're talking about tens or hundreds of thousands of rows, then it will get slower, but should still be ok.  The POI cfc works well, but in the end that data needs to be put into a query object no matter which path you take, so be sure that memory is not a factor for the size of data you are reading.  If you start writing large spreadsheets, you will find that CFSPREADSHEET has problems with performance.  In those cases I ended up creating CSV files that people would open in Excel.

    hth,

    Reed