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 sheet
-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 mail
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 above was
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
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 offering
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: 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 way of
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 dynamically
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
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, as it is
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-.
CODE
use strict;
use
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\AANCperl test.pl
Win32::OLE(0.1502) error 0x80070005: Access is denied in
PROPERTYPUT Visible at
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 topic,
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 can't
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 spell his own name?
Chuck Charbeneau
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 slice
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 the
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 latitudes
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
22 matches
Mail list logo
