http://www.perlmonks.org?node_id=1048850


in reply to Re^3: Ignore newlines within quotes while reading a line in a text file
in thread Ignore newlines within quotes while reading a line in a text file

An alternative might be to try to use the code of one of the Excel modules and to read directly from the spreadsheet. Some of them at least seem to be pure Perl, so that incorporating their code into your program or installing manually the *.pm into your default directory might be easier. I did it once about 3 years ago in an environment where I could not install the module with the standard procedures, it took me a couple of hours to resolve the various dependencies, but it worked. BTW, it was in a AIX environment, so not the easiest to use Excel file (OLE not available, etc.).

But is also depends on which version of Excel we are talking about.

  • Comment on Re^4: Ignore newlines within quotes while reading a line in a text file

Replies are listed 'Best First'.
Re^5: Ignore newlines within quotes while reading a line in a text file
by Anonymous Monk on Aug 10, 2013 at 09:39 UTC

    An alternative might be ....

    To buy a new computer and use that instead

    or go swimming in a soda fountain

    :P