Hello fellow programmers
I would like to write some code for my local soccer association to
covert their Lovely Excel schedules into something readable on the web.
The Problem is, I do not know of any USA web space providers that have
Perl. truth be told I don't know of any company names. I guess
Chaddai,
Thanks for responding. I was able to get the data using the WMA:Tag Module
very easily. So updating your Module any be a redundant effort.
Thanks again
Matt Ross
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Reinhard Pagitsch
Sent: Monday, Aug
The Audio::WMA did the trick thanks
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Chaddai
Sent: Saturday, August 20, 2005 3:40 AM
To: Perl-Win32-Users@listserv.ActiveState.com
Subject: Re: File property values
Matt Ross a écrit :
> OK I downloaded the
Dave,
I attack this a little differently, I allow the excel to create sheet1
sheet2 and sheet3. which I believe are created by default. First create all
the sheets that you need by looping around
$Sheet = $Book->Worksheets->Add;
$Sheet->{Name} = "$NEW_NAME";
Then delete all th
Title: Message
-Original
Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Ronald EstesSent: Tuesday, May 18, 2004 5:24 PMTo:
perl-win32-usersSubject: Editor
Do you know any good Perl Editor software?
Vim
___
Nathaniel,
I also use the OLE and I think you showed me how to freeze panes long ago.
Anyways, the problem that I ran into using that command was: If the pane has
already been frozen when you execute the same command, you get fatal error.
So, do you know of a way to wrap a test around the freeze?
Chuck,
That worked for me but when processing a large excel workbook the
Cell call seems to be slower than Converting the number into letter and then
use a pure range. I had a 2X reduction in time processing 20,000 rows by 25
columns. However on the smaller size sheets there was no notica
Sorry forgot to change the label
> I am tring to align the test in the cell but it no workie and it is
> driving me nuts
>
> $RangeValue = "J1";
> $Alignment = "xlCenter";
>
> $Working_Alignment = $Book->Worksheets($SHEET_NAME);
> $Work
I am tring to align the test in the cell but it no workie and it is
driving me nuts
$RangeValue = "J1";
$Alignment = "xlCenter";
$Working_Alignment = $Book->Worksheets($SHEET_NAME);
$Working_Alignment
->Range("$RangeValue")->{HorizontalA
sort the rows so that all the empty rows are at the end and the last row
command would do the trick.
just a thought
Later,
Matt
-Original Message-
From: Beckett Richard-qswi266 [mailto:[EMAIL PROTECTED]
Sent: Friday, July 11, 2003 5:53 AM
To: perl-win32-users
Subject: RE: Excel and empty
Same as Scot but instead of Chomp
$_ =~ s/\n//g;
that way if you would not chomp a character that you want to keep.
Later,
Matt
-Original Message-
From: Scot Robnett [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 10:52 PM
To: Daniel Gross; [EMAIL PROTECTED]
Subject: RE: Removing a
A cheesy way to remove the file on the Unix system inside of your FTP.
Step 01 Change the windows directory to a different location where the
filenames that you just pulled down do not live.
Step 02 Cycle though all the filename that are on the Unix side issuing the
put command this will over wr
that just looks for the lower case. is there something that tells oracle to
be case insensitive? "lc" stands for lower case and "uc" is for upper case
... right I am really new to the SQL side so I would understand if I am
totally wrong
Matt
-Original Message-
From: Oleksandr Pavlyk [ma
Alistair,
What you say makes sense to me but, I have been doing a similar thing. The
difference is I would read in a hash table %Original_Hash and then rename (
Richard's way ) to say %Alpha, then I would read in another with the same
name %Original_Hash and rename that one to %Gamma. Here is the
-Original Message-
From: Beckett Richard-qswi266 [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 10:38 AM
To: [EMAIL PROTECTED]; Perl-Win32-Users
Subject: RE: Hashes and arrays.
Hello World, again!
I've got my hashes of hashes of hashes of... working well, now, thanks to
all
add one more element in hash say insertion_order -> "$cnt";
every time you insert to the hash increment the counter.
$cnt++;
-Original Message-
From: Peter Eisengrein [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 12:42 PM
To: 'James S. Martin'; [EMAIL PROTECTED]
Subject: RE: h
I do that allot but it is frustrating converting the strings to work inside
of perl. Once you crack the code put it into a helpful hint file for
yourself like what Richard Beckett did for Excel.
-Original Message-
From: Carl Jolley [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003
Richard,
try putting an if statem to test for digits.
if ( $ping_number =~ /^\d+$/ ) {
for ($loop = 1; $loop <= $ping_number; $loop++) {
print "$loop\n";
}
}
else
{
print "$ping_number not numeric";
}
Later,
Matt
-Original Message-
From: Beckett Richard-qswi266 [mai
To anyone that can help.
I have written a perl script to open and check the values inside of excel
worksheets and do some other stuff to it. All works well, It is just, I get
the warning pop up asking " are you sure you want to save?". it's not to bad
when you run two or three excel sheets but wh
19 matches
Mail list logo