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