Hi all,
I am wanting to utilise the export to excel functionality of the rad grid, without actually displaying a grid.
Can this all be done in memory, without actually physically having a control on a page? The reason being,
the data i am displaying (summarised) and the data i want to export are very different.
There are some basic ways of exporting to excel for sure, but i figure leveraging the rad grid implementation will be more robust than something i can cobble together in a couple of hours.
Is what i am thinking even possible?
I would welcome any insight?
As a starting point, i was kind of thinking along the line of the code below.
//definately incomplete!!!
public void btnExport(object sender, eventargs e)
{
Or am i just over complicating this?!
Thanks.
I am wanting to utilise the export to excel functionality of the rad grid, without actually displaying a grid.
Can this all be done in memory, without actually physically having a control on a page? The reason being,
the data i am displaying (summarised) and the data i want to export are very different.
There are some basic ways of exporting to excel for sure, but i figure leveraging the rad grid implementation will be more robust than something i can cobble together in a couple of hours.
Is what i am thinking even possible?
I would welcome any insight?
As a starting point, i was kind of thinking along the line of the code below.
//definately incomplete!!!
public void btnExport(object sender, eventargs e)
{
RadGrid grid = new RadGrid();
grid.AutoGenerateColumns = true;
grid.ExportSettings.ExportOnlyData = true;
grid.ExportSettings.IgnorePaging = true;
grid.ExportSettings.OpenInNewWindow = true;
grid.DataSource = myCollection;
grid.DataBind();
grid.MasterTableView.ExportToExcel();
}
Or am i just over complicating this?!
Thanks.