Making "sheets" in Excel from filePro?

[John Esak]

Hi Ken,

I know Mark can do wonders... but I think even he will tell you that Dan
Coutu's product for filePro  (also PERL based) called "xlmaker" already does
it all. It lest you put colors, fonts, wide columns, whatever into an Excel
spreadsheet from filePro... and he just sent me the latest update that does
multiple workbook sheets with labels... the whole ball of wax.

Dan's program is a really great add-on to filePro if you not only want to
dump out Excel spreadsheets, but *really* cool, great looking spreadsheets.

Dan's company is Snowy Owl Consulting and I think it is up in Vermont. I do
have his phone number here on the docs for anyone interested.

802-334-0251

John Esak



> -----Original Message-----
> From: filepro-list-bounces+john=valar.com at lists.celestial.com
> [mailto:filepro-list-bounces+john=valar.com at lists.celestial.com]On
> Behalf Of Ken Cole
> Sent: Sunday, March 25, 2007 9:28 PM
> To: Dan Coutu
> Cc: filePro Mailing List
> Subject: Re: Making "sheets" in Excel from filePro?
>
>
> I am one of the people for whom Mark wrote his Perl script that
> creates spreadsheets and we use it extensively in our web based apps.
>
> Users/customers run a web based report which displays on the screen
> and also has a link to load the data as an Excel spreadsheet.
>
> We also send weekly updates to customers, emailed, with the Excel
> spreadsheet attached.
>
> Works wonderfully.
>
> We are in consultation to potentially extend this to allow for multi
> workbooks with multi-worksheets but have not advanced past basic
> conceptual discussions at this point in time.
>
> Ken Cole
>
> On 3/25/07, Dan Coutu <coutu at snowy-owl.com> wrote:
> > Fairlight wrote:
> > > I've done Excel building from fP data for several people now.
>  We've always
> > > used the Spreadsheet::WriteExcel module for perl.  That has
> the capability
> > > to let you manipulate several worksheets in a workbook,
> although so far I
> > > haven't needed to.  We're talking about expanding one of the
> builders to do
> > > so, but the project was back-burnered for now as far as I'm aware.
> > >
> > > Given some sort of indication in a file as to where to start
> a new sheet,
> > > or just multiple files, a developer could make a workbook
> populated with
> > > data for each necessary sheet.  Not sure on the naming of the
> sheets as
> > > we never bothered, I don't think.  It's probably in
> there--the module was
> > > pretty robust.
> > >
> > >
> > I do the same thing with my xlmaker utility. The Spreadsheet::WriteExcel
> > module does support multiple worksheets and you can specify the title of
> > each one, I'm using that functionality within xlmaker. You do need to
> > specify both a set of general rules for things like column formatting
> > and colors along with row-specific data such as when to begin adding
> > data to a new sheet and where to specify 'freeze points' that freeze
> > specific rows and columns.
> >
> > Dan
> >
> >
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> >
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list