Re: [sprog-users] Gear Repository

[Tony B. <ton...@gm...>]

On 24/06/05, Marc Slagle <mar...@on...> wrote:
> I have written an Excel to CSV gear, but wanted to see if there was anoth=
er=20
> one floating around somewhere before trying to refine the one I'm working=
 on.

You might want to extend this to allow users to specify which
worksheet they wish to use. If I'm reading the code right it's
hardwired to use the first sheet? (Would also be useful to document
this).

I'm also wondering whether mapping this to CSV is the best approach.
It's obviously workable, as Sprog already has the ability to handle
CSV files, and users can therefore translate into whatever they want,
but I suspect that more often than not the next step will be to
translate back out of CSV. So perhaps it might be better to just have
it output a list of lists and have the ability to translate that into
whatever is required (including CSV). Thoughts?

Anyway nice work!

Tony

PS I'm curious as to why you didn't use
Spreadsheet::ParseExcel::Simple for this - would simplify that code a
lot ... :)