Just wondering how to open excel sheet or workbook genrated by the gridexcel exporter, I only see the option to save the grid contents to local disk. I want to be able to open the excel on the fly without saving it.
Thanks,
I kind of address the issue in my post in this thread: http://forums.infragistics.com/forums/t/13342.aspx
Do you mean you want to open the file by Microsoft Excel in an unsaved document? If so, I'm not too sure how to accomplish this, but I assume you would only need a stream of the file contents to pass to Excel's automation object somehow. To get one, you can create a new Workbook instance. Pass it to the overload of Save on the grid exporter which takes a Workbook. Then call Save on the Workbook object, passing in a Stream object.
If instead you want to view the contents of the exported file in a Workbook instance without saving to a file and loading it again, you can use the first two steps of the process described above.