Click here to get back home

[ANN] Spreadsheet::Read 0.20

 HomeNewsGroups | Search | About
 comp.lang.perl.modules    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
[ANN] Spreadsheet::Read 0.20 H.Merijn Brand 05-31-2007
Posted by H.Merijn Brand on May 31, 2007, 9:38 am
Please log in for more thread options


0.20 Fri 30 May 2007

- perlcritic OK
- CSV parsing now uses getline (), and auto-detects eol
Assumes first line does not contain embedded eol. This implies that
parsing CSV with embedded eol sequences is now safe.
- As I now also maintain Text::CSV_XS, I changed the references
- Changed TODO's from Text::CSV to Text::CSV_PP (::CSV is dated 1997)

0.19 Fri 04 May 2007

- Could not retreive '0' fields from OpenOffice (Jim Kelly)

0.18 Fri 27 Apr 2007

- use strict in Makefile.PL
- Added test_cover make target
- Added "ods" for OpenOffice conversions
- Added color tests for ods (but SR::RS doesn't support that yet)
- Switched from \d to 0-9 in regexp
- Added more test files and tests (increase coverage)

has entered CPAN as

file: $CPAN/authors/id/H/HM/HMBRAND/Spreadsheet-Read-0.20.tgz
size: 64234 bytes
md5: a74f3c99d5181748cdbdefa9a2178d88

Posted by liuhang on June 20, 2007, 12:00 pm
Please log in for more thread options


> 0.20 Fri 30 May 2007
>
> - perlcritic OK
> - CSV parsing now uses getline (), and auto-detects eol
> Assumes first line does not contain embedded eol. This implies that
> parsing CSV with embedded eol sequences is now safe.
> - As I now also maintain Text::CSV_XS, I changed the references
> - Changed TODO's from Text::CSV to Text::CSV_PP (::CSV is dated 1997)
>
> 0.19 Fri 04 May 2007
>
> - Could not retreive '0' fields from OpenOffice (Jim Kelly)
>
> 0.18 Fri 27 Apr 2007
>
> - use strict in Makefile.PL
> - Added test_cover make target
> - Added "ods" for OpenOffice conversions
> - Added color tests for ods (but SR::RS doesn't support that yet)
> - Switched from \d to 0-9 in regexp
> - Added more test files and tests (increase coverage)
>
> has entered CPAN as
>
> file: $CPAN/authors/id/H/HM/HMBRAND/Spreadsheet-Read-0.20.tgz
> size: 64234 bytes
> md5: a74f3c99d5181748cdbdefa9a2178d88

Hi, Merijn,

I was trying to install Spreadsheet::Read 0.22 but met some failed
testing. The following is the report from the whole installation
procedure, what should I do?

I'm on Solaris 9/Sparc, I believe I've installed all the
prerequisites.

TIA.
Alan

#########################################
# perl Makefile.PL
Do you want to install 'xlscat' (Convert Spreadsheet to plain text or
CSV) ? [n] y
Do you want to install 'ss2tk' (Show a Spreadsheet in Perl/Tk) ? [n]
y
Writing Makefile for Spreadsheet::Read
# make
cp Read.pm blib/lib/Spreadsheet/Read.pm
cp examples/ss2tk blib/script/ss2tk
/usr/local/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/
ss2tk
cp examples/xlscat blib/script/xlscat
/usr/local/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/
xlscat
Manifying blib/man3/Spreadsheet::Read.3
# make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00_pod.......skipped
all skipped: Test::Pod 1.00 required for testing POD
t/01_pod.......skipped
all skipped: Test::Pod::Covarage required for testing POD
Coverage
t/
10_basics....ok
t/
11_call......ok
t/
20_csv.......ok
t/
21_csv.......ok
t/30_xls.......NOK
53
# Failed test 'Sheet count'
# in t/30_xls.t at line 39.
# got: undef
# expected: '2'
t/30_xls.......NOK
55
# Failed test 'Sheet list count'
# in t/30_xls.t at line 41.
# got: '0'
# expected: '2'
t/30_xls.......NOK
58
# Failed test 'Unformatted cell A1'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A1'
t/30_xls.......NOK
59
# Failed test 'Formatted cell A1'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A1'
t/30_xls.......NOK
60
# Failed test 'Unformatted cell A2'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A2'
t/30_xls.......NOK
61
# Failed test 'Formatted cell A2'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A2'
t/30_xls.......NOK
62
# Failed test 'Unformatted cell A3'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A3'
t/30_xls.......NOK
63
# Failed test 'Formatted cell A3'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A3'
t/30_xls.......NOK
64
# Failed test 'Unformatted cell A4'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A4'
t/30_xls.......NOK
65
# Failed test 'Formatted cell A4'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A4'
t/30_xls.......NOK
66
# Failed test 'Unformatted cell B1'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'B1'
t/30_xls.......NOK
67
# Failed test 'Formatted cell B1'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'B1'
t/30_xls.......NOK
68
# Failed test 'Unformatted cell B2'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'B2'
t/30_xls.......NOK
69
# Failed test 'Formatted cell B2'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'B2'
t/30_xls.......NOK
70
# Failed test 'Unformatted cell B4'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'B4'
t/30_xls.......NOK
71
# Failed test 'Formatted cell B4'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'B4'
t/30_xls.......NOK
72
# Failed test 'Unformatted cell C3'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'C3'
t/30_xls.......NOK
73
# Failed test 'Formatted cell C3'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'C3'
t/30_xls.......NOK
74
# Failed test 'Unformatted cell C4'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'C4'
t/30_xls.......NOK
75
# Failed test 'Formatted cell C4'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'C4'
t/30_xls.......NOK
76
# Failed test 'Unformatted cell D1'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'D1'
t/30_xls.......NOK
77
# Failed test 'Formatted cell D1'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'D1'
t/30_xls.......NOK
78
# Failed test 'Unformatted cell D3'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'D3'
t/30_xls.......NOK
79
# Failed test 'Formatted cell D3'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'D3'

# Failed test 'Row'ed rows'
# in t/30_xls.t at line 59.
# got: '0'
# expected: '4'
Can't use an undefined value as an ARRAY reference at t/30_xls.t line
60.
# Looks like you planned 217 tests but only ran 91.
# Looks like you failed 25 tests of 91 run.
# Looks like your test died just after 91.
t/
30_xls.......dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 53, 55, 58-79, 91-217
Failed 151/217 tests, 30.41% okay
t/
31_clr.......ok
t/
32_fmt.......ok
t/
33_misc......ok
t/
40_sxc.......ok
t/
45_ods.......ok
t/46_clr.......skipped
all skipped: Spreadsheet::ReadSXC version 0.20 doesn't support
field attributes
t/
50_sc........ok
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/30_xls.t 255 65280 217 277 127.65% 53 55 58-79 91-217
3 tests skipped.
Failed 1/14 test scripts, 92.86% okay. 151/1471 subtests failed,
89.73% okay.
make: *** [test_dynamic] Error 29
# perl -Mblib t/30_xls.t
1..217
ok 1 - Nonexistent file
ok 2 - Empty file
ok 3 - Read/Parse xls file
ok 4 - Base values
ok 5 - Return type
ok 6 - Spreadsheet type
ok 7 - Sheet count
ok 8 - Sheet list
ok 9 - Sheet list count
ok 10 - Parser version
ok 11 - Defined fields
ok 12 - Unformatted cell A1
ok 13 - Formatted cell A1
ok 14 - Unformatted cell A2
ok 15 - Formatted cell A2
ok 16 - Unformatted cell A3
ok 17 - Formatted cell A3
ok 18 - Unformatted cell A4
ok 19 - Formatted cell A4
ok 20 - Unformatted cell B1
ok 21 - Formatted cell B1
ok 22 - Unformatted cell B2
ok 23 - Formatted cell B2
ok 24 - Unformatted cell B4
ok 25 - Formatted cell B4
ok 26 - Unformatted cell C3
ok 27 - Formatted cell C3
ok 28 - Unformatted cell C4
ok 29 - Formatted cell C4
ok 30 - Unformatted cell D1
ok 31 - Formatted cell D1
ok 32 - Unformatted cell D3
ok 33 - Formatted cell D3
ok 34 - Undefined fields
ok 35 - Unformatted cell B3
ok 36 - Formatted cell B3
ok 37 - Unformatted cell C1
ok 38 - Formatted cell C1
ok 39 - Unformatted cell C2
ok 40 - Formatted cell C2
ok 41 - Unformatted cell D2
ok 42 - Formatted cell D2
ok 43 - Unformatted cell D4
ok 44 - Formatted cell D4
ok 45 - Row'ed rows
ok 46 - Row'ed columns
ok 47 - Row'ed value D1
ok 48 - Row'ed value C4
ok 49 - Parse xls data
ok 50 - Base values
ok 51 - Return type
ok 52 - Spreadsheet type
not ok 53 - Sheet count
# Failed test 'Sheet count'
# in t/30_xls.t at line 39.
# got: undef
# expected: '2'
ok 54 - Sheet list
not ok 55 - Sheet list count
# Failed test 'Sheet list count'
# in t/30_xls.t at line 41.
# got: '0'
# expected: '2'
ok 56 - Parser version
ok 57 - Defined fields
not ok 58 - Unformatted cell A1
# Failed test 'Unformatted cell A1'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A1'
not ok 59 - Formatted cell A1
# Failed test 'Formatted cell A1'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A1'
not ok 60 - Unformatted cell A2
# Failed test 'Unformatted cell A2'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A2'
not ok 61 - Formatted cell A2
# Failed test 'Formatted cell A2'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A2'
not ok 62 - Unformatted cell A3
# Failed test 'Unformatted cell A3'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A3'
not ok 63 - Formatted cell A3
# Failed test 'Formatted cell A3'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A3'
not ok 64 - Unformatted cell A4
# Failed test 'Unformatted cell A4'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A4'
not ok 65 - Formatted cell A4
# Failed test 'Formatted cell A4'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A4'
not ok 66 - Unformatted cell B1
# Failed test 'Unformatted cell B1'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'B1'
not ok 67 - Formatted cell B1
# Failed test 'Formatted cell B1'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'B1'
not ok 68 - Unformatted cell B2
# Failed test 'Unformatted cell B2'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'B2'
not ok 69 - Formatted cell B2
# Failed test 'Formatted cell B2'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'B2'
not ok 70 - Unformatted cell B4
# Failed test 'Unformatted cell B4'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'B4'
not ok 71 - Formatted cell B4
# Failed test 'Formatted cell B4'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'B4'
not ok 72 - Unformatted cell C3
# Failed test 'Unformatted cell C3'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'C3'
not ok 73 - Formatted cell C3
# Failed test 'Formatted cell C3'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'C3'
not ok 74 - Unformatted cell C4
# Failed test 'Unformatted cell C4'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'C4'
not ok 75 - Formatted cell C4
# Failed test 'Formatted cell C4'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'C4'
not ok 76 - Unformatted cell D1
# Failed test 'Unformatted cell D1'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'D1'
not ok 77 - Formatted cell D1
# Failed test 'Formatted cell D1'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'D1'
not ok 78 - Unformatted cell D3
# Failed test 'Unformatted cell D3'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'D3'
not ok 79 - Formatted cell D3
# Failed test 'Formatted cell D3'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'D3'
ok 80 - Undefined fields
ok 81 - Unformatted cell B3
ok 82 - Formatted cell B3
ok 83 - Unformatted cell C1
ok 84 - Formatted cell C1
ok 85 - Unformatted cell C2
ok 86 - Formatted cell C2
ok 87 - Unformatted cell D2
ok 88 - Formatted cell D2
ok 89 - Unformatted cell D4
ok 90 - Formatted cell D4
not ok 91 - Row'ed rows
# Failed test 'Row'ed rows'
# in t/30_xls.t at line 59.
# got: '0'
# expected: '4'
Can't use an undefined value as an ARRAY reference at t/30_xls.t line
60.
# Looks like you planned 217 tests but only ran 91.
# Looks like you failed 25 tests of 91 run.
# Looks like your test died just after 91.


Posted by H.Merijn Brand on June 21, 2007, 7:12 am
Please log in for more thread options


Thanks to David Cantrell, who ran into the same problems on OpenBSD, and=
=

kindly
offered my access to the failing box, I think I have nailed it down.

0.23 has entered CPAN as

file: $CPAN/authors/id/H/HM/HMBRAND/Spreadsheet-Read-0.23.tar.gz
size: 64710 bytes
md5: 8d9c6b8f7ca38ef6966724ccc3090b45

No action is required on your part
Request entered by: HMBRAND (H.Merijn Brand)
Request entered on: Thu, 21 Jun 2007 10:51:24 GMT
Request completed: Thu, 21 Jun 2007 10:52:58 GMT

0.23 Thu 21 Jun 2007

- Use IO::Scalar instead of File::Temp when installed
Thanks to David Cantrell for making a OpenBSD test box available!=

- use binmode () when opening files
- Also use 3-arg open in test files
- die if test files cannot be opene'ed

0.22 Mon 18 Jun 2007

- 0.21 should already support Text::CSV_PP 1.05
Tested Text::CSV_PP 1.05 on bleadperl.
- Better detection of (not) installed modules
- Module requires perl 5.6.x

0.21 Mon 18 Jun 2007

- Text::CSV_XS uses keep_meta_info instead of get_flags
- Removed always_quote from xlscat's CSV output

0.20 Thu 31 May 2007

- perlcritic OK
- CSV parsing now uses getline (), and auto-detects eol
Assumes first line does not contain embedded eol. This implies th=
at
parsing CSV with embedded eol sequences is now safe.
- As I now also maintain Text::CSV_XS, I changed the references
- Changed TODO's from Text::CSV to Text::CSV_PP (::CSV is dated 199=
7)


>> 0.20 Fri 30 May 2007
>>
>> - perlcritic OK
>> - CSV parsing now uses getline (), and auto-detects eol
>> Assumes first line does not contain embedded eol. This implies=
=

>> that
>> parsing CSV with embedded eol sequences is now safe.
>> - As I now also maintain Text::CSV_XS, I changed the references
>> - Changed TODO's from Text::CSV to Text::CSV_PP (::CSV is dated =
=

>> 1997)
>
> Hi, Merijn,
>
> I was trying to install Spreadsheet::Read 0.22 but met some failed
> testing. The following is the report from the whole installation
> procedure, what should I do?
>
> I'm on Solaris 9/Sparc, I believe I've installed all the
> prerequisites.
>
> TIA.
> Alan
>
> #########################################
> # perl Makefile.PL
> Do you want to install 'xlscat' (Convert Spreadsheet to plain text or
> CSV) ? [n] y
> Do you want to install 'ss2tk' (Show a Spreadsheet in Perl/Tk) ? [n]
> y
> Writing Makefile for Spreadsheet::Read
> # make
> cp Read.pm blib/lib/Spreadsheet/Read.pm
> cp examples/ss2tk blib/script/ss2tk
> /usr/local/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script=
/
> ss2tk
> cp examples/xlscat blib/script/xlscat
> /usr/local/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script=
/
> xlscat
> Manifying blib/man3/Spreadsheet::Read.3
> # make test
> PERL_DL_NONLAZY=3D1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"=

> "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
> t/00_pod.......skipped
> all skipped: Test::Pod 1.00 required for testing POD
> t/01_pod.......skipped
> all skipped: Test::Pod::Covarage required for testing POD
> Coverage
> t/
> 10_basics....ok
> t/
> 11_call......ok
> t/
> 20_csv.......ok
> t/
> 21_csv.......ok
> t/30_xls.......NOK
> 53
> # Failed test 'Sheet count'
> # in t/30_xls.t at line 39.
> # got: undef
> # expected: '2'
> t/30_xls.......NOK
> 55
> # Failed test 'Sheet list count'
> # in t/30_xls.t at line 41.
> # got: '0'
> # expected: '2'
> t/30_xls.......NOK
> 58
> # Failed test 'Unformatted cell A1'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'A1'
> t/30_xls.......NOK
> 59
> # Failed test 'Formatted cell A1'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'A1'
> t/30_xls.......NOK
> 60
> # Failed test 'Unformatted cell A2'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'A2'
> t/30_xls.......NOK
> 61
> # Failed test 'Formatted cell A2'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'A2'
> t/30_xls.......NOK
> 62
> # Failed test 'Unformatted cell A3'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'A3'
> t/30_xls.......NOK
> 63
> # Failed test 'Formatted cell A3'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'A3'
> t/30_xls.......NOK
> 64
> # Failed test 'Unformatted cell A4'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'A4'
> t/30_xls.......NOK
> 65
> # Failed test 'Formatted cell A4'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'A4'
> t/30_xls.......NOK
> 66
> # Failed test 'Unformatted cell B1'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'B1'
> t/30_xls.......NOK
> 67
> # Failed test 'Formatted cell B1'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'B1'
> t/30_xls.......NOK
> 68
> # Failed test 'Unformatted cell B2'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'B2'
> t/30_xls.......NOK
> 69
> # Failed test 'Formatted cell B2'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'B2'
> t/30_xls.......NOK
> 70
> # Failed test 'Unformatted cell B4'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'B4'
> t/30_xls.......NOK
> 71
> # Failed test 'Formatted cell B4'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'B4'
> t/30_xls.......NOK
> 72
> # Failed test 'Unformatted cell C3'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'C3'
> t/30_xls.......NOK
> 73
> # Failed test 'Formatted cell C3'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'C3'
> t/30_xls.......NOK
> 74
> # Failed test 'Unformatted cell C4'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'C4'
> t/30_xls.......NOK
> 75
> # Failed test 'Formatted cell C4'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'C4'
> t/30_xls.......NOK
> 76
> # Failed test 'Unformatted cell D1'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'D1'
> t/30_xls.......NOK
> 77
> # Failed test 'Formatted cell D1'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'D1'
> t/30_xls.......NOK
> 78
> # Failed test 'Unformatted cell D3'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'D3'
> t/30_xls.......NOK
> 79
> # Failed test 'Formatted cell D3'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'D3'
>
> # Failed test 'Row'ed rows'
> # in t/30_xls.t at line 59.
> # got: '0'
> # expected: '4'
> Can't use an undefined value as an ARRAY reference at t/30_xls.t line
> 60.
> # Looks like you planned 217 tests but only ran 91.
> # Looks like you failed 25 tests of 91 run.
> # Looks like your test died just after 91.
> t/
> 30_xls.......dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 53, 55, 58-79, 91-217
> Failed 151/217 tests, 30.41% okay
> t/
> 31_clr.......ok
> t/
> 32_fmt.......ok
> t/
> 33_misc......ok
> t/
> 40_sxc.......ok
> t/
> 45_ods.......ok
> t/46_clr.......skipped
> all skipped: Spreadsheet::ReadSXC version 0.20 doesn't support=

> field attributes
> t/
> 50_sc........ok
> Failed Test Stat Wstat Total Fail Failed List of Failed
> ----------------------------------------------------------------------=
---------
> t/30_xls.t 255 65280 217 277 127.65% 53 55 58-79 91-217
> 3 tests skipped.
> Failed 1/14 test scripts, 92.86% okay. 151/1471 subtests failed,
> 89.73% okay.
> make: *** [test_dynamic] Error 29
> # perl -Mblib t/30_xls.t
> 1..217
> ok 1 - Nonexistent file
> ok 2 - Empty file
> ok 3 - Read/Parse xls file
> ok 4 - Base values
> ok 5 - Return type
> ok 6 - Spreadsheet type
> ok 7 - Sheet count
> ok 8 - Sheet list
> ok 9 - Sheet list count
> ok 10 - Parser version
> ok 11 - Defined fields
> ok 12 - Unformatted cell A1
> ok 13 - Formatted cell A1
> ok 14 - Unformatted cell A2
> ok 15 - Formatted cell A2
> ok 16 - Unformatted cell A3
> ok 17 - Formatted cell A3
> ok 18 - Unformatted cell A4
> ok 19 - Formatted cell A4
> ok 20 - Unformatted cell B1
> ok 21 - Formatted cell B1
> ok 22 - Unformatted cell B2
> ok 23 - Formatted cell B2
> ok 24 - Unformatted cell B4
> ok 25 - Formatted cell B4
> ok 26 - Unformatted cell C3
> ok 27 - Formatted cell C3
> ok 28 - Unformatted cell C4
> ok 29 - Formatted cell C4
> ok 30 - Unformatted cell D1
> ok 31 - Formatted cell D1
> ok 32 - Unformatted cell D3
> ok 33 - Formatted cell D3
> ok 34 - Undefined fields
> ok 35 - Unformatted cell B3
> ok 36 - Formatted cell B3
> ok 37 - Unformatted cell C1
> ok 38 - Formatted cell C1
> ok 39 - Unformatted cell C2
> ok 40 - Formatted cell C2
> ok 41 - Unformatted cell D2
> ok 42 - Formatted cell D2
> ok 43 - Unformatted cell D4
> ok 44 - Formatted cell D4
> ok 45 - Row'ed rows
> ok 46 - Row'ed columns
> ok 47 - Row'ed value D1
> ok 48 - Row'ed value C4
> ok 49 - Parse xls data
> ok 50 - Base values
> ok 51 - Return type
> ok 52 - Spreadsheet type
> not ok 53 - Sheet count
> # Failed test 'Sheet count'
> # in t/30_xls.t at line 39.
> # got: undef
> # expected: '2'
> ok 54 - Sheet list
> not ok 55 - Sheet list count
> # Failed test 'Sheet list count'
> # in t/30_xls.t at line 41.
> # got: '0'
> # expected: '2'
> ok 56 - Parser version
> ok 57 - Defined fields
> not ok 58 - Unformatted cell A1
> # Failed test 'Unformatted cell A1'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'A1'
> not ok 59 - Formatted cell A1
> # Failed test 'Formatted cell A1'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'A1'
> not ok 60 - Unformatted cell A2
> # Failed test 'Unformatted cell A2'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'A2'
> not ok 61 - Formatted cell A2
> # Failed test 'Formatted cell A2'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'A2'
> not ok 62 - Unformatted cell A3
> # Failed test 'Unformatted cell A3'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'A3'
> not ok 63 - Formatted cell A3
> # Failed test 'Formatted cell A3'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'A3'
> not ok 64 - Unformatted cell A4
> # Failed test 'Unformatted cell A4'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'A4'
> not ok 65 - Formatted cell A4
> # Failed test 'Formatted cell A4'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'A4'
> not ok 66 - Unformatted cell B1
> # Failed test 'Unformatted cell B1'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'B1'
> not ok 67 - Formatted cell B1
> # Failed test 'Formatted cell B1'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'B1'
> not ok 68 - Unformatted cell B2
> # Failed test 'Unformatted cell B2'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'B2'
> not ok 69 - Formatted cell B2
> # Failed test 'Formatted cell B2'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'B2'
> not ok 70 - Unformatted cell B4
> # Failed test 'Unformatted cell B4'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'B4'
> not ok 71 - Formatted cell B4
> # Failed test 'Formatted cell B4'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'B4'
> not ok 72 - Unformatted cell C3
> # Failed test 'Unformatted cell C3'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'C3'
> not ok 73 - Formatted cell C3
> # Failed test 'Formatted cell C3'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'C3'
> not ok 74 - Unformatted cell C4
> # Failed test 'Unformatted cell C4'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'C4'
> not ok 75 - Formatted cell C4
> # Failed test 'Formatted cell C4'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'C4'
> not ok 76 - Unformatted cell D1
> # Failed test 'Unformatted cell D1'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'D1'
> not ok 77 - Formatted cell D1
> # Failed test 'Formatted cell D1'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'D1'
> not ok 78 - Unformatted cell D3
> # Failed test 'Unformatted cell D3'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'D3'
> not ok 79 - Formatted cell D3
> # Failed test 'Formatted cell D3'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'D3'
> ok 80 - Undefined fields
> ok 81 - Unformatted cell B3
> ok 82 - Formatted cell B3
> ok 83 - Unformatted cell C1
> ok 84 - Formatted cell C1
> ok 85 - Unformatted cell C2
> ok 86 - Formatted cell C2
> ok 87 - Unformatted cell D2
> ok 88 - Formatted cell D2
> ok 89 - Unformatted cell D4
> ok 90 - Formatted cell D4
> not ok 91 - Row'ed rows
> # Failed test 'Row'ed rows'
> # in t/30_xls.t at line 59.
> # got: '0'
> # expected: '4'
> Can't use an undefined value as an ARRAY reference at t/30_xls.t line
> 60.
> # Looks like you planned 217 tests but only ran 91.
> # Looks like you failed 25 tests of 91 run.
> # Looks like your test died just after 91.
>


Similar ThreadsPosted
ANN: Spreadsheet::Read 0.15 June 21, 2006, 12:40 pm
ANN: Spreadsheet::Read 0.16 July 4, 2006, 7:01 am
Re: ANN: Spreadsheet::Read 0.16 July 4, 2006, 9:36 am
Problem with Spreadsheet::Read June 8, 2006, 4:56 am
Announce: Spreadsheet::Read-0.23 June 21, 2007, 7:14 am
Spreadsheet::ParseExcel : read cell-notes May 27, 2005, 11:54 am
Spreadsheet::Read special characters handling November 20, 2006, 2:33 am
"500 SSL read timeout" September 27, 2004, 11:50 am
How to read an IFO file ? February 25, 2006, 3:12 pm
Serialport Read question October 28, 2004, 11:59 am

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap