Export datagrid to excel

[Twyce]

I'm exporting data from a datagrid to an excel spreadsheet.I want the spreadsheet to open and display the data when the data is exported(when you click button export).How do i go about making that happen.Please help

[Manas Bhardwaj]

Twyce wrote:

I want the spreadsheet to open and display the data when the data is exported(when you click button export).

Once you export the data and file has been written, open the Excel application passing the recently written file name.

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

[Trushal19]

hi, can you please tell how you are exporting data from datagrid? I need it urgently. I donot have MS office installed on server