Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight

Re^2: how use Spreadsheet::ParseExcel::Stream;?

by cibien (Novice)
on Jan 30, 2013 at 22:01 UTC ( #1016161=note: print w/replies, xml ) Need Help??

in reply to Re: how use Spreadsheet::ParseExcel::Stream;?
in thread how use Spreadsheet::ParseExcel::Stream;?

Thankyou very much! I understand now :) but I try with my code and nothing... the xml output is null.
my $xls = Spreadsheet::ParseExcel::Stream->new($data_folder.$filenam +e, \%options); while ( my $sheet = $xls->sheet() ) { while ( my $row = $sheet->row ) { my @data = @$row; } } for(my $iSheet=0; $iSheet < $xls->{SheetCount} ; $iSheet++) { my $oWkS = $xls->{Worksheet}[$iSheet];
I'am too much novice in perl to try.. anyway thankyou for your help :)

Replies are listed 'Best First'.
Re^3: how use Spreadsheet::ParseExcel::Stream;?
by runrig (Abbot) on Jan 31, 2013 at 01:27 UTC
    the xml output is null.
    What XML output? You're not printing anything. And why do you have this code:
    for(my $iSheet=0; $iSheet < $xls->{SheetCount} ; $iSheet++) { my $oWkS = $xls->{Worksheet}[$iSheet];
    That code is for Spreadsheet::ParseExcel, not Spreadsheet::ParseExcel::Stream.
      Sorry, I'am confused... :( first step in perl...
        Post a minimal amount of code that doesn't work as expected, and explain why it doesn't work as expected.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1016161]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (7)
As of 2016-10-24 00:38 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (302 votes). Check out past polls.