I haven't done it myself, but the Win32::Ole documentation
looks quite simple (simple of course, if you know the Excel
The MSDN has some documentation on the Excel object
model, as has the Office Development Kit, something you
might want to buy if you do Office development on a regular
Some code from the top of my head - I haven't done
Excel automation for a looong time ... Note that you can
take the method and object names from any VB code, as both
Perl and VB call through the IDispatch methods of Excel.
$ex = Win32::OLE->new('Excel.Application') or die "oops\n";
$ex->Worksheets(0)->Cells(0,0) = "Hello world";
I'm not sure about the parameters you have to pass to the
Cells function - some VB sample code should be
easy to port though.
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
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! —
Posts may use any of the Perl Monks Approved HTML tags:
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, 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, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.
| & || & |
| < || < |
| > || > |
| [ || [ |
| ] || ] ||