blib/lib/XML/SAXDriver/Excel.pm

filter: Statementstmt 100% 9 / 9 Branchbran n/a Conditioncond n/a MC/DCmcdc n/a Subroutinesub 100% 3 / 3 Podpod n/a totaltotal 100% 12 / 12 CC 1 SCAR 0.0
CC
1
Cov
100%
BEGIN
1.0
BEGIN
1.0
BEGIN
1.0
CRAP 1.0
↑ Summary
1 package XML::SAXDriver::Excel;
2
3 1 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
4
5 1 ▶use Spreadsheet::ParseExcel;
Subroutine BEGIN: called CC=1 SCAR=0.0
6
7 1 ▶use base qw(XML::SAX::Base);
Subroutine BEGIN: called CC=1 SCAR=0.0
8 use vars qw($VERSION $NS_SAXDriver_Excel);
9 $VERSION = '0.06';
10 $NS_SAXDriver_Excel = 'http://xmlns.perl.org/sax/XML::SAXDriver::Excel';
11
12 sub _parse_bytestream
13 {
14 my $self = shift;
15 my $stream = shift;
16
17 die ("Cannot use String to parse a binary Excel file. You can only use a file by setting SystemId");
18
19 $self->_parse_Excel(\$stream);
20 }
21 sub _parse_string
22 {
23 my $self = shift;
24 my $stream = shift;
25
26 ### This is experimental due to the binary streams
27 #require IO::String;
28 #$io = IO::String->new($var);
29 #$self->_parse_Excel($io);
30
31 die ("Cannot use String to parse a binary Excel file. You can only use a file by setting SystemId");
32
33 #my @strings = split("\n", $self->{ParseOptions}->{Source}{String});
34 #$self->_parse_Excel(\@strings);
35 }
36 sub _parse_systemid
37 {
38 my $self = shift;
39 my $path = shift;
40
41 $self->_init();
42 $self->{ParseOptions}->{Parser}->Parse($path);
43 $self->_end();
44
45 }
46
47 sub _init {
48 my $self = shift;
49
50 ### Reset vars before parsing
51 $self->{_row} = []; ## Used to push row values per row
52 $self->{_row_num} = -1; ## Set at -1 since rows are counted from 0
53 $self->{_last_row_num} = 0; ## Used to save the last row value received
54 $self->{_last_col} = 0;
55
56 $self->{ParseOptions}->{Parser} ||= Spreadsheet::ParseExcel->new(CellHandler => \&cb_routine, Object => $self, NotSetCell => 1);
57
58 $self->{ParseOptions}->{Headings_Handler} ||= \&_normalize_heading;
59
60 $self->{_document} = {};
61 $self->{ParseOptions}->{Handler}->start_document($self->{_document});
62 $self->xml_decl($self->{ParseOptions}->{Declaration});
63 my $pm_excel = $self->_create_node(
64 Prefix => 'SAXDriver::Excel',
65 NamespaceURI => $NS_SAXDriver_Excel,
66 );
67 $self->start_prefix_mapping($pm_excel);
68 $self->end_prefix_mapping($pm_excel);
69
70 $self->{_doc_element} = {
71 Name => $self->{ParseOptions}->{File_Tag} || "records",
72 Attributes => {},
73 };
74
75 $self->{ParseOptions}->{Handler}->start_element($self->{_doc_element});
76 }
77
78 ## Parse file or string
79
80
81 sub _end
82 {
83 my $self = shift;
84 _print_xml_finish($self);
85
86 ### Reset vars after parsing
87 $self->{_row} = []; ## Used to push row values per row
88 $self->{_row_num} = -1; ## Set at -1 since rows are counted from 0
89 $self->{_last_row_num} = 0; ## Used to save the last row value received
90
91 $self->{ParseOptions}->{Handler}->end_element($self->{_doc_element});
92
93 return $self->{ParseOptions}->{Handler}->end_document($self->{_document});
94
95 }
96
97 sub cb_routine($$$$$$)
98 {
99 my ($self, $oBook, $iSheet, $iRow, $iCol, $oCell) = @_;
100
101 my $oWkS = $oBook->{Worksheet}[$iSheet];
102
103 $self->{ParseOptions}->{Col_Headings} ||= [];
104
105 if ($iCol < $oWkS->{MaxCol})
106 {
107
108 if ($self->{_last_col} > $iCol)
109 {
110 while ($self->{_last_col} < $oWkS->{MaxCol})
111 {
112 push(@{$self->{_row}}, undef);
113 $self->{_last_col}++;
114 }
115 _print_xml(@_);
116 }
117
118 if ($self->{_last_col} < $iCol)
119 {
120 while ($self->{_last_col} < $iCol)
121 {
122 push(@{$self->{_row}}, undef);
123 $self->{_last_col}++;
124 }
125 }
126
127 push(@{$self->{_row}}, $oCell->Value());
128 $self->{_last_row_num} = $iRow;
129 $self->{_last_col}++;
130 return;
131
132
133 }
134
135 push(@{$self->{_row}}, $oCell->Value());# if $flag == 0;
136
137 _print_xml(@_);
138 return;
139
140 }
141
142 sub _normalize_heading ### Default if no Headings_Handler is provided
143 {
144 my $heading= shift;
145 my $sub_char = shift || '_';
146 $heading =~ s/^\s//g;
147 $heading =~ s/\s$//g;
148 $heading =~ s/^([^a-zA-Z|^_|^:])/$sub_char/g; ### We used to also replace the xml in the beginning, but I took it of per recommendation of Michael Rodriguez.
149 $heading =~ s/[^a-zA-Z|^-|^.|^0-9|^:]/$sub_char/g;
150 return $heading;
151 }
152
153
154 sub _print_xml
155 {
156 my ($self, $oBook, $iSheet, $iRow, $iCol, $oCell) = @_; ### Remember self is passed through the Spreadsheet::ParseExcel object
157
158 my $oWkS = $oBook->{Worksheet}[$iSheet];
159
160 $self->{_last_row_num} = $iRow;
161
162
163 $self->{_last_col} = 0;
164 my $temp_row = $oCell->Value();
165 $self->{_row_num} = $self->{_last_row_num};
166
167
168 if (!@{$self->{ParseOptions}->{Col_Headings}} && !$self->{ParseOptions}->{Dynamic_Col_Headings})
169 {
170 my $i = 1;
171 @{$self->{ParseOptions}->{Col_Headings}} = map { "column" . $i++ } @{$self->{_row}};
172 }
173 elsif (!@{$self->{ParseOptions}->{Col_Headings}} && $self->{ParseOptions}->{Dynamic_Col_Headings})
174 {
175 @{$self->{ParseOptions}->{Col_Headings}} = map { $self->{ParseOptions}->{Headings_Handler}->($_, $self->{ParseOptions}->{SubChar}); } @{$self->{_row}};
176 $self->{_row} = []; ### Clear the @$row array
177 return; ### So that it does not print the column headings as the content of the first node.
178 }
179
180
181 my $el = {
182 Name => $self->{ParseOptions}->{Parent_Tag} || "record",
183 Attributes => {},
184 };
185
186 $self->{ParseOptions}->{Handler}->start_element($el);
187
188 for (my $i = 0; $i <= $#{$self->{ParseOptions}->{Col_Headings}}; $i++) {
189 my $column = { Name => $self->{ParseOptions}->{Col_Headings}->[$i], Attributes => {} };
190
191 $self->{ParseOptions}->{Handler}->start_element($column);
192 $self->{ParseOptions}->{Handler}->characters({Data => $self->{_row}->[$i]});
193 $self->{ParseOptions}->{Handler}->end_element($column);
194 }
195
196 $self->{ParseOptions}->{Handler}->end_element($el);
197
198 $self->{_row} = []; ### Clear $row and start the new row processing
199
200 }
201
202 sub _print_xml_finish
203 {
204 my $self = shift;
205
206 while (@{$self->{_row}} < 9)
207 {
208 push(@{$self->{_row}}, undef);
209 }
210
211 my $el = {
212 Name => $self->{ParseOptions}->{Parent_Tag} || "record",
213 Attributes => {},
214 };
215
216 $self->{ParseOptions}->{Handler}->start_element($el);
217
218 for (my $i = 0; $i <= $#{$self->{ParseOptions}->{Col_Headings}}; $i++) {
219 my $column = { Name => $self->{ParseOptions}->{Col_Headings}->[$i], Attributes => {} };
220
221 $self->{ParseOptions}->{Handler}->start_element($column);
222 $self->{ParseOptions}->{Handler}->characters({Data => $self->{_row}->[$i]});
223 $self->{ParseOptions}->{Handler}->end_element($column);
224 }
225
226 $self->{ParseOptions}->{Handler}->end_element($el);
227 }
228
229 sub _create_node {
230 shift;
231 # this may check for a factory later
232 return {@_};
233 }
234
235 1;
236 __END__
↑ Summary