Skip to main content
P
Pavelbr
New Participant
June 9, 2011
Question

cfspreadsheet and reading the xlsx files issue

  • June 9, 2011
  • 1 reply
  • 6208 views

I am trying to process large excel files (65,000 rows) into the DB.  So I try to use the new cfspreadsheet tag to read in the files by 5000 rows at a time and then process the query into the tables.  The process is working fine when reading the (pre 2003 format "xls" files) but not when reading the new "xlsx" type of files.  The server is running out of memory trying to read those files for some reason.  Is this a known bug in ColdFusion 9.0??  Has anyone experiansed similar issues?

Thanks

    This topic has been closed for replies.

    1 reply

    A
    Adam Cameron.
    Inspiring
    June 10, 2011

    The docs claim all versions of Excel from 1997-2007 are supported.

    Are you getting this with •any• .xlsx file, or just large ones?

    Do you need CF sitting in the middle of this process? Can you not get the DB to import the Excel file directly?

    --

    Adam

    P
    PavelbrAuthor
    New Participant
    June 10, 2011

    I need to do some processing on the data first that comes from the spreadsheet.  This seems to be the problem with the very large xlsx type spreadsheets.  The older format xls (up to 2003) is working great even with 65,000 rows of data.  So I think this is something to do with xlsx and very large spreadsheets.

    - Pavel

    A
    Adam Cameron.
    Inspiring
    June 10, 2011

    That it runs OK with a large .xls & have problems with large .xlsx files does not demonstrate it's specifically a problem with the size of the .xlsx, rather that being a problem with .xlsx files in general. And whether it's one way or the other dictates what the solution might be.

    Test (and compare performance) on a smaller file.

    --

    Adam

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