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:[EMAIL PROTECTED] (See attached file: sqtestt.xls) (See attached file: sqtestf.xml)
sqtestt.xls
Description: application/msexcel
sqtestf.xml
Description: Binary data
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
