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` [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]
Re^3: Download excel from website and save it to disk by Corion (Patriarch) on Jun 01, 2010 at 09:23 UTC
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]