From: dhtapp <dhtapp@...>
Date: 2003-11-17T10:20:57+09:00
Subject: Scrounging for WIN32OLE <--> MS-Excel Examples

Hi,

I've suddenly developed an interest in populating an Excel worksheet from
within a little simulation I'm running.

I've Googled for docs & examples on using the WIN32OLE class, and been able
to cobble together some basic functionality with the help of what I've found
(plus Dave & Andy's book), but I haven't been able to branch out much.

I've also tried recording a couple of basic Excel macros and examining the
output.  Unfortunately, the number of hours I've spent in VB can be counted
on a dog's left paw, and I'm not having much luck translating the syntax
into stuff that WIN32OLE recognizes.

And, I've perused Microsoft's tech site.  For instance, they list multiple
ways that Excel ranges can be accessed, including a simple 2d index (i, j),
which would be perfect.  But so far, I can only get the standard
"A1:A5"-style notation to work.

Does anyone know of some docs or guidelines posted somewhere that I may have
missed?

Thanks,

- dan

PS I know there's a specialized Excel library to write worksheets directly,
but that appears to be semi-broken under 1.8, and I'm not nearly experienced
enough to know how to patch it yet.