Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

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 :)


Comment on Re^2: how use Spreadsheet::ParseExcel::Stream;?
Download Code
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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (11)
As of 2014-08-22 09:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (153 votes), past polls