go ahead... be a heretic | |
PerlMonks |
Spreadsheet::Read Open File from the cloudby vitoco (Hermit) |
on Sep 30, 2019 at 19:32 UTC ( [id://11106889]=perlquestion: print w/replies, xml ) | Need Help?? |
vitoco has asked for the wisdom of the Perl Monks concerning the following question: Hi! AFAIK, ReadData or new methods of Spreadsheet::Read module reads a the whole data into memory by parsing the source file with the proper filter. Then, you can access sheets, rows, columns, ... I wrote a script to extract some info from many sheets from an ODS file. This file has to be downloaded from the net, but I want to skip this manually done step and to include that step into my script. Then, I have two choices:
As I'd like to try a direct access from this module to the service, and I gave a try using the HTTPS URL instead of a local file name, but it just gave me an empty object ready to receive sheets from other files, and no error. The manual says it can open a file stream, but I cannot figure out how to set up that stream. Also, the used module Spreadsheet::ReadSXC does not mention streams in its doc, so I'm not sure that this will work. Any idea, experience, permalink, hint, etc? Thanks a lot!
Back to
Seekers of Perl Wisdom
|
|