I used to do this quite a bit in ActiveState and perl on linux, OLE will let you do anything. However, a gotcha is that the perl OLE package is not very informative on everything you can actually do with OLE. I always had to go digging online for OLE commands, or sit with a VB window open so I could browse all of the data and methods that are in a MS spreadsheet. I am sure a good microsoft book would work well, but I was to lazy to try and find one. As others have mentioned, I belive the proper name for the package is Win32::OLE, but I always just said: use OLE;<br>
<br>I found Spreadsheet::WriteExcel and Spreadsheet::WriteExcel::Utility usefull for many taks too.<br><br>Eric<br><br><div class="gmail_quote">On Fri, Apr 10, 2009 at 6:31 PM, Michael Potter <span dir="ltr"><<a href="mailto:michael@potter.name">michael@potter.name</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Mongers,<br>
<br>
Can any one point me to an article on the current state of accessing<br>
excel spreadsheets using Perl?<br>
<br>
The problem I am trying to solve is that I want to a) write a value to<br>
a particular cell, b) allow the sheet to recalculate, c) read the<br>
resultant values, d) repeat 200 times.<br>
<br>
I want to do this in Perl rather than Excel macros because this is<br>
someone else's spreadsheet that I am reading for a conversion project.<br>
<br>
I am guessing that the recalculation part of my requirements would<br>
require me to use windows, that is okay, but I would rather use AIX,<br>
Linux, or Mac.<br>
<br>
All comments appreciated,<br>
<font color="#888888"><br>
--<br>
Michael Potter<br>
_______________________________________________<br>
Chicago-talk mailing list<br>
<a href="mailto:Chicago-talk@pm.org">Chicago-talk@pm.org</a><br>
<a href="http://mail.pm.org/mailman/listinfo/chicago-talk" target="_blank">http://mail.pm.org/mailman/listinfo/chicago-talk</a><br>
</font></blockquote></div><br><br clear="all"><br>-- <br>Eric Ellington<br><a href="mailto:e.ellington@gmail.com">e.ellington@gmail.com</a><br>