[seam-dev] Excel support

[Nicklas Karlsson]

Yep,

  As Daniel mention, there has been some brainstorming around the project...

  We were also thinking along the lines of the PDF support where there
are custom tags that
expose functionality of an underlying library and then the final
byte[] is hung in a DocumentStore etc.

I have good experiences with http://jexcelapi.sourceforge.net/ and it
is the most feature-complete and performant (more so than POI)
library that I'm aware of.

The basic usage could look like

<e:workbook value="#{personlist}" var="person">
	<e:column>
		<e:cell value="#{person.name}"/>
	</e:column>
</e:workbook>

Where we could go with library default values, working like a
dataTable (UIData? Daniel is the tag-person here ;-))

More complex, optional cases could then look like

<e:workbook
	protected="true"
	<e:workbookSettings
		arrayGrowSize="1000"
		autoFilterDisabled="true"
		cellValidationDisabled="true"
		characterSet="1"
		drawingsDisabled="true"
		encoding="utf-8"
		excelDisplayLanguage="fi"
		excelRegionalSettings="fi"
		formulaAdjust="true"
		GCDisabled="true"
		ignoreBlanks="false"
		intialFileSize="100000"
		locale="fi_fi"
		mergedCellChecking="false"
		namesDisabled="true"
		propertySets="false"
		rationalization="false"
		supressWarnings="true"
		temporaryFileDuringWriteDirectory="c:\\temp"
		useTemporaryFileDuringWrite="true"/>
	<e:sheetSettings
		paperSize="a4"
		orientation="landscape"
		sheetName="data"/>
	<e:column width="30">
		<f:facet name="header">
			<e:cell/>
		</f:facet>
		<e:cell
			value="#{person.age}"
			type="number"
			formatMask="#00"
			alignment="left"
			verticalAlignment="bottom"
			orientation="vertical"
			indentation="5"
			shrinkToFit="true"
			wrap="true"
			locked="true"
			comment="No comment">
			<e:background
				color="black"
				pattern="grey_25"/>
			<e:border
				type="bottom"
				lineStyle="dotted"
				color="brown"/>
			<e:cellFeatures>
			</e:cellFeatures>
			<e:font
				name="Times New Roman"
				pointSize="12"
				bold="true"
				italic="true"
				color="red"
				struckout="false"
				underlineStyle="single"
				scriptStyle="superscript"/>
		</e:cell>
	</e:column>
</e:workbook>

Exposing pretty much everyting JExcelAPI has to offer. Cell definition
would also be cascading so you can modify it on workbook-level
and then override some attributes for specific columns.

Feedback is welcome!

Nik