I'm having a variety of issues with exporting data from a radGrid to Excel:
I'm using the default excel export format.
1. The spreadsheet generated does not show any excel default gridlines (i.e. the ones you see when you create a new, blank spreadsheet. the light blue ones). is there a way to retain these?
2. I have a column in my Grid that shows Address information (string value) for display purposes to the web page screen, I put a <br /> in between the Address street line and the city, state line so that there's always a line break before it shows the city and state information. This html line break is causing excel to put the contents into a new cell, instead of keep the street address and city and state information in the same cell and just wrap it. How can I fix it? (Maybe i could intercept the contents/value of this column and replace the <br /> with a blank, if so, what code can I use to do such a thing?
3. I was also interested in checking out the Excel Format ExcelML, but when I turn it on, I get a blank spreadsheet. Where are there good, quality, demos on how to use the ExcelML option for formatting and exporting of Grid data?
my current export code:
I'm also setting some formatting stuff within rgFailedRecords_ExcelExportCellFormatting; just some cell style width's, style, etc.