Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

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

by Laurent_R (Vicar)
on Aug 09, 2013 at 21:12 UTC ( #1048850=note: print w/ replies, xml ) Need Help??


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
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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1048850]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (5)
As of 2014-08-23 08:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (172 votes), past polls