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

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.
  • In the CPAN distribution of Spreadsheet::WriteExcel there is only has one real test and that is to determine if the hardware supports a 64 bit IEEE float.

    The reason that there aren't more tests is that there isn't any way to test the module apart from creating a file, opening it in Excel, checking if the required features are okay and then closing it again. This isn't something that can be automated on a cross-platform basis.

    It would be possible to generate an Excel file, MD5 the results and check it agai
    • Heh - caught me.

      I guess what I expected to see were tests where you write particular strings and numbers to a cell or group of cells, then check to see if the values written to the file are what you expect (like an "od" check or something). I realize that this is somewhat artificial, but it would at least let you know if you had made any *obvious* errors.

      I realize the acid test is to just open the file in Excel and see if it worked. I was just hoping there would be some intermediate testing I could do. :)