Making "sheets" in Excel from filePro?
Dan Coutu
coutu at snowy-owl.com
Sat Mar 24 12:43:17 PDT 2007
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
More information about the Filepro-list
mailing list