How can I let my CGI do a text search of an Excel spreadsheet?

linex has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: How can I let my CGI do a text search of an Excel spreadsheet? by arthas (Hermit) on Apr 04, 2004 at 17:17 UTC
Hi! You can use the DBD::Excel module, which allows you to access to an Excel file via DBI. This will allow you to perform searches with no problems. The module is still in alpha, so I'm unsure how well it works. As an alternative there are several modules on CPAN which can be used to read an Excel file and/or convert into into another format. Michele.	[reply]
Re: How can I let my CGI do a text search of an Excel spreadsheet? by matija (Priest) on Apr 04, 2004 at 17:18 UTC
Well you could use Bundle::DBD::CSV or DBD::Sprite emulate SQL queries over flat files. DBD::RAM is probably faster, because it does it in memory. The former are probably too slow if you have more than a few dozen records. DBD::Trini looks great, but is in early stages of it's implementation. Personaly, I would look at DBD::DBM \|\| DBD::MLDBM as your best bet. I would also consider changing hosters. Cheap hosting that provides mysql is pretty easy to get. Update:(Thanks to dragonchild) DBD::Trini, not `DBD::Trinni`.	[reply]
A reply falls below the community's threshold of quality. You may see it by logging in.
Re: How can I let my CGI do a text search of an Excel spreadsheet? by diotalevi (Canon) on Apr 04, 2004 at 17:04 UTC
Sure. Export your excel file to a text file.	[reply]
A reply falls below the community's threshold of quality. You may see it by logging in.


Come for the quick hacks, stay for the epiphanies.
	PerlMonks