ExcelGenerator
ExcelGenerator
- Subject: ExcelGenerator
- From: Gino Pacitti via Webobjects-dev <email@hidden>
- Date: Sat, 15 Oct 2022 14:01:26 +0700
Hi..
I was trying to use ExcelGenerator to build a report but the output is 3 bytes..
I have the wrapper around a Table see below:
I can debug output the er.excel.EGWrapper - Converting content string
Which shows the Table and results in the er.excel.EGSimpleTableParser also
shows content but after the DirectAction method runs and returns the page which
has and appendToResponse the file is empty.
I am building using Java 11 with latest Wonder.
public void appendToResponse (WOResponse r, WOContext c ){
r.disableClientCaching();
r.removeHeadersForKey("Cache-Control");
r.removeHeadersForKey("pragma");
r.setHeader("application/excel", "content-type");
super.appendToResponse(r, c);
}
<wo:EGWrapper
fileName = "Code Report.xls"
enabled = "$isEnabled"
fonts = "$application.data.Fonts"
styles = "$application.data.Styles"
>
<div>
<table name="Report" border="1" cellType="CELL_TYPE_STRING" cellFormat="0"
class="default">
<tr>
<td >#</td>
<td class="bold" celltype="CELL_TYPE_STRING" width="30">Date Created</td>
<td class="bold" celltype="CELL_TYPE_STRING" width="30">SMS Code</td>
<td class="bold" celltype="CELL_TYPE_STRING" width="30">Document</td>
<td class="bold" celltype="CELL_TYPE_STRING" width="30">No. of Requests
so far</td>
<td class="bold" celltype="CELL_TYPE_STRING" width="30">Picture</td>
<td class="bold" celltype="CELL_TYPE_STRING" width="30">TEXT
Message></td>
<td class="bold" celltype="CELL_TYPE_STRING" width="30">Processing
status</td>
</tr>
<wo:ERXWORepetition list = "$codes" item = "$code" index = "$count">
<tr>
<td class="default" cellType="CELL_TYPE_STRING"><wo:WOString value =
"$count" /></td>
<td class="default" cellType="CELL_TYPE_STRING"><wo:WOString value =
"$code.codeDate" dateformat = "EEE dd MMM yyyy"/></td>
<td class="default" cellType="CELL_TYPE_STRING"><wo:WOString value =
"$code.codeSmsCode" /></td>
<td class="default" cellType="CELL_TYPE_STRING"><wo:WOString value =
"$code.codeDocumentURL" /></td>
<td class="default" cellType="CELL_TYPE_STRING"><wo:WOString value =
"$code.codeRequests" /></td>
<td class="default" cellType="CELL_TYPE_STRING"><wo:WOString value =
"$code.codePictureURL" /></td>
<td class="default" cellType="CELL_TYPE_STRING"><wo:WOString value =
"$code.codeMessage" /></td>
<td class="default" cellType="CELL_TYPE_STRING"><wo:WOString value =
"$code.codeStatus" /></td>
</tr>
</wo:ERXWORepetition>
</table>
</div>
</wo:EGWrapper>
Attachment:
signature.asc
Description: Message signed with OpenPGP
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden