Text files can also be produced with XSLT btw. On Mar 16, 2012 12:44 AM, "Martynas Jusevicius" <[email protected]> wrote:
> 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 > with EXPath ZIP module. > > 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----- >> >
