RadGrid to Excel in memory without exporting

[Coffee]

Dear folks,
                   I have a  radgrid that display monthly schedule for a ROTA application. This schedule is coming from a table in the database Sometimes, a schedule needs to be revised, which means making changes to certain days schedules in a month. Before any revision  i want to be able to take a snapshot of the radgrid as an excel file and save it into a filed of type varbinary in a table.
I want this snapshot process to occur in one go, all in memory where it would convert the datatable to excel format and then save to table as an excel file which could be later downloaded for vieweing. I want t avoid the step of exporting the file externally and saving on a location. 

pLS help, i will be extremely grateful

[Pavlina]

Hello,

If you are using the normal, HTML-based export, you can use the OnGridExporting event. In it, you could access e.ExportOutput which is the full exported file content:

protected void RadGrid1_GridExporting(object sender, Telerik.Web.UI.GridExportingArgs e)
{
    string output = e.ExportOutput;
}

For additional information on the subject you can go through the forum thread below:
http://www.telerik.com/forums/619575-save-directly-to-file-by-export-to-excel-feature-of-radgrid

In case this is not what you are trying to achieve elaborate a bit more in the details.

Regards,
Pavlina
Telerik