Not sure if this has already been covered but to export to Excel from any grid one could simply instantiate an instance of Excel and control it directly. This way you can access all of the Excel functionality – opening, saving, writing, reading, charts, etc., etc. – from within your app. Although Excel is only exposed as a COM object, you can Interop it and use it from .NET.
Just a slight caveat… if you create a visible instance of Excel and start to write data to it, then moving the focus from your app to the Excel instance can create Excel exceptions. Work around this by creating hidden instances of Excel, write your data then make it visible.
Just a thought…
p.s. I too would like to see “Export to Excel” functionality. Saying that, the Xceed Grid control is very impressive.
Imported from legacy forums. Posted by John (had 6589 views)