« July 2005 | Main | October 2005 »

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 10:53 AM | Comments (0)