Making "sheets" in Excel from filePro?

Dick Burke rjburke at hal-pc.org
Fri Mar 23 06:27:49 PDT 2007


On Fri, 23 Mar 2007 06:31:51 -0400, Fairlight wrote:

>Technically, for a while Excel files have been called Workbooks.  Within
>them, those tabs are Worksheets.  That's what you're referring too.

>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.

>It's more a matter of agreeing on a communication model between fP and the
>external program making the workbooks than any technical difficulty in
>actually making them.  Once you iron out the details of what's being sent
>in what format and what the program should expect and how, it's not too bad
>at all.  The devil's just in those details.

>mark->

I interpreted that as "I have no idea"

Dick Burke




More information about the Filepro-list mailing list