Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
110
how to open the excel file on the fly - using gridexcelexporter
posted

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,

  • 735
    posted

     I kind of address the issue in my post in this thread: http://forums.infragistics.com/forums/t/13342.aspx

  • 44743
    posted

    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.