You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by s....@gpe-hkg.com on 2004/05/26 12:12:49 UTC
Please give me a hand
Dear All,
I meet some problem while serializing XML to Excel,
Your help will be much appreciate.
In my sample output, It can show variable styles within one sheet,
Please see attached xml & output Excel file.
But I found the styles can't be effective if I set the region's endRow >
= "10".
? <gmr:Styles>
? <gmr:StyleRegion startCol="0" startRow="0" ?endCol="255" endRow="2">
----> endRow="15" is not OK
? <gmr:Style HAlign="1" VAlign="2" WrapText="1" Orient="1"
? ? ? ? ? ? ?Shade="1" Indent="0" ?Locked="0" Hidden="0"
? ? ? ? ? ? ?Fore="F800:9800:0" Back="3000:6400:F800"
? ? ? ? ? ? ?PatternColor="F800:CC00:9800"
? ? ? ? ? ? ?Format="General">
I had try to set the MaxRow as 1000,65535,65536
<gmr:MaxRow>1000</gmr:MaxRow>
But it is no use.
An other problem, the back & fore colors seems unrecognized even I set
shade="1".
Do you have any idea about it? (I'm using Cocoon 2.1.2 to transfer XML to
Excel.)
Is any other factors effecting the max endrow in styleregions?
Good Lucky!
E-MAIL ADDRESS:s.q.huang@gpe-hkg.com
(See attached file: sqtestt.xls)
(See attached file: sqtestf.xml)
Re: Please give me a hand
Posted by Joerg Heinicke <jo...@gmx.de>.
On 26.05.2004 12:12, s.q.huang@gpe-hkg.com wrote:
> In my sample output, It can show variable styles within one sheet,
> Please see attached xml & output Excel file.
>
> But I found the styles can't be effective if I set the region's endRow >
> = "10".
>
> ? <gmr:Styles>
> ? <gmr:StyleRegion startCol="0" startRow="0" ?endCol="255" endRow="2">
> ----> endRow="15" is not OK
> ? <gmr:Style HAlign="1" VAlign="2" WrapText="1" Orient="1"
> ? ? ? ? ? ? ?Shade="1" Indent="0" ?Locked="0" Hidden="0"
> ? ? ? ? ? ? ?Fore="F800:9800:0" Back="3000:6400:F800"
> ? ? ? ? ? ? ?PatternColor="F800:CC00:9800"
> ? ? ? ? ? ? ?Format="General">
>
>
> I had try to set the MaxRow as 1000,65535,65536
> <gmr:MaxRow>1000</gmr:MaxRow>
> But it is no use.
>
> An other problem, the back & fore colors seems unrecognized even I set
> shade="1".
>
> Do you have any idea about it? (I'm using Cocoon 2.1.2 to transfer XML to
> Excel.)
> Is any other factors effecting the max endrow in styleregions?
It was a year ago when I played around with poi heavily as I needed it
in project. In the meantime I probably forgot the half, but the above
does not look bad. Have you played with the samples in the poi block
[1]? At least the date sample goes beyond 10 rows.
Joerg
[1]
http://cvs.apache.org/viewcvs.cgi/cocoon-2.1/src/blocks/poi/samples/content/
or http://localhost:8888/samples/blocks/poi/ in your local installation
when running with default Jetty.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Serializing XML to Excel (Re: Please give me a hand)
Posted by Andreas Kuckartz <A....@ping.de>.
s.q.huang@gpe-hkg.com wrote:
> (I'm using Cocoon 2.1.2 to transfer XML to > Excel.)
The latest released version is 2.1.5. Did you try to solve your problem with
that version?
Andreas
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org