On Thu, 2001-11-29 at 23:37, Tom Servo wrote:
There's probably a far better answer to this than I can give, but if not,
an interim solution might be having whoever maintains these Excel files
save them as .csv files. Excel can do that, and while you lose all the
fancy formatting, it just
El Jue 29 Nov 2001 19:31, Ian escribió:
Mensaje firmado por ID de clave desconocido 962F87CA
In the wide and wonderful world of Microsoft and Linux, I'm in the
need of an interesting soloution.
I'm presenting this to the list because I've ran out of good ideas.
I recommend making a mod_perl
There's probably a far better answer to this than I can give, but if not,
an interim solution might be having whoever maintains these Excel files
save them as .csv files. Excel can do that, and while you lose all the
fancy formatting, it just dumps them in a comma seperated list, then you
can
Ian,
I have never used it, but I have heard that Spreadsheet::ParseExcel is
good at getting Excel file into a Perl script. If you every need to
go the other way (Perl-Excel) i have used (and highly recommend)
Spreadsheet::WriteExcel. Both of these can be found on CPAN.
Ian wrote:
The campus
On Thu, 29 Nov 2001, Tom Servo wrote:
Hopefully someone else knows of a CPAN module to work with Excel files,
though...
Spreadsheet::ParseExcel and Spreadsheet::WriteExcel? Both have ::Simple
versions too.
I've used them in the past and it's Worked For Me (tm)
Later.
Mark.
--
s'' Mark
If you couldn't convince the bosses to db this, you could use .cvs (tab
delimited) instead of .xls, ftp it to your webserver every (cron) and have
perl parse it out. People love their xls and access files don't they:)
How about dumping the data into MS-SQL and have your db write the .xls file
fyi - this is off topic since it does not have anything to do with
mod_perl in particular. you should really ask on:
news://comp.lang.perl.modules
or one of the other newsgroups:
news://comp.lang.perl.moderated
news://comp.lang.perl.misc
or on this helpful website:
http://www.perlmonks.org/
Tom Servo [EMAIL PROTECTED] wrote:
On Thu, 29 Nov 2001, Ian wrote:
The campus phone system has a 911 database that is in Microsoft Excel
format, and they want to be able to take that information, and show
it on a webpage, either via a search form, or in one big table. The
problem is,
On Thursday 29 November 2001 23:31, Ian wrote:
In the wide and wonderful world of Microsoft and Linux, I'm in the
need of an interesting soloution.
The campus phone system has a 911 database that is in Microsoft Excel
format, and they want to be able to take that information, and show
it on
Two suggestions:
One: drop the excel idea right now or you'll find out its not the right
solution at a later time. Use LDAP instead. Then right a CGI (as you
really don't need Mod-Perl) for all kinds of queries and an admin view
for a maintainer to maintain it.
Two: ask your spreadsheet
10 matches
Mail list logo