> From: Beckett Richard-qswi266 [mailto:[EMAIL PROTECTED]
> Subject: Win32:OLE Excel last row question.
> This line successfully gives me the last used row in a populated
> spreadsheet:
>
> my $LastRow = $sheet->UsedRange->Find({What=>"*",
> SearchDirection=>xlPrevious, SearchOrder=>xlByRows})-
> From: Gianvittorio Negri [mailto:[EMAIL PROTECTED]
> Subject: List excel sheets
> I'm trying to list all the sheet contained in a single excel
> file, in order build a script for
> split a single excel multi-sheet in more single sheet excel
> files using sheet name as file name.
> The she
> -Original Message-
> From: Richard DeWath [mailto:[EMAIL PROTECTED]
> Subject: Reading Mail from Exchange Folder
> I am just learning about this and need some pointers
> on how I can write a Perl script that lets me read my
> new mail on an Exchange server [assume the Inbox],
> find ma
> From: Michael D. Smith [mailto:[EMAIL PROTECTED]
> Subject: Re: OLE again
>
> In these examples from recent mailings to the list
> my $IE = Win32::OLE->GetActiveObject( 'WebBrowser.Application' );
> my $Excel = Win32::OLE->GetActiveObject('Excel.Application')
> The point in these example ab
> From: [EMAIL PROTECTED]
> Subject: moving Excel Sheets via OLE
I'm in a bit of a hurry right now, or I'd type out the code, but:
http://perlmonks.org/index.pl?node_id=153486
Bottom of my tutorial, Add and Move work the same.
YMMV, some restrictions may apply.
Chuck Charbeneau
Lear Corporat
> From: Beckett Richard-qswi266 [mailto:[EMAIL PROTECTED]
> Subject: Win32-OLE excel cell reference.
> It seems that the Range command likes data like (A14), or
> (A14:B26), and I am happy with this.
>
> My problem occurrs when I only have numeric data to work
> with, because of incremented
> From: Ross Matt-QMR000 [mailto:[EMAIL PROTECTED]
> Subject: RE: Win32-OLE excel cell reference.
> by no means did mean anything negative about what you
> wrote in reply. You have ALWAYS been very helpful to me and
> others with your posts.
No worries. I didn't take any offense, just offe
> From: Subrahmanyam Vadlamani [mailto:[EMAIL PROTECTED]
> Subject: How to recurse through a directory and do something
> with each file
> I would like to recurse through a directory and do
> something with the files in the directory (and all sub-directories).
>
> What is the most efficient w
> From: steve silvers [mailto:[EMAIL PROTECTED]
> Subject: Re: dynamic reports
> Crystal Reports..
> >"Does anyone have a idea as to the best way to do this?
> >Perl ?
> >XML ?
> >C and postgres ?
All of the above an accomplish what you are looking for.
Crystal offers you controls that dynam
Forgot to send this to everyone:
Or he could go to:
http://search.cpan.org
click on the link which reads:
"Why is this site Orange?"
and leads here:
http://search.cpan.org/orange.html
And read how he can get it back.
C-.
**
** LEGAL DISCLAIMER **
**
> From: Bautista, Rodel D.(Digitel-GSM)
> Subject: FW: Using Outlook in Win32::OLE
> I'm entirely at a loss here. I'm in dire need of help with my
> problem below. I've tried searching for a perl script that
> automatically connect/log me to an outlook application and
> send a mail with an at
> From: Christopher Moss [mailto:[EMAIL PROTECTED]
> Subject: RE: Outlook 2000/XP
> Thanks for the suggestion Chuck I did manager to get there
> with Mime-Lite, once I'd managed to work how it talked to the
> SMTP server! The main issue being the send->("smtp",
> [Hostname])line which slightl
> From: Christopher Moss [mailto:[EMAIL PROTECTED]
> Subject: Outlook 2000/XP
> I'm trying to test sending emails from Perl using OLE on MS Outlook
> (2000 or XP). I have written the following simple script (mainly based
> on previous postings):
Seems like a lot of overhead to send an email.
> From: Rivera, Oscar [mailto:[EMAIL PROTECTED]]
> Subject: Excel question
>
>
> Hello,
> I want to copy a range of cells (A2-F300) from a "export.csv"
> file and append it to "myfile.xls" and save the file. can
> some one help?
a CSV file really doesn't contain the row, column information,
> From: Ian Robertson [mailto:[EMAIL PROTECTED]]
> Subject: Making a line graph
> I need to write a script to produce a line graph
> (quick and dirty to prove a point)!
>Can anybody recommend the best module to use?
The Chart module offers a quick interface.
C-.
use strict;
use Chart::Li
> From: Daniel Needles [mailto:daniel.needles@;Callisma.com]
> Subject: Excel, OLE, and Activate PERL 5.6.1 rel 633 on Windows 2K.
> The following program:
[SNIP]
>
> C:\Documents and Settings\dln1\AANC>perl test.pl
>
> Win32::OLE(0.1502) error 0x80070005: "Access is denied" in
> PROPERTYPUT
> From: Beckett Richard-qswi266 [mailto:[EMAIL PROTECTED]]
> Subject: RE: manipulating Excel
> I have two (silly) questions, already...
Nothing is silly if in the pursuit of knowledge.
> I have an excel file in the directory that the script is
> running from, called results.xls, however I ca
> From: Jacobson, Karl [mailto:[EMAIL PROTECTED]]
> Subject: manipulating Excel
>
>
> I would like to change formats and the like in Excel. Is
> that possible
> (within my Perl scripts of course) and where would I find
> information on this?
I wrote a tutorial on Perlmonks on just this to
> From: Bellenger, Bruno (Paris) [mailto:[EMAIL PROTECTED]]
> Subject: RE: Displaying time in PERL
> Shortest one so far. And not even bad on the obfuscation criteria.
> Well done.
> > printf ("%02d:%02d:%02d",(localtime(time))[2,1,0]);
I can't take credit for it, I saw someone else use a sl
> From: Charbeneau, Chuck [mailto:[EMAIL PROTECTED]]
> Subject: RE: Displaying time in PERL
>
>
> printf ("%02d:%02d:%02d",(localtime(time))[2,1,0]);
>
> Chuch Charbeneau
^
|
But how can you trust the code from a man who can't s
printf ("%02d:%02d:%02d",(localtime(time))[2,1,0]);
Chuch Charbeneau
___
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
> From: parvez [mailto:[EMAIL PROTECTED]]
> Subject: Newton Raphson's or Bisection Interpolation in perl
> Does anybody know of a module that helps in interpolation using
> Newton Raphson's method or Bisection method in Perl.
Wolf book, Chapter 16, pgs. 638 - 640.
You can probably get the
-Original Message-
From: Arul, Rex [mailto:[EMAIL PROTECTED]]
Subject: Problem Converting a Timestamp in Excel
> Hello Friends,
> In the Excel spreadsheet, I am trying to cull out data, there
> is a column with values of this format: 22:15 (10:15:00 PM)
> However, while trying to get t
This time, I'll post it to the list:
> From: Lee Goddard [mailto:[EMAIL PROTECTED]]
> Subject: Re: Distance between 2 latitudes and longitudes
> At 10:14 06/03/2002 -0600, MOTTER, JEFFREY D. wrote:
> >Does any know where I can find a script to calculate the
> distance between 2
> >seperate lati
> From: lonh SENG [mailto:[EMAIL PROTECTED]]
> Subject: disk quota
> Can you help me?
Yes, we can.
> I want to write a script to create disk quota for all home
> directories of all users. Their sizes are the same.
As a matter of fact, I wrote exactly that for the ME department at Michigan
> From: Christopher Hahn [mailto:[EMAIL PROTECTED]]
> Subject: RE: Editing word documents
> I wanted to ask again whether anyone had found a useful
> *book* that deals with OLE from perl. MS's MSDN site seems
> designed so as to spread the info out to such an extent that
> I do not see the big p
Typo - Should have been: "WIN32 Perl Scripting: The Administrator's
Handbook".
Sorry.
Chuck.
___
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users
> From: Wells, Doug [mailto:[EMAIL PROTECTED]]
> Subject: OLE Resource
> What are some good books/resources for learning more about
> Perl/OLE scripting?
Also, Dave Roth's books have been an INCREDIBLE resource for me. Look for
"WIN32 Perl Programming: The Standard Extensions" and "WIN32 Scr
> From: Ralf Lister [mailto:[EMAIL PROTECTED]]
> can someone point me to a free Perl-Editor?
In a message from 3 days ago, I responded to this VERY question with the
following:
Straight from the http://mailarchive.activestate.com/ to you:
This has been hashed out so many times, someone actual
29 matches
Mail list logo
