I agree, but this versoin does not export Grouped Columns and retain.

it just exports raw data.

thanks

Ray

Hi Ray,

You can still use it to export grouped columns.  Whenever you add a Column to the GroupBy area, normal rows are replaced with GroupByRow objects.  These are the header rows for each of the grouped rows.  Inside this GroupByRow object is another Rows collection which contains the rows that are grouped under it.  Using this you can export grouped data by checking if the the current row you are looking at is of type GroupByRow.  If it is then you would then iterate through the GroupByRow.Rows collection and export those rows together, then move on to the next GroupByRow and do the same.  This will export your data together with the grouping intact.

Thank you will try, but if you have some sample code handy would appreciate if you attach.

Rayudu

Hi Ray,

Here's a sample showing how you can export a XamGrid when you have columns grouped.  The code supports any number of grouped columns.  The important code is in the MainPage.xaml.cs inside the button click event.

Let me know if you have any questions on the sample.

I was able to get the way i want in excel,. except below

how do i get SummaryRow and add those values to excel.

I tried to find , i never get summaryRow but UI has summary totals and subtotals

if ( groupedRow.Rows[i] is SummaryRow) 

regards,

Rayudu A

Hello Rayudu,

For exporting summary values to excel I have attached an updated sample.

Perfect

thanks

perfect. thanks

Hello Rayudu,

For exporting sub-totals after row data I have attached an updated sample.

Thanks verified.

Only thing is i want the subtotal after the row data when grouping.

right now. the header comes,. then sum/subtotal comes.

i need: header/row data/sum-subtotals. as the logic for placing the subtotals is inside the header loop. i see subtotals are in the 1st row of each grouped section. need at last row of each grouped section. that is the normal reporting.

Hello Rayudu,

For exporting totals and sub-totals when grouping records I have attached an updated sample.