Making "sheets" in Excel from filePro?
Ken Cole
ken.m.cole at gmail.com
Sun Mar 25 18:27:39 PDT 2007
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
>
More information about the Filepro-list
mailing list