I am trying to export a RadGridView to excel and running into a few hiccups. I've been able to to work around these but would like to know if there is a better approach I could/should take.
1.) When exporting to excel the RadGridView seems to only support .xls extension rather than .xlsx. These means the first time the user opens the file in excel they get prompted to reformat and re-save. To work around this currently I am using excel interop to open the file in the back ground and re-save it as .xlsx.
Is there a way to save it directly as a .xlsx?
2.) The export method of the RadGridView appears to only support saving directly to a file.
Can the export be streamed so that it is opened with out having to create a temp file so that when saved the user is forced to select a save location and name (this may be more of an issue with excel rather than telerik)?
3.) I did not see an option to be able to export and preserve pinned columns and pinning the headers in the excel file, currently doing this using excel interop.
Is there a way to export with pinned columns pinned in the excel file and pinning the header row?
Below is the approach I am currently taking to accomplish the above would like to be able to clean it up if there are any built in options.