microsoft xml excel - row formatting -
microsoft xml excel - row formatting -
i using microsoft xml excel coldfusion display query results on excel sheet. using multiple worksheets. see there border style property available. there way can set background color rows , other styles. don't see documentation on how these.
thanks
see xml in excel , spreadsheet component total documentation. helps create spreadsheet, save *.xml , review output. example:
... <styles> <style ss:id="s23"> <interior ss:color="#800080" ss:pattern="solid"/> </style> <style ss:id="s24"> <interior ss:color="#0000ff" ss:pattern="solid"/> </style> </styles> <worksheet ss:name="sheet1"> <table ss:expandedcolumncount="1" ss:expandedrowcount="3" x:fullcolumns="1" x:fullrows="1"> <row> <cell ss:styleid="s23"><data ss:type="string">apple</data></cell> </row> <row> <cell ss:styleid="s24"><data ss:type="string">orange</data></cell> </row> </table> </worksheet> ...
xml excel coldfusion-8
Comments
Post a Comment