im running this in activeperl in windows.
my $parser = Spreadsheet::ParseExcel->new();
my $workbook = $parser->parse('build.xlsx');
if ( !defined $workbook ) {
die $parser->error(), ".\n";
}
for my $worksheet ( $workbook->worksheets() ) {
my ( $row_min, $
I am using the spreadsheet::xlsx module in a script im writing. I need to
extract about 4 columns out of about 60. I need those specific columns for
comparison and updating. I assume that I'll load the data into an array or an
array of arrays for comparison. I am able to extract the contents of
I am using Spreadsheet::xlsx in a script that im using to pull data from two
separate columns in a spreadhseet and compare them. I only need a few of the
columns.
I have written a script that pulls the data from the spreadsheet and prints it
to a file. I need to specify specific columns. I assu
On Thu, May 24, 2012 at 11:41 AM, Ken Furff wrote:
> I am using the spreadsheet::xlsx module in a script im writing. I need to
> extract about 4 columns out of about 60. I need those specific columns for
> comparison and updating. I assume that I'll load the data into an array or an
> array of
Though I'm pretty sure you can parse xlsx, I've never done it. I'd start by
finding the error method of the module and .. or die "something useful " .
$ws->error; also note there's a mailing for these modules - you might
search and ask there too.
On May 25, 2012 3:49 AM, "Ken cthrogglazx" wrote:
Hi Ken,
On Thu, 24 May 2012 08:41:36 -0700 (PDT)
Ken Furff wrote:
> I am using the spreadsheet::xlsx module in a script im writing. I need to
> extract about 4 columns out of about 60. I need those specific columns for
> comparison and updating. I assume that I'll load the data into an array o
On Thu, May 24, 2012 at 10:15 AM, wrote:
> I am using Spreadsheet::xlsx in a script that im using to pull data from
> two separate columns in a spreadhseet and compare them. I only need a few
> of the columns.
> I have written a script that pulls the data from the spreadsheet and
> prints it to a
Good day,
I have a text file containing records. While I can extract single
sub-strings, I cannot extract multiple sub-strings.
The records are of multiple types - only about a third of which have the
data I need.
An example of a "good" record is
Abc1234 STATUS open DESCRIPTION "A basket o
hi all,
just wondering who here is going to yapc::na in madison WI? it is sold
out but some will show up without badges as we will likely have some
no-shows. this means you can come, enjoy the free hallway track and
possibly even get a badge at the door. if you are coming, add yourself
to various
May you try this matching?
while() {
next unless /^(\S+\s+)(\S+\s+)(\S+\s+).*\"(.*?)\"/;
print "$1 $2 $3 $4\n";
}
HTH.
Message Received: May 25 2012, 09:52 PM
From: "Christopher Gray"
To: beginners@perl.org
Cc:
Subject: Help required to ex
On Fri, May 25, 2012 at 18:48:48 -0400 , Uri Guttman wrote:
> [stuff about YAPC with a brief mention of the hallway track]
Free, organized HallwayTrack++, thank you very much. :) It's a lot more
involved and orchestrated this year than in prior years; please see
http://bit.ly/LpIIoO for more info,
Hi Chris,
On Fri, May 25, 2012 at 11:53 PM, wrote:
>
> May you try this matching?
>
> while() {
>next unless /^(\S+\s+)(\S+\s+)(\S+\s+).*\"(.*?)\"/;
>print "$1 $2 $3 $4\n";
> }
>
> HTH.
>
>
> Message Received: May 25 2012, 09:52 PM
> From: "Chri
12 matches
Mail list logo
