Is there a way to hide the grid in the UI while still using the Excel export

[Christopher]

    I'd like to use the telerik radgrid control to generate an excel export of data, however, I don't want to display the grid on the web page.  Is there a way to do this?

 

Thanks in advance.

[Attila Antal]

Hi Christopher,

 

If you only want to export the data, there is no need to use the Grid. You can export any collection using the Telerik Document Processing Libraries.  Here is an example that is showing how to use the library and export a large amount of data: Export large amount of data to PDF, XLSX and CSV using the Telerik Document Processing libraries

 

If you still prefer to use the grid, the export functionality would only work on a visible grid (Visible="true"). However, you can still have the grid set to Visible="false" initially, and when clicking on the custom Export button, you can change the Visible property to true, and call the Grid's export method.

 

Please give the suggestions a try and let us know if you have any question.

Kind regards,
Attila Antal
Progress Telerik