Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

jdavidb (1361)

jdavidb
  (email not shown publicly)
http://voiceofjohn.blogspot.com/

J. David Blackstone has a Bachelor of Science in Computer Science and Engineering and nine years of experience at a wireless telecommunications company, where he learned Perl and never looked back. J. David has an advantage in that he works really hard, he has a passion for writing good software, and he knows many of the world's best Perl programmers.

Journal of jdavidb (1361)

Tuesday November 26, 2002
01:08 AM

A cry for help

[ #9149 ]

Okay, so I've shoved DBD::Excel and all its prerequisites onto an IIS system, and I can get all the modules to load, but when I try to connect to an Excel spreadsheet I get an error from OLE::Storage_Lite that just says "Error PPS:0" This is from somewhere inside the constructor; looks like one of those situations that the author thought could never happen.

Any ideas? Anyone have experience in this?

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • I can't remember exactly what it means, something like it failed to open the file, or failed to parse it as an OLE compound document. Try opening it first and passing in a FH (if that's possible).
    • Thank you, thank you! I'll try it immediately. (Wait, hmm, can I do that in DBI? Well, since I'm uploading my own copies of the modules, maybe I can kludge it...)

      Have slept on it and traced it down to an unpack statement that's deciding on a type of PPS (whatever a PPS is); the unpack yields a 5 on Linux and 0 on Win32. If this is the case, I wonder even if I hardwire it to 5 or something if the spreadsheet will parse correctly. Unpack is not portable?

      --
      J. David works really hard, has a passion for writing good software, and knows many of the world's best Perl programmers
    • Eek, I boiled down to a Spreadsheet::ParseExcel example and tried this; still didn't work. It comes down to some place where something tries to unpack the string "^E^A" as an unsigned char. I have a feeling that in Win32 it's trying to unpack "^E^A" or something. That said, I probably can't trust the entire module, because there's no telling how many non-portable unpack statements there might be.

      --
      J. David works really hard, has a passion for writing good software, and knows many of the world's best Perl programmers