My SQLDatasource has extra columns that I would like to include in the Excel export but NOT show in the UltraWebGrid.
If I hide the columns, they do not export (by default anyway).
Is there a way to export ALL columns from the grid (even hidden ones)?
I could just dump data from the datasource (or the equivalent SQL command), but then I do not have it filtered/sorted the way the user has it in the grid.
Kudos to Infragistics support!
The way to do this is to set columns as ServerOnly = True (and reset Hidden to the default = False). The columns will not render to the client but will be exported by Excel.
Works great!