kalyanrajsista has asked for the wisdom of the Perl Monks concerning the following question:

Hello Monks

I'm trying to download an excel file from a website using WWW::Mechanize module, but downloaded file is of binary format. How can I get the actual content of Excel file and save it to the disk.

use strict;
use WWW::Mechanize;

my $browser = WWW::Mechanize->new();

my $xlurl = "http://some.site.com/InfoCenter/Documents/COPY%20OF%20KIN
+%2014DAYS%20%20%2001%20%20JUNE%20%20%202010.xls";

my $xls = $browser->get($xlurl);

my $xlcontent=$xls->as_string();

[download]

Replies are listed 'Best First'.
Re: Download excel from website and save it to disk
by Gangabass (Vicar) on Jun 01, 2010 at 08:48 UTC
[reply]
Re: Download excel from website and save it to disk
by Corion (Patriarch) on Jun 01, 2010 at 08:56 UTC
[reply]
      my $xlcontent

      [download]

      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.

[reply]
[d/l]

        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

        [download]
        or 
        my $xlcontent = $browser->content;

        [download]

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

[reply]
[d/l]
[select]
Re: Download excel from website and save it to disk
by sierpinski (Chaplain) on Jun 01, 2010 at 12:13 UTC
    Do you have wget available? It's purpose is to retrieve files via http/https.

    You could call it with the usual backticks, exec, or system calls. Detailed documentation for it can be found here.
[reply]
[reply]

Back to Seekers of Perl Wisdom