Click here to get back home

OLE Automation using Perl on a Unix box?
 Home | NewsGroups | Search | About
Login Password
Register Now!
 comp.lang.perl.modules    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
OLE Automation using Perl on a Unix box? Steve 04-18-2006
Posted by Steve on April 18, 2006, 7:27 pm
Please log in for more thread options

I need to set up an automation process on a Unix machine (no windows
machine can be used). This automation needs to do various
manipulations in MS Excel files... for example, insert/delete records,
copy/paste cells etc.

On windows, I would use Win32::OLE. Is there an equivalent library
that works for Perl running on Unix?

Thanks,
Steve


Posted by Jim Gibson on April 18, 2006, 7:58 pm
Please log in for more thread options


> I need to set up an automation process on a Unix machine (no windows
> machine can be used). This automation needs to do various
> manipulations in MS Excel files... for example, insert/delete records,
> copy/paste cells etc.
>
> On windows, I would use Win32::OLE. Is there an equivalent library
> that works for Perl running on Unix?

I use Spreadsheet::ParseExcel and Spreadsheet::WriteExcel to read and
write Excel spreadsheet files. Be warned: reading is slow. The entire
spreadsheet is read into memory. I have not tried these modules on very
complicated documents (like those with formulas, plots, etc.).

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

Posted by Sisyphus on April 18, 2006, 8:06 pm
Please log in for more thread options



> I need to set up an automation process on a Unix machine (no windows
> machine can be used). This automation needs to do various
> manipulations in MS Excel files... for example, insert/delete records,
> copy/paste cells etc.
>
> On windows, I would use Win32::OLE. Is there an equivalent library
> that works for Perl running on Unix?
>

There are a number of modules for parsing/writing Excel files. See
http://search.cpan.org/search?query=Excel&mode=dist . I don't know whether
any of them will give you the same degree of control that's offered by
Win32::OLE.

Cheers,
Rob



Posted by Donald King on April 19, 2006, 9:24 am
Please log in for more thread options


Steve wrote:
> I need to set up an automation process on a Unix machine (no windows
> machine can be used). This automation needs to do various
> manipulations in MS Excel files... for example, insert/delete records,
> copy/paste cells etc.
>
> On windows, I would use Win32::OLE. Is there an equivalent library
> that works for Perl running on Unix?
>
> Thanks,
> Steve
>

Something to consider beyond the other suggestions already made is, if
you already have a license for Excel, running Excel plus a Win32 build
of Perl under Wine. It's likely to be more trouble than it's worth, but
if all else fails, it might be an option of last resort.

--
Donald King, a.k.a. Chronos Tachyon
http://chronos-tachyon.net/

Similar ThreadsPosted
Need help with a simple UNIX sockets server based on IO::Socket::UNIX April 14, 2005, 3:02 am
unix perl module install errors November 11, 2004, 3:36 pm
Required Perl Developer w/ UNIX. SQL and Shell Scripting. March 24, 2006, 6:41 pm
Automation using setupsup April 3, 2007, 10:23 pm
creating perl binary using PAR module , execution error under unix March 15, 2008, 7:06 am
form submission automation August 13, 2006, 9:15 pm
DBD:Excel on unix machine March 9, 2006, 11:18 am
Passing a DBI connection between [Unix] processes January 7, 2005, 1:01 pm
Windows Registry manipulation using Unix April 29, 2005, 11:46 am
uncompressing unix Z files on Win32 November 16, 2005, 8:29 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap