Re: ExcelGenerator
Re: ExcelGenerator
- Subject: Re: ExcelGenerator
- From: Patrick Robinson via Webobjects-dev <email@hidden>
- Date: Sat, 15 Oct 2022 11:56:29 -0400
Hi Gino,
I just built one of these, myself, and remember getting the 3 byte output, but
now I can't remember why. But just looking at what you have there, if that's
your actual HTML, then it looks like you're missing the closing ">" on your
"<wo:EGWrapper" tag.
- Patrick
> On Oct 15, 2022, at 3:01 AM, Gino Pacitti via Webobjects-dev
> <email@hidden> wrote:
>
> 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>
>
>
>
>
> _______________________________________________
> 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
_______________________________________________
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
| References: | |
| | >ExcelGenerator (From: Gino Pacitti via Webobjects-dev <email@hidden>) |