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