I've found Win32::OLE to be very flaky, mainly because it requires starting up an instance of Excel every time you need to read a spreadsheet. This is very expensive, and doesn't allow multiple users. And if something goes wrong, the instance of Excel stays open and you have to manually kill the process. You're much better off going with one of the CPAN modules.
On 1/23/06, Andrew Medico <[EMAIL PROTECTED]> wrote: > On Mon, 23 Jan 2006, Greg London wrote: > > > Some designers are using an xcell spreadsheet to generate > > some rather complex calculations. I was hoping to wrap > > it in something perl like so that I could set some of the > > inputs, calculate new results, and get new outputs and > > use the results in another environment. > > > > must work on activestate perl on a pc > > (I've always worked with linux perl, so I don't know if > > that makes a difference or not.) > > Win32::OLE will let you manipulate spreadsheets through Excel on Windows. > > http://www.opensourcetutorials.com/tutorials/Server-Side-Coding/Perl/writing-excel-files-perl/page1.html > > -- > Andrew Medico <[EMAIL PROTECTED]> > > _______________________________________________ > Boston-pm mailing list > [email protected] > http://mail.pm.org/mailman/listinfo/boston-pm > _______________________________________________ Boston-pm mailing list [email protected] http://mail.pm.org/mailman/listinfo/boston-pm
