scripting microsoft excel in perl?
sniper
them and want to learn!). I was wondering if there are any sites with
simple examples on how to script microsoft excel in perl? Thanks in
advance.
sniper
Geoff
news:qp2I7.7199$vM6.2...@typhoon1.gnilink.net...
Try searching for it at http://search.cpan.org/
Geoff
cpryce
tnt....@verizon.net wrote on 11/12/01 11:42 PM:
Since you are new, I'd point out that often times, some one has come before
you, and had similar ideas. When these ideas are good enough, they are
'modularized' (is that a word?) and place on the Comprehensive Perl Archive
Network (CPAN). Often, the answer to 'how do I do ...' is CPAN.
Try http://search.cpan.org/search?mode=module&query=Excel
--
cp
jimbo
> simple examples on how to script microsoft excel in perl? Thanks in
Please refer to the Win32::OLE documentation included with the
Win32::OLE module. Obtain it, install it, review it, script it.
jimbo
;-)
John McNamara
>Please forgive me, but I am brand new to linux and perl (but already love
>them and want to learn!). I was wondering if there are any sites with
>simple examples on how to script microsoft excel in perl?
You won't be able to script Excel on Linux, only on Windows:
http://www.activestate.com/ASPN/Reference/Products/ActivePerl-5.6/faq/Windows/ActivePerl-Winfaq12.html
http://www.activestate.com/ASPN/Reference/Products/ActivePerl-5.6/site/lib/Win32/OLE.html
John.
--
# Sum the numbers in the first column of a file
perl -lpe '$,+=$_}{$_=+$,' file
sniper
I'm a little unsure how to "obtain" modules and how to install them. Is
there a FAQ on how to get and install modules?
sniper
Tassilo v. Parseval
> I'm a little unsure how to "obtain" modules and how to install them. Is
> there a FAQ on how to get and install modules?
Well, there is 'perldoc -q install'. But that's not very much even
though this would do.
Learn to use the CPAN-shell to install modules:
ethan:~# perl -MCPAN -e shell
cpan shell -- CPAN exploration and modules installation (v1.59_54)
ReadLine support enabled
cpan>
And now you can enter commands at the prompt. Type 'help' first to get
an overview. 'i/PATTERN/' will scan CPAN for modules matching the
pattern. 'install Module::Name' will download, make and install a module
for you.
The first time you start the CPAN-shell it'll ask you a couple of
questions for configuration (such as your ftp-programm, where wget is,
make etc).
Tassilo
--
Kill Ugly Processor Architectures
- Karl Lehenbauer
Omri Schwarz
Start with the archives of tpj.com
--
Omri Schwarz --- ocs...@mit.edu ('h' before war)
Timeless wisdom of biomedical engineering: "Noise is principally
due to the presence of the patient." -- R.F. Farr
Bart Lateur
Not on Linux, I'd think. On Windows, provided you have Excel, you can
control it using Win32::OLE. There are some samples in the Win32 OLE FAQ
on
<http://aspn.activestate.com/ASPN/Reference/Products/ActivePerl/faq/Windows/ActivePerl-Winfaq12.html>
There are modules to read and write Excel files without Excel itself:
Spreadsheet::WriteExcel and Spreadsheet::ParseExcel (see CPAN,
<http://search.cpan.org/search?mode=module&query=Excel>).
Ooh and I found this FAQ on the web:
<http://homepage.tinet.ie/~jmcnamara/perl/PerlExcelFaq.html>. It looks
really great.
--
Bart.
Joe Smith
sniper <tnt....@verizon.net> wrote:
>I'm a little unsure how to "obtain" modules and how to install them. Is
>there a FAQ on how to get and install modules?
If you're using the ActiveState distribution of perl, just go to
Start -> Programs -> ActiveState Perl -> Documentation and look in
the ActivePerl FAQ for "Using PPM".
-Joe
--
See http://www.inwap.com/ for PDP-10 and "ReBoot" pages.