Re: ExcelGenerator
Re: ExcelGenerator
- Subject: Re: ExcelGenerator
- From: Gino Pacitti via Webobjects-dev <email@hidden>
- Date: Sun, 16 Oct 2022 14:40:13 +0700
Hi…
This is solved…
It was due to spaces in the HTML..
Duh!!
Gino
> On Oct 15, 2022, at 10:56 PM, Patrick Robinson <email@hidden> wrote:
>
> 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 <mailto: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 <mailto:email@hidden>
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
| References: | |
| | >ExcelGenerator (From: Gino Pacitti via Webobjects-dev <email@hidden>) |
| | >Re: ExcelGenerator (From: Patrick Robinson via Webobjects-dev <email@hidden>) |