[vox-tech] web access of openoffice documents

[Samuel N. Merritt]

--aVD9QWMuhilNxW9f
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Tue, Feb 10, 2004 at 04:22:11PM -0800, David Hummel wrote:
> On Tue, Feb 10, 2004 at 03:58:38PM -0800, Peter Jay Salzman wrote:
> >=20
> > i'm teaching a few classes and keep my scores/averages in gnumeric
> > spreadsheet (which i can convert to openoffice of course).  i want to
> > have some kind of site where my students can log in using their SSN
> > and perhaps a password and be able to look at how they're doing.
>=20
> Gnumeric files are gzipped XML documents (and Calc files are zipped ones
> I believe).  You could have a Perl CGI that decompresses the file,
> parses it with XML::Parser, locates the student-specific data, and
> presents it on the web page.

Good suggestion. I'd just like to add that XML::Simple is probably the
way to go here. I've used it in a couple quick projects before, and it's
far easier (IMHO) to work with than any other XML parser.=20

=46rom the perldoc:=20

use XML::Simple;
my $ref =3D XMLin([<xml file or string>] [, <options>]);

Presto, $ref is the root of a tree containing all the XML data in the
file.=20


--=20
Samuel Merritt
OpenPGP key: http://meat.andcheese.org/~spam/spam_at_andcheese_dot_org.asc
PGP information can be found at http://www.mindspring.com/~aegreene/pgp/

--aVD9QWMuhilNxW9f
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFAKXpWW3tuPJ1t7wURApPwAKCNOejyxK3ztZbekAdpzeSdua0pOQCghWYa
P6M11obrPxucdLD1LiV9k6E=
=q6pm
-----END PGP SIGNATURE-----

--aVD9QWMuhilNxW9f--