jimmyredboy has asked for the wisdom of the Perl Monks concerning the following question:
The file that I am pulling down is only one sheet, not an entire workbook. Thanks!use strict; use warnings; use LWP; use Spreadsheet::ParseExcel; my $url = 'http:// blah blah /login.asp'; my $browser = LWP::UserAgent->new; $browser->cookie_jar({}); my $response = $browser->post( $url, [ 'password' => 'pass', 'userid' => 'user', 'btnsubmit' => 'Submit', ] ); $url = "http://blah blah getdata_RS.asp"; $response = $browser->get( $url ); my $exceldata = $response->content; open (FILE, "> c:\\test.xls");
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Download Excel File off web
by bart (Canon) on Jan 30, 2004 at 17:31 UTC | |
|
Re: Download Excel File off web
by pzbagel (Chaplain) on Jan 30, 2004 at 17:35 UTC | |
|
Re: Download Excel File off web
by jimmyredboy (Initiate) on Jan 30, 2004 at 18:49 UTC |