You really aren't going to find these methods specifically. The WriteExcel module is an abtraction created to write XLS binary files directly, not an interface into the OLE object itself (cf. IDISPATCH interface for COM objects), which is what you are now dealing with.

Because of this, It would probably behoove you to figure out the tasks that are involved from an excel stand point.

• Create Header Columns
• Insert Data into Proper Columns
• Create Formulas based locations of certain data points
• Format Foregrounds, Backgrounds, Fonts, line styles, etc
• Insert Charting objects

etc, etc...

You need to enter data into the proper columns in your header rows. Well, excel really doesn't pay attention to header rows, per se, but you can track what row you are on and what column you are in, and apply certain formatting to cells, rows, columns and other range objects.

Formatting requires a little knowledge of the object model, and I urge you to re-read my tutorial, as I speak directly to changing backgrounds, font styles, etc. and you should be able to use that info and other tools (one mentioned below) to extrapolate others.

As for formulas, you are looking to either set the Value property:

$Excel->Range($mycell)->{Value} = "=your formula here"
[download]

or the Formula property

$Excel->Range($mycell)->{Formula} = "=your formula here"
[download]

Which give you the same result.

At the top of the tutorial, I suggest the object browser that comes packaged with the AS port of Perl. I'm assuming Jan put a lot of work into it, and I think it should be used. One can usually find it here:

<PERLROOT>\html\site\lib\Win32\OLE\Browswer\Browser.html

I hope this points you in the right direction. Please follow-up if you have any method or object specific questions, or need more help in general.

C-.

---
Flex the Geek