Hey all, for XML-based formats (even zipped ones) Java code might be an overkill here. I've done OpenDocument Text to ePub transformation using only XSLT 2 and EXPath ZIP module. Text files be also be transformation results.
Martynas graphity.org On Mar 15, 2012 11:57 PM, "Alexander Dutton" <[email protected]> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi all, > > Random ideas follow; usefulness arguable ;-). > > On 15/03/12 22:13, Paolo Castagna wrote: > > Damian Steer wrote: > >> On 15/03/12 15:33, Paolo Castagna wrote: > >>> Sometimes, people want to load data into a spreadsheet, either > >>> Microsoft Excel or OpenOffice/LibreOffice Calc. […] > >> > >> I've done this fairly recently using Apache POI. They have a > >> streaming implementation which is fairly easy on memory. > > > > […] Is your code anywhere available and/or open source? > > Excel can be rather simple as you can just about output an HTML table > and stick an appropriate extension/media type on it. For example, we > stick resultsets through this renderer/template: > > > https://github.com/oucs/humfrey/blob/master/humfrey/results/views/spreadsheet.py > > > https://github.com/oucs/humfrey/blob/master/humfrey/results/templates/results/resultset.xls > > (I lose points for it not being in Java) > > In essence, if it's deemed a Good Idea (and I'm not saying it is), you > can get useful spreadsheet functionality with very little code and no > external dependency. > > If you wanted to do ODS and Office Open XML (XLSX) without an external > dependency, you could have a template Zip archive and drop an > appropriately-constructed XML file into it, but that'd be a fair bit > more effort… > > Yours, > > Alex > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.12 (GNU/Linux) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ > > iQEcBAEBAgAGBQJPYnOoAAoJEPotabD1ANF7YPoH/2J+tNN7btj97/JSWKlMvp2Y > sNsQAAY0MaYEbkR1bNJW7YYdbyVF+/XlgNHdVi+EqJLKtV6YX6tCDL7gFcOOVBLN > oyvREz6Fv/ZF2c2JkOBkZOQcm0BlESbvS98JgAL/SKZiK1wFv+RjE5MhRYr/i0f6 > d9n7W1qb0c4CJjQ0PL53ynxbhU+VS4gRe/ksuhwOfM5w4kr2EeEyDZiFX4tmbgDO > /qJ8yqsEh89deXMo4IKc81U2ppDKWZK8E7Teek54VR3T9qM75RGxdKDYTnfra1CM > vV4e8JIN736rBB6mRH4785Nk3pgZUs/usHgEndz0c0AuCL/pSQZgjEX82h/cX+I= > =YJ9+ > -----END PGP SIGNATURE----- >
