martialmichael126
New Member
I have to Export to excel from my asp.net page.I want to take the route of xml/xsl to excel instead of datagrid export.In the web I got how to do that.enter link description hereI like to know how to format the xsl with column span,colours,row span etc..\[code\]<Table> <Row> <Cell><Data ss:Type="String">Row 1, Col 1</Data></Cell> <Cell><Data ss:Type="String">Row 1, Col 2</Data></Cell> <Cell><Data ss:Type="String">Row 1, Col 3</Data></Cell> <Cell><Data ss:Type="String">Row 1, Col 4</Data></Cell> </Row>\[/code\]The xsl is like above I like to know how to do the formatting columnspan,giving colors etc...any document available.If i give plain xsl with html formatting when I load in excel it's not showing.