Hi Perl Monks, I use Spreadsheet::ParseExce (interface to Excel data) but I have a memory overhead. I can solve the problem using Spreadsheet::ParseExcel::Stream does not parse the entire document to memory with no memory overhead. But I'am novice in perl and I not know how apply this module. can you help me? here is the first part of the code: 

use Encode;
use utf8;
use XML::LibXML;
use Spreadsheet::ParseExcel;


system("cls");


my $materialmapping_file = shift;
my $data_folder = shift;


unless (defined $materialmapping_file and defined $data_folder)
   {
      print "Usage: $0 <materialmapping_file> <data_folder>\n";
      exit;
   }

    opendir ( DIR, $data_folder ) || die "Error in opening dir $data_f
+older\n";
    
    my $materialmapping_table_xml = XML::LibXML->createDocument( "1.0"
+, "UTF-8");
    my $materialmapping_table_xml_root = $materialmapping_table_xml->c
+reateElement("masterdata");
    $materialmapping_table_xml_root->setAttribute('version',getSQLTime
+Stamp());
    $materialmapping_table_xml->setDocumentElement($materialmapping_ta
+ble_xml_root);
    
    print "loading...\n";
    while(($filename = readdir(DIR))){
        
        next unless $filename =~ /\.xls$/i;

            print " - $filename \n";


            
            my $parser     = Spreadsheet::ParseExcel->new();

            my $oBook  = $parser->parse($data_folder.$filename);
             next unless defined $oBook;




                for(my $iSheet=0; $iSheet < $oBook->{SheetCount} ; $iS
+heet++) {
                       $oWkS = $oBook->{Worksheet}[$iSheet];

[download]
please help me, here is the site "http://search.cpan.org/~dougw/Spreadsheet-ParseExcel-Stream-0.05/Stream.pm" thank you very much Andrea

In reply to how use Spreadsheet::ParseExcel::Stream;? by cibien

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.