SPUG: Getting / Putting data to a MS Excell Spreadsheet

North, Walter wnorth at state.mt.us
Tue Apr 13 14:50:26 CDT 2004


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
----------------------------------------------------- 




More information about the spug-list mailing list