Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re^2: Download excel from website and save it to disk

by kalyanrajsista (Scribe)
on Jun 01, 2010 at 09:21 UTC ( #842550=note: print w/replies, xml ) Need Help??


in reply to Re: Download excel from website and save it to disk
in thread Download excel from website and save it to disk

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.

Replies are listed 'Best First'.
Re^3: Download excel from website and save it to disk
by Corion (Pope) 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
    or
    my $xlcontent = $browser->content;

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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://842550]
help
Chatterbox?
[Corion]: Discipulus: Notepad++, or Perl ;)
[marto]: xubuntu or lubuntu
[Corion]: :-D
[marto]: my desktop is a core2 duo, 120GB SSD, 4GB RAM, boots to (GUI) login in less than 10 seconds from cold start
[Discipulus]: mah, winbuntu 10...
[marto]: whent he boys start school I'll build myself as new machine, ryzen based
[Corion]: marto: That's cool! I think my (home) desktop spends 30 seconds in the BIOS...
[Corion]: marto: Heh - currently they seem promising, but I think I'll stay with nVidia+Intel for the time being, as I've been bitten too often by bad AMD drivers
Discipulus is (still?) not a big fan of notepad++
[marto]: Corion, I think in the past this was a big problem for them. GPU driver wise the improve all the time. I use the open source drivers on my machine (old R9 270, 2GB) and had no problems

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (7)
As of 2017-07-27 08:56 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I came, I saw, I ...
























    Results (407 votes). Check out past polls.