I have an excel export running on a grid with 4 columns, 3 bound and one templated. This grid has a custom filtering panel that allows the datasource for the grid to be filtered and sorted before being bound to the grid. When a column is sorted or filtered, the excel export function creates an excel file with no data in it - not even the headers. I can't think of anything to attibute to this result.
Does anyone have some insight to provide me with?
Here is the code I am using to export the grid:
myGrid.Columns.FromKey("Action").Hidden = True myGridEE.DownloadName = "Favorites" myGridEE.Export(Me.myGrid) myGrid.Columns.FromKey("Action").Hidden = False
Hi,
Have you found a solution?
Before exporting to Excel, you will need to rebind the grid in order for data to be available in the export. Could you please try rebinding the grid just prior to exporting and let us know if this helps?
No, nothing happens.
The grid is inside a WebAsyncRefreshPanel but the button is outside the WebAsyncRefreshPanel
{
UltraWebGridExcelExporter1.Export(mainGrid);
}