[Chicago-talk] Interfacing to Excel

[Don Drake]

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.

-Don

--
Don Drake
www.drakeconsulting.com
www.maillaunder.com
312-560-1574
800-733-2143



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
>> http://mail.pm.org/mailman/listinfo/chicago-talk
>>
>
> Elliot,
>
> 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
> http://mail.pm.org/mailman/listinfo/chicago-talk

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/chicago-talk/attachments/20090410/f05778b0/attachment.html>