[Chicago-talk] Interfacing to Excel
don at drakeconsult.com
Fri Apr 10 20:42:33 PDT 2009
I can also vouch for Win32::OLE under ActiveState Perl. The
spreadsheets I was populating were quite large: 10 tabs, about 20 MB
file size and chock full of calculations programmed by Win32::OLE.
I did have some Excel issues once in a while, but all debugging showed
that problems inside Excel code.
On Apr 10, 2009, at 10:26 PM, Michael Potter wrote:
> On Fri, Apr 10, 2009 at 9:29 PM, Elliot Shank
> <chicago.pm at galumph.com> wrote:
>> Michael Potter wrote:
>>> Can any one point me to an article on the current state of accessing
>>> excel spreadsheets using Perl?
>> I've been using Win32::OLE, which includes basic examples to get
>> you going.
>> It works well. (This is on WinXP and Excel '07.) You'll need to
>> read the
>> Excel programmer's documentation as well.
>> Chicago-talk mailing list
>> Chicago-talk at pm.org
> Looks like Win32::OLE will handle the tricky part: the recalculation.
> Does anyone have an opinion on how well Win32::OLE is supported under
> active state's Perl distro?
> Michael Potter
> Chicago-talk mailing list
> Chicago-talk at pm.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Chicago-talk