MySQL Forums
Forum List  »  Perl

Re: MySQL and MS Excel
Posted by: Steve Evans
Date: June 13, 2008 09:19AM

Here's how to do connect to Excel in Perl:

use Win32::OLE qw(in with);
use Win32::OLE::Const 'Microsoft Excel';

VIA the Win32::OLE module:
http://search.cpan.org/~jdb/Win32-OLE-0.1709/lib/Win32/OLE.pm

Alternately, you can install ODBC drivers and access them through Excel, but I've never done this.

Options: ReplyQuote


Subject
Written By
Posted
June 06, 2005 09:30AM
May 19, 2008 08:43AM
Re: MySQL and MS Excel
June 13, 2008 09:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.