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