« DBUnit, HSQL and the BOOLEAN data type | Main | Macromedia Flash Remoting Update »

September 12, 2005

SsTemplates Spreadsheet Templates for Excel

I am writing to announce the public release of SsTemplates, our solution for creating Excel documents in Java.

SsTemplates builds upon the Jakarta POI/HSSF libraries for writing Microsoft Office documents by providing a simple XML templating language for creating Excel documents similar to creating HTML pages with JSP and CSS.

An example from the documentation:

<workbook xmlns="http://carbonfive.com/schema/sstemplates">
  <style name="label" fontWeight="bold"/>
  <style name="money" dataFormat="$0.00"/>

  <sheet name="Formula Spreadsheet">
    <row>
      <cell style="label">January</cell>
      <cell style="money" type="numeric">1.99</cell>
    </row>
    <row>
      <cell style="label">February</cell>
      <cell style="money" type="numeric">2.09</cell>
    </row>
    <row>
      <cell style="label">March</cell>
      <cell style="money" type="numeric">3</cell>
    </row>
    <row>
      <cell style="label">Total</cell>
      <cell style="money" type="formula">sum(B1:B3)</cell>
    </row>
  </sheet>
</workbook>

Formula Example

Posted by Alon Salant at September 12, 2005 10:53 AM

Comments

Post a comment




Remember Me?