We have an article that describes various ways for creating RadGrid programmatically and I would recommend taking a look and eventually follow the instructions. It has several examples that you can try. I actually recommend the one describing the steps for Creating a RadGrid on Page_Init
In your case, I would recommend using an ASP Panel instead of a GenericHTML control as that also renders as a DIV but its a server controls and you can adjust it more than you would do with a Generic HTML element. Create the panel object add it to the page, then create the grid objects and add them to the Panel. All these in the Page_Init event.
We have samples for exporting RadGrid in multiple sheets here: Multiple worksheets in ExcelML
. Another example here: ThreeRadGridsExport
Also there is an article for exporting multiple RadGrid controls into a single file here: Export multiple RadGrids in single PDF/Excel file
. In your case, however, you would like to do that in different sheets.
I hope these articles will help you implement the required behavior.
Get quickly onboarded and successful
with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.