in reply to OpenOffice::OODoc. Slow access to a cell content with getCellValue

Yes, the bug is "I'm playing with the module OpenOffice and trying to extract some info from a spreadsheet to a text file". The correction is s/module//; and the bug is gone ;) Seriously though, Excel and Open office provide text format input and output precisely so that people do not have to do this! A better idea is to consider the text file you can obtain easily enough without programming in itself a temporary inconvenience for which support will be irrelevant later down the path to developing a proper system that does what your business actually needs.

One world, one people

  • Comment on Re: OpenOffice::OODoc. Slow access to a cell content with getCellValue

Replies are listed 'Best First'.
Re^2: OpenOffice::OODoc. Slow access to a cell content with getCellValue
by pvaldes (Chaplain) on Jun 01, 2016 at 22:26 UTC

    Thanks for the opinion, but sometimes you simply need a more sophisticated approach. This is only a first part of a much more complex, non standard, cell selection problem.

    My past experience with openoffice macros ended in a blast of fire and an orgy of mutilated xmls beyond repair, therefore, this time I want Perl to save the day.

[reply]
      There is likely another way to achieve the overall goal is what I am saying.

      One world, one people

[reply]

In Section Seekers of Perl Wisdom