Thursday June 5th will be our regular
BLUG meeting at BTC, in room D5, from 7pm til 9pm.
Mark Ashworth has volunteered to present on:
Title: Exporting data as Open Office spreadsheets using Java and Python.
Mark’s Description:
“Design a template doc in Open Office and save it as odt (word processor) or ods (spreadsheet). The result is a zip file that contains content.xml along with a bunch of formatting files, definitions, images etc. You can create new documents on the fly by extracting the contents of the zip file, modifying just content.xml and writing it all back to a new file or output stream.
I’ll show examples in both Java and Python that query a database and insert content to create a new OO spreadsheet or document and compare some of the code side by side. The Java example delivers from a web server and the Python example is a command line utility but the methods are very similar once you get past the difference in language syntax.
One of my motivations for this was to learn some Python so be prepared to look at some code.”
We’ll also have our regular Q&A and Linux in the news time.