[Techtalk] Perl module Spreadsheet::ParseExcel question

Caroline Johnston johnston at biochemistry.ucl.ac.uk
Wed Dec 7 12:21:35 EST 2005


Can't you create your own perl library somewhere you do have write access
and tell your scripts to use that? I had a quick google and this article
about mod_perl has a bit at the start explaining how to set up a local
library: http://www.perl.com/pub/a/2002/04/10/mod_perl.html Not sure if it
works the same way on windows though.

Is that any help?


On Wed, 7 Dec 2005 mgmonza at sdf.lonestar.org wrote:

> Hi,
> I thought I'd run this by y'all:  I'm fairly new to perl but liking it
> hugely.  For a number of reasons, I've been using SAS on Windows XP as a
> front-end to load Excel spreadsheets to an Oracle database stored on Unix.
> This really is relatively simple and was the best solution at the time.
> Now, however, I seem to have reached the limits of it's being a simple
> solution - multiple worksheets with names other than sheet1, sheet2, etc.
> I have been looking at perl's dbi to Oracle as a front-end, with possibly
> the CPAN module Spreadsheet::ParseExcel to read in the spreadsheets. Only
> problem is, I don't have administrator rights on the server, there's an
> enormous administrative hassle in even asking questions about the Unix
> environment due to centralized hubristic IT unit and
> Spreadsheet::writeExcel is installed, but not Spreadsheet::ParseExcel, no
> idea why.  Like the bear in Pogo, I can write, but not read Excel in this
> environment.
> Has anyone anyone used Spreadsheet::ParseExcel?  Can it be run from one's
> own usr-bin?  Does it need any other modules installed?
> Thanks very much -
> Kathleen
> _______________________________________________
> Techtalk mailing list
> Techtalk at linuxchix.org
> http://linuxchix.org/cgi-bin/mailman/listinfo/techtalk

More information about the Techtalk mailing list