Making "sheets" in Excel from filePro?

Fairlight fairlite at fairlite.com
Fri Mar 23 03:31:51 PDT 2007


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->
-- 
Try our new SPF-0 lotion, SunScream[tm].  Get it while it's hot!


More information about the Filepro-list mailing list