<p><b>pod</b> (<b>p</b>ython <b>o</b>pen <b>d</b>ocument) is a library that allows to easily generate documents whose content is dynamic. The principle is simple: you create an ODF (Open Document Format) text document (with LibreOffice Writer for example), you insert some Python code at some places inside it, and from any program written in Python, you can call pod with, as input, the OpenDocument file and a bunch of Python objects. pod generates another ODF text document (ODT) that contains the desired result. If you prefer to get the result in another format, pod can call LibreOffice in server mode to generate the result in PDF, DOC, RTF or TXT format.</p>
<br/><p>New with Appy 0.8.3: <b>support for spreasheet templates</b>. Appy now allows to generate, from an ODS (Open Document Spreadheet) template, spreadsheets in ODS (natively) or in Excel (by calling LibreOffice in server mode). A first example can be found in the bottom of this page.</p>
<p><br/>In this template, I wrote the Python expression <spanclass="code">commercial</span> in a conditional field. With LibreOffice, click on [Ctrl]-F2 to create a field. Choose field type 'conditional text', write <spanclass="code">true</span> as condition, write <spanclass="code">commercial</span> in the <spanclass="code">then</span> expression and write nothing in the <spanclass="code">else</span> expression. Another expression ("<spanclass="code">i</span>") in the next line has been defined similarly. 2 notes were also added. With LibreOffice, in the Insert menu, choose Note). Click <ahref="podWritingTemplates.html">here</a> if you want to learn more about creating pod templates.</p>
<p>First we need to import class <spanclass="code">Renderer</span>. Then we define some Python variables. We must then create an instance of the <spanclass="code">Renderer</span> (line 5), with, as parameters, the name of the pod template (we assume here that the pod template shown above is called SimpleTest.odt and lies in the current folder), a dictionary of named Python objects (here we simply take the global environment) and the name of the result file. The script will generate it, with, as content, what is shown in the image below.</p>
<p><br/>The second line of the template is repeated 3 times. It is the effect of the <spanclass="code">for</span> loop in the first note. Content of every field was replaced by the result of evaluating it as a Python expression, thanks to the context given to the <spanclass="code">Renderer</span> as second parameter of its constructor. Note that within a loop, a new name (the iterator variable, <spanclass="code">i</span> in this case) is added in the context and can be used within the document part that is impacted by the <spanclass="code">for</span> loop. The last line of the template was not rendered because the condition of the second note evaluated to <spanclass="code">False</span>.</p>
<p><br/>If you execute this code in a Python file located in the same folder as SimpleTestOds.ods, you will get a file named result.ods with the following content.</p>
<p><br/>Some remarks now. pod considers that any cell containing something of the form ="..." (= a formula whose result is a string and that is directly expressed as a string literal, surrounded by double quotes) will contain a Python expression, that will be executed according to the current context. pod <i>statements</i> (like the note containing <spanclass="code">do row for person in staff</span>), allowing to conditionaly or repeatedly include parts of the spreadsheet, are expressed in the same way as in ODT templates (check <ahref="podWritingTemplates.html">here</a> for more details).</p>
<p><br/>Within ODT templates, any Python expression is converted to string, because an ODT is only made of text. Within ODS templates, a Python expression that produces a Python <spanclass="code">int</span>, <spanclass="code">long</span> or <spanclass="code">float</span> will be rendered as a float value within the resulting spreadsheet. In the previous example, cells containing ages are float values.</p>
<p><br/>Within an ODS spreadsheet, every sheet is internally represented as a table. With statements like <spanclass="code">do table for...</span> you should be able to repeat a template sheet and produce several sheets in the resulting spreadsheet.</p>
