SPUG: Getting / Putting data to a MS Excell Spreadsheet

Dan Ebert mathin at mathin.com
Tue Apr 13 15:05:31 CDT 2004

I use the Spreadsheet::WriteExcel CPAN module to create Excel sheets. 
Its perldoc recommends Spreadsheet::ParseExcel for reading them, but I
haven't used it myself.


On Tue, 2004-04-13 at 12:50, North, Walter wrote:
> Hi all,
> 	I know I've seen this somewhere, perhaps some kind soul
> 	can point me in the right direction.
> I would like to create/update and get data from a spreadsheet, 
> in particular MS Excel.  The data resides in a mysql database
> and in particular I would like to create a spreadsheet from
> it.  And allow users, in particular management, to update the
> database via the spreadsheet as I don't really have time to 
> set up a spreadsheet looking web interface at this time.
> I really don't want to have to learn VBS or whatever and would
> prefer to use perl or php.  I can do the db stuff but getting the
> data in and out of the spreadsheet via script has left me scratching 
> my head.
> thanks much in advance
> ----------------------------------------------------- 
> Walter North 406-444-2914 
> Operating Systems Programmer 
> wnorth (at) state (dot) mt (dot) us
> I haven't been ignoring you; I've been prioritizing you.
> 		-- Scott Adams
> ----------------------------------------------------- 
> _____________________________________________________________
> Seattle Perl Users Group Mailing List  
> POST TO: spug-list at mail.pm.org  http://spugwiki.perlocity.org
> ACCOUNT CONFIG: http://mail.pm.org/mailman/listinfo/spug-list
> MEETINGS: 3rd Tuesdays, Location Unknown
> WEB PAGE: http://www.seattleperl.org

More information about the spug-list mailing list