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

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.