SPUG: Getting / Putting data to a MS Excell Spreadsheet

[Peter Darley]

Folks,
	I strongly second this.  Spreadsheet::WriteExcel is super easy to use,
supports a lot of different formatting and is fast.  I've attached a sample
file created using it.
Thanks,
Peter Darley

-----Original Message-----
From: spug-list-bounces at mail.pm.org
[mailto:spug-list-bounces at mail.pm.org]On Behalf Of Dan Ebert
Sent: Tuesday, April 13, 2004 1:06 PM
To: North, Walter
Cc: Spug (E-mail)
Subject: Re: SPUG: Getting / Putting data to a MS Excell Spreadsheet


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.

Dan.

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
_____________________________________________________________
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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: List-M-8022-P-1328.xls
Type: application/vnd.ms-excel
Size: 56320 bytes
Desc: not available
Url : http://mail.pm.org/pipermail/spug-list/attachments/20040413/be78cfea/List-M-8022-P-1328.xls