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
15
export ultragrid data to new Excel workbook and automatically open it
posted

Hi.

When I use the code below to export the data in a grid, specifying the target path and filename, everything works fine. 

ultraGridExcelExporter1.Export(ultraGrid1, "c:\\Test\\Report.xlsx");

However, when I use the code below to export the same data into a new Excel workbook, nothing happens. The code executes without error, but no Excel workbook opens up with the exported data. Perhaps the export happens, but the Excel workbook doesn't open. How do I export to a new Excel workbook and automatically open it in Excel after export?

ultraGridExcelExporter1.Export(ultraGrid1);

Thanks.

  • 1660
    Offline posted

    Hello Mahadevan, 

    In order to open the file exported by the UltraGridExcelExporter, a process to open the file could be created, it could be achieved with the following code:

      

                string path = Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + "\\GridData.xls";
                this.ultraGridExcelExporter1.Export(this.ultraGrid1, path);
    
                Process p = new Process();
                p.StartInfo = new ProcessStartInfo(path);
                p.Start();

    Please let me know if you need any further assistance. 

    Regards,
    Ivan Kitanov