Re: [displaytag-user] problem with caption export - 2nd request

Christopher Becker Mon, 22 May 2006 12:03:54 -0700

Jorge;

Thanks for the response. Following your suggestion, I did get the caption to display, but another issue has now surfaced. Before, when using the org.displaytag.export.ExcelView, I got the entire list of data (which is displayed in a multi-page format), which is indeed what I want. Now, though I do get the caption in the export, I now only get the first page of the data in the list. I went back to the .JSP page and added the export.amount property, setting it to 'list' in a setProperty tag on the table (even though 'list' is supposed to be the default). Still, I get only the first page, and not the full data list. Any thoughts on how to get this to work?

Thanks and regards,

--Chris

>>> [EMAIL PROTECTED] 5/22/2006 12:57:27 PM >>>

The problem is the export view you've configured. org.displaytag.export.ExcelView doesn't write captions or footers. Use org.displaytag.export.excel.DefaultHssfExportView instead.

-Jorge

Christopher Becker <[EMAIL PROTECTED]> wrote:

Can anyone help with this issue? I am at a loss as to how to get the table caption to display in the excel output file. Everything else works just fine. Any help would be appreciated... thanks!

Regards,

--Chris

>>> [EMAIL PROTECTED] 5/11/2006 9:48:02 AM >>>

I am using displaytag1.1, and working with Excel export. The data portion of the list is exporting correctly, but I am having trouble exporting a caption into Excel. I don't want to display the caption on the jsp page - only in the Excel export file.

Here is how I set up the tag:

<display:caption media="excel">User List</display:caption>

And here is my displaytag.properties file:

export.types=excel
export.decorated=true
export.excel=true
export.csv=false
export.xml=false
export.pdf=false
export.excel.class=org.displaytag.export.ExcelView
export.excel.filename=test.xls
export.excel.include_header=true
export.excel.label=<img src="" border="0" alt=""> Excel
export.banner=<div class="exportlinks">Export to: {0}</div>

The data columns and header info are exported correctly, but the caption does not. If I change the media attribute to include both html and excel, the caption shows in the jsp page, but still not in the excel file.

I also notice that the file being generated in Excel is named a little oddly - it shows as test[1].xls

This is in a Struts 1.2.7 app, using Tiles, and I have added an export filter to web.xml file

Any insight or guidance as to how to get the caption into Excel would be appreciated.... thanks!

Regards,

--Chris
_______________________________________________
displaytag-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/displaytag-user

Feel free to call! Free PC-to-PC calls. Low rates on PC-to-Phone. Get Yahoo! Messenger with Voice

_______________________________________________
displaytag-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/displaytag-user

Re: [displaytag-user] problem with caption export - 2nd request

Reply via email to