-
75. Re: Excel for Seam preview
danielc.roth Aug 1, 2008 8:45 AM (in response to nickarls)Yes, this seems to be a bit confusing. This is why: The pdf and excel module uses their own document store, but they are identical, except for the
pdf
vsexcel
part.The document store will be generalized to work for both at the same time later on.
-
76. Re: Excel for Seam preview
danielc.roth Aug 1, 2008 8:48 AM (in response to nickarls)The source, documentation and a really small example is in the trunk right now. You're most welcome to review it and create JIRAs if you find problems/errors/bugs etc.
-
77. Re: Excel for Seam preview
clarkchrisp Aug 1, 2008 3:24 PM (in response to nickarls)It would also help if I knew what I was doing!! I actually got the separate template export working as I needed to mess with the data a bit and that also works perfect.
Thanks for a great add on is such a small amount of time.
Chris
-
78. Re: Excel for Seam preview
infinity2heaven Aug 7, 2008 9:23 PM (in response to nickarls)When I include seam-excel & the dependent jexcelapi.jar (latest), the logging in my applications is completely turned off. I reverted back, removing these jars, the logging works fine. I use org.apache.commons.logging.LogFactory.LogFactory throughout my webapp.
I extracted both these jars to see if there is a log4j.properties, there isnt. However jexcelapi has a custom Logger.class in the common package, not sure if this is the problem.
Did anybody else face this problem? -
79. Re: Excel for Seam preview
nickarls Aug 7, 2008 9:38 PM (in response to nickarls)Looks like the author of JExcelAPI has invented... commons logging! ;-) The author does motivate it here
If you are really bored, you could try removing all logging from the jxl source and recompiling to see if it helps...
-
80. Re: Excel for Seam preview
jpbiard.jean-pierre.biard.skynet.be Aug 12, 2008 4:20 PM (in response to nickarls)I have just started using the Excel for Seam and I find it very useful.
But can someone help me on the following subject:
I am using the worksheet tag and I have defined the value and var attributes for generating the rows automatically.
But I want to add before all the column headers a title in the cell (A1)
and the automatically generated rows starting from A2.
How can I do that ?Thanks for your help.
-
81. Re: Excel for Seam preview
nickarls Aug 12, 2008 6:36 PM (in response to nickarls)Try using the just-now-named
multiple data blocks per samely named worksheet
-technique:<e:workbook> <e:worksheet name="foo"> <e:cell value="A1"/> </e:worksheet> <e:worksheet name="foo" startRow="1"> ...Here goes the iterating columns </e:worksheet> </e:workbook>
-
82. Re: Excel for Seam preview
jpbiard.jean-pierre.biard.skynet.be Aug 19, 2008 2:23 PM (in response to nickarls)Thanks a lot !!!
It works perfectly. -
83. Re: Excel for Seam preview
anilerukala Aug 25, 2008 5:44 PM (in response to nickarls)Hi,
I am able to export an existing JSF datatable using org.jboss.seam.excel.excelExporter.export component, passing in the id of the datatable
as an Seam EL parameter. But I have two more questions.
1. When I use export component with extended data model I am getting the error "Caused by: org.jboss.seam.excel.ExcelWorkbookException: A worksheet's value must be an Iterable, DataModel or Query". Temporarily I wrote a dedicated xhtml page for each page which is using extended data model. But I would like to export a data table that way each time I don't need to write an xhtml page.
How to use excelExporter.export component with extended data model by passing an id of the datatable?
2. In one cell I want to show two or more employee names. I want something like
<e:cell value="#{company.employees}" var="employee">
employee.employeeName<br/>
</e:cell>
I know right now e:cell doesn't support the var attribute and value should not be a list. But how do I implement the above functionality? Can I use <a4j:repeat> tag inside the e:cell?
Thanks,
Anil -
84. Re: Excel for Seam preview
nickarls Aug 25, 2008 9:25 PM (in response to nickarls)1) Should be doable, haven't done any testing on extended data models but the method goes through different scenarios trying to extract an iterator but currently it apparently isn't covered so it throws an exception and gives up. Could you please file a JIRA?
2) Hmmm. If you set the cells wrap property to true you should be able to get multiline-entries with Name1\nName2\nName3. Can you do the collecting/grouping in an bean-method? Or does anyone else know a better way?
-
85. Re: Excel for Seam preview
nickarls Aug 26, 2008 9:36 AM (in response to nickarls)I opened a JIRA for the extended data model iterator
-
86. Re: Excel for Seam preview
danielc.roth Aug 26, 2008 7:07 PM (in response to nickarls)1) Could you give some more code please. Which ExtendedDataModel are you using? I tried with org.richfaces.model.MapDataModel which extends org.ajax4jsf.model.ExtendedDataModel and it works like a charm. (And it should since org.ajax4jsf.model.ExtendedDataModel extends javax.faces.model.DataModel, which is what we look for).
2) When https://jira.jboss.org/jira/browse/JBSEAM-3233 is resolved, you should be able to use ui:repeat.
-
87. Re: Excel for Seam preview
anilerukala Aug 26, 2008 9:30 PM (in response to nickarls)Thanks for the quick responses. I am very glad to provide the necessary information.
1. I am using the org.ajax4jsf.model.SerializableDataModel which extends org.ajax4jsf.model.ExtendedDataModel. My code is pretty much similar to this example.
I also tried with ExtendedDataModel. Here is the second sample example.
In both the cases it is not exporting the data when I pass the id of the richfaces data table. Please let me know if you need more information.
Thanks,
Anil Erukala -
88. Re: Excel for Seam preview
danielc.roth Aug 27, 2008 10:18 AM (in response to nickarls)I think that explains it. The code you posted a link to, throws an exception if getWrappedData is called. When we find a DataModel, we take the data to iterate over from the getWrappedData method. You'll have to implement that method to return a something that is iterable.
-
89. Re: Excel for Seam preview
vladimir.kovalyuk Aug 27, 2008 1:12 PM (in response to nickarls)Daniel and Nicklas, just for information, why you didn't rely on POI library?
AFAIK POI developers have plans for supporting new open document formats (and MSOffice 2007 as well).