[seam-dev] Excel support

[Pete Muir]

Sounds good.

You might want to investigate using the RF CDK to quickly build the  
necessary descriptors and getter code - the mail/pdf isn't build like  
this just because it predates the use of the CDK.

On 16 Apr 2008, at 11:38, Nicklas Karlsson wrote:
> 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
> _______________________________________________
> seam-dev mailing list
> seam-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/seam-dev

--
Pete Muir
http://www.seamframework.org
http://in.relation.to/Bloggers/Pete