[Webdev] [Perl question] Excel to other format using perl
Russell Matbouli
russell at futureless.org
Thu Jun 13 17:10:17 IST 2002
On Thu, Jun 13, 2002 at 01:47:03PM +0100, Aj McKee wrote:
> I am having a weird problem. I am trying to convert an Excel file to SQL. I
> was using Excel2Sql and it was working last week, but somehow now its not.
I don't know this script, so can't help much there. I'd suggest that you
have a look on the CPAN - putting 'Excel' in search.cpan.org turns up
quite a few things. The one I'd suggest is
Spreadsheet::ParseExcel::Simple (it should be easy enough to use). It
shouldn't be too hard to make it end up in your database using DBI or
Class::DBI. And the author supports his modules very well...
--
Russell Matbouli |
russell at futureless.org | I am Jack's raging bile duct
PGP KeyID: 0x3CA84CF4 |
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://mail.linux.ie/pipermail/webdev/attachments/20020613/99a0b07c/attachment.pgp
More information about the Webdev
mailing list