in reply to Download excel from website and save it to disk

Also, Spreadsheet::Read, or Spreadsheet::ParseExcel, if you mean to read the data stored in the Excel file.

  • Comment on Re: Download excel from website and save it to disk

Replies are listed 'Best First'.
Re^2: Download excel from website and save it to disk
by kalyanrajsista (Scribe) on Jun 01, 2010 at 09:21 UTC
    my $xlcontent

    above variable contain excel data in Binary format which is not actually stored anywhere in my disk, so I can't use any of the Module to read the excel data.

    I'm looking for saving the excel file on the disk and process it afterward.

      Yes. For saving, read up about binmode and print. For processing the data, read up about the modules I already linked to. You will need to do some reading and then some programming.

      Also, your assignment to $xlcontent does propably not do what you want. You want maybe

      $browser->save_content
      or
      my $xlcontent = $browser->content;

      Read WWW::Mechanize in addition to the other module documentation.