Skip to main content
P
plarts
Inspiring
May 25, 2014
Question

cfspreadsheet 400000 lines

  • May 25, 2014
  • 1 reply
  • 1759 views

How to read an Excel file ".xlsx" of 420 000 lines ?

I used cfspreadsheet but,

over 4000 lines  it fails, saying nothing.

I tried the CFC (custom tag) : POIutility.cfc from Ben Nadel.

but it seems it does not work with xlsx,

does work fine with ".xls" , I can read 65 000 lines

because ".xls" it limited to 65 000 lines.

so I have no solution to read 400 000 :lines.

Thanks for help. ideas ?

Pierre.

    This topic has been closed for replies.

    1 reply

    K
    Kaif_Akbar
    Inspiring
    May 27, 2014

    Hi Plarts,

    In such kind of scenario, you can try to populate the large data by using array of cfspreadsheet so that it can work for your requirement.

    But as populating/processing excel sheet for such kind of scenario may also need more memory so you may increase max heap allocation to CF server if required.

    ~

    Kaif Akbar

    P
    plartsAuthor
    Inspiring
    May 28, 2014

    Thanks,

    what do you call : using array of cfspreadsheet


    Also POIutility.cfc  does work fine with current CF, but only with xls not with xlsx

    Pierre.

    P
    plartsAuthor
    Inspiring
    June 17, 2014

    Waiting for a soltution to get an automated process,

    I did this manually, converting from Excel to Access,

    then accessing Access DB.

    But I will need soon a way to automate this, means to be able to read

    the 400 000 lines of Excel sheet.

    Any advise, what tool to try ? (CF tags or custom tags , or any thing else in CF)

    Thnaks, Pierre.

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