I'm exporting to excel using biff format and I need to implement the below.
1) How do I group ceratin column names and assign a group name to them. This group header name needs to span the columns grouped and appear at the top. Please see my sample excel sheet attached.
2) how do I specify different colors for different columns in the exported excel sheet while exporting to excel in radgrid. I do not want to use html formatting due to excel warning message.
Please help with code.
1) How do I group ceratin column names and assign a group name to them. This group header name needs to span the columns grouped and appear at the top. Please see my sample excel sheet attached.
2) how do I specify different colors for different columns in the exported excel sheet while exporting to excel in radgrid. I do not want to use html formatting due to excel warning message.
Please help with code.
Attached files
