1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
#!/usr/bin/perl
use strict;
use warnings;
BEGIN { $ENV{SPREADSHEET_READ_CSV} = "Text::CSV_XS"; }
my $tests = 12;
use Test::More;
require Test::NoWarnings;
use Spreadsheet::Read;
Spreadsheet::Read::parses ("csv") or
plan skip_all => "Cannot use $ENV{SPREADSHEET_READ_CSV}";
my $csv;
ok ($csv = ReadData ("files/test.csv"), "Read/Parse csv file");
is ($csv->[0]{sepchar}, ",", "{sepchar}");
is ($csv->[0]{quote}, '"', "{quote}");
is ($csv->[1]{C3}, "C3", "cell C3");
ok ($csv = ReadData ("files/test_m.csv"), "Read/Parse csv file (;)");
is ($csv->[0]{sepchar}, ";", "{sepchar}");
is ($csv->[0]{quote}, '"', "{quote}");
is ($csv->[1]{C3}, "C3", "cell C3");
ok ($csv = ReadData ("files/test_t.csv", quote => "'"),
"Read/Parse csv file (tabs)");
is ($csv->[0]{sepchar}, "\t", "{sepchar}");
is ($csv->[0]{quote}, "'", "{quote}");
is ($csv->[1]{C3}, "C3", "cell C3");
unless ($ENV{AUTOMATED_TESTING}) {
Test::NoWarnings::had_no_warnings ();
$tests++;
}
done_testing ($tests);
|
