SPUG: SUMMARY: Getting / Putting Data to a MS Excel Spreadsheet

North, Walter wnorth at state.mt.us
Thu Apr 15 10:10:28 CDT 2004


Thanks to all who replied.

Fred Morris who suggested using ODBC
Dan Ebert who suggests Spreadsheet::WriteExcel and Spreadsheet::ParseExcel
from CPAN
Peter Darley who suggests the same
Jim Ludwig  ditto, and who generously offered to talk to me if I needed help
Bradley Young, ODBC, and I'm not knocking VBS, I just don't want to have to
	learn another scripting language if I don't have to.
Aaron Salo who suggests using a application/vnd.ms-excel HTTP header
	to publish the spreadsheet via the web.

Aaron also brings up a point that had been lurking in the back of my brain,
the chance
of users clobbering each other if they can update the DB via spreadsheet.

All in all I think I will scrap the idea of users updating via spreadsheet
and 
write a update interface after all.  I will still need to publish the DB in 
a spreadsheet, at least some of the data anyway.

So, I will look into ODBC and Spreadsheet::WriteExcel and the http header
looks
like something that would be useful as well.

If I missed anybody, I appologize, sometimes my delete finger works all by
itself
while the brain is not paying attention.

Thanks again for the assistance!

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