I did exactly that for the pp to create the .exe package
Here is my code, please take a quick look if you see anything that might be causing the problem when creating the .exe. Thank you very much
use strict;
use Spreadsheet::WriteExcel;
use WWW::Mechanize;
# Create a new instance of Mechanize
my $bot = WWW::Mechanize->new();
$bot->agent_alias( 'Windows Mozilla' );
# Connect to the login page
my $response = $bot->get( 'https://anyURLwithCredentials.com' );
# Get the login form. You might need to change the number.
$bot->form_number(3);
# Enter the login credentials.
$bot->field( username => 'username' );
$bot->field( password => 'password' );
$response = $bot->click();
my $outfile = "out.txt";
open(OUTFILE, ">$outfile");
print OUTFILE $response->decoded_content;
close(OUTFILE);
open(FILE,$outfile);
my @releasesAU;
my @releasesAU3G;
while (<FILE>) {
chomp;
my $lineDATA = $_;
if(index($lineDATA, "H") != -1){
if( $lineDATA =~ /">([_+\w]*)<\/a>/){
print $1, "\n";
push(@releasesAU3G,$1);
}
}
if(index($lineDATA, "H+") != -1){
if( $lineDATA =~ /">([_+\w]*)<\/a>/){
print $1, "\n";
push(@releasesAU,$1);
}
}
}
close(FILE);
my $row = 0;
my $col=0;
my $workbook = Spreadsheet::WriteExcel->new("test.xls");
my $worksheet = $workbook->add_worksheet();
$worksheet->write($row, $col, "Releases H");
$worksheet->write($row, $col+1, "Releases H+");
$row=2;
foreach my $SOP (@releasesAU){
$worksheet->write($row, $col, $SOP);
$row = $row+1;
}
$row =2;
foreach my $SOP (@releasesAU3G){
$worksheet->write($row, $col+1, $SOP);
$row = $row+1;
}
$workbook->close();
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
Outside of code tags, you may need to use entities for some characters:
| |
For: |
|
Use: |
| & | | & |
| < | | < |
| > | | > |
| [ | | [ |
| ] | | ] |
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.
|
|