Export Grid To Excel launching Excel

[Sunil Vurity]

Hi All,

I have a query,

I want to export grid to excel but without saving it to a file.

MyScenario :

Step 1 : Export Grid to Excel
Step 2: Launch Excel and write records to it
Step 3 : Once writing records is done,open a save dialog box to let user save where ever user wishes to.

Appreciate your help,

Thanks,
Sunil Vurity.

[Geetha M]

Hi Sunil,

Thank you for your interest in Syncfusion products.

You can stream the excel file to browser which would directly open it in Excel. You may then save it as shown in the simple sample below.

http://help.syncfusion.com/samples/XlsIO.Web/8.1.0.30/F93660/F93660.zip

Please let me know if you have any questions.

Regards,
Geetha

[Sunil Vurity]

Hi Geetha Thanks for your support,

But my application is windows not web application.

Need help in this regard.

I want to open Excel (i should also be checking if excel is installed in the machine or not ) and the write grid to it asking user to save by opening a save dialogbox instead of saving it first.

Appreciate your help.
Cheers

[Geetha M]

Hi Sunil,

If you are running a windows application, it is not possible to open the Excel file without saving to disk. But you may check if Excel is present or not using the following code:

try
                {
                 System.Diagnostics.Process.Start("Sample.xlsx");
                }
                catch (Win32Exception)
                {
                    MessageBox.Show("Excel is not installed in this system");
                }

Please try this and let me know if you have any questions.

Regards,
Geetha