IMHO, you should really have an intermediate model (with column definitions, and a list of rows containing a list of cells) >From there you can pretty much load it into anything (including your Tapestry Grid). You're going to want this when you eventually need cell styles/formatting/borders/etc that are beyond what you need for the web interface.
I often bring up DynamicJasper as a means of XLS/PDF/CSV export, but that's just because I like it. You can also just use JasperReports (the api) or POI, but some of the details can be scary looking if you don't need all the options. DynamicJasper hide that complexity with sensible defaults for creating a decent looking report. There are two different XLS exporters available to use with DynamicJasper/JasperReports There may be more. On Mon, Mar 29, 2010 at 7:43 PM, Thiago H. de Paula Figueiredo <thiag...@gmail.com> wrote: > Hi! > > On Mon, 29 Mar 2010 16:55:18 -0300, faye alaska <haifeizh...@gmail.com> > wrote: > >> Does anyone here have experience of import and exporting to an .xls form >> the grid component in Tapestry5 or point me to a good example? > > The import part would need some library to do the file parsing. Apache has > one: http://poi.apache.org/spreadsheet/index.html. > The export part would need some part to generate a .xls you you could just > output a .csv. I guess POI could help you in this front too. > Grid can be used to shown anything as long as you pass the data as a List or > a GridDataSource. This component does no conversion itself. > > -- > Thiago H. de Paula Figueiredo > Independent Java, Apache Tapestry 5 and Hibernate consultant, developer, and > instructor > Owner, software architect and developer, Ars Machina Tecnologia da > Informação Ltda. > http://www.arsmachina.com.br > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tapestry.apache.org > For additional commands, e-mail: users-h...@tapestry.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tapestry.apache.org For additional commands, e-mail: users-h...@tapestry.apache.org
