Re: ExcelGenerator
Re: ExcelGenerator
- Subject: Re: ExcelGenerator
- From: Patrick Robinson via Webobjects-dev <email@hidden>
- Date: Sun, 16 Oct 2022 11:19:53 -0400
Ahhh, yes, that's right! I had thought when I had that issue, that it was
something to do with the HTML, but I never specificly identified the problem as
"spaces". Can you elaborate on what you did? Where did you have spaces that
created a problem?
- Patrick
> On Oct 16, 2022, at 3:40 AM, Gino Pacitti <email@hidden> wrote:
>
> 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
>> <mailto: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
>>> <mailto:email@hidden>)
>>> Help/Unsubscribe/Update your Subscription:
>>>
>>> This email sent to email@hidden <mailto: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