Hi team,
Now I am in such a situation, I have a urtalwebgrid and one of its colums named "category" ,and has three categories. When I use the UltraGridExcelExporter to export the webgrid I want to create three spreadsheets in a workbook,say "A","B","C",and exprot the data the each spreadsheet according to the colum named "category", just like rows with category "A", export to spreadsheet "A"; rows with category "B", export to spreadsheet "B"; rows with category "C", export to spreadsheet "C".
Can anyone give me some help.
Thanks Inadvance.
Hi sunqy1212,
Thank you for posting in the community.
I am attaching a sample illustrating how your requirement can be achieved by creating a grid to be exported for each sheet and filtering the original datasource. Below is the code used in this case:
Please note that the UltraWebGrid control is now outdated and as of .NetAdvantage 2011 Volume 2 is no longer included in our product package. I would suggest that you consider switching to the WebDataGrid/WebHieararchicalDataGrid. More information regarding these controls is available at:
http://help.infragistics.com/NetAdvantage/ASPNET/2011.2/CLR4.0/?page=Web_WebDataGrid_WebDataGrid.html
Additional samples demonstrating the features of these grids can be found at:http://samples.infragistics.com/aspnet/
Hope this helps.
Please feel free to contact me if are experiencing any issues.