[Techtalk] Perl module Spreadsheet::ParseExcel question
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:
> 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
> 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 -
> Techtalk mailing list
> Techtalk at linuxchix.org
More information about the Techtalk