doubledecker has asked for the wisdom of the Perl Monks concerning the following question:

Hi Monks

I have an excel sheet with more than 1000 columns and trying to read data out of it. But, Spreadsheet::XLSX is not letting to read more than 700 columns. I have tried using other modules but the result is same. May I know what is the exact reason behind this?

Thanks

  • Comment on Unable to read excel columns more than 700

Replies are listed 'Best First'.
Re: Unable to read Excel columns more than 700
by Athanasius (Archbishop) on Sep 22, 2014 at 07:58 UTC

    Hello doubledecker,

    Just for the record: Spreadsheet::XLSX uses Spreadsheet::XLSX::Fmt2007, which in turn uses Spreadsheet::XLSX::Utility2007. The latter’s source code (lines 854–7, version 0.13) contains this comment:

    ### int2col
# convert a column number into column letters
# @note this is quite a brute force coarse method
#   does not manage values over 701 (ZZ)

    [download]

    Hope that helps,

    Athanasius <°(((>< contra mundum Iustus alius egestas vitae, eros Piratica,

[reply]
[d/l]
[select]
Re: Unable to read excel columns more than 700
by Tux (Canon) on Sep 22, 2014 at 07:48 UTC
[reply]
Re: Unable to read excel columns more than 700
by Anonymous Monk on Sep 22, 2014 at 07:19 UTC

    May I know what is the exact reason behind this?

    Could be anything (out of memory, bugs/oversight...

[reply]
      After all, no one will ever need more that 640K....

      ----
      I Go Back to Sleep, Now.

      OGB

[reply]

Back to Seekers of Perl Wisdom