hi
my requirement is export grid data to excel, then an instance of excel will be opened.
is there any API can do this work without saving grid to a temporarily excel file.
The ExcelExporter feature exports the data to the Excel file format by writing the data to disk. What other approach are you looking for getting the data into Excel? The clipboard, perhaps? The XamDataGrid supports copying data to the clipboard by enabling the FieldLayoutSettings property: AllowClipboardOperations. There may be a way to automate copying the data and pasting it into an Excel spreadsheet as one alternate way to make this work.
If you are still looking for a solution, let me know what the desired results might be and I will point you in the right direction.
Thank you!