I have similar problem.. but I have different senario.

I have 3 XamaDataGrid on form and I want to Export all grids it to one excel on different sheets.

How can I do that.

Hi Rob,

In my xamgrid I use groupby like this

http://help.infragistics.com/NetAdvantage/WPF/2011.2/CLR4.0/?page=xamGrid_GroupBy.html
here is a short code-snippet:
...<ig:XamGrid.Columns >
   <ig:TextColumn IsSorted="Ascending" IsGroupBy="True" HeaderText="Personenkontodescription" Key="Personenkontodescription">...

I can export the data of the groupby-record and the nested records belonging to the Groupby-record.

My Question is:

How can I display the groupby-record in the created excel-worksheet in a grouped way.
You can see a sample of grouped-excel-output (and this is, what I want to implement),
if you export grouped data from xamdatagrid to excel.

Thanks

voks

Hi Rob,

Thanks for your help!
I have implemented an excel-export with the InfragisticsWPF4.DataMananger.v11.2.dll,
as described in the help and it works!

One more question I have:
In my Xamgrid I have two grouped headers. How can I implement the groups in your Excel-Class?

I would like to display the grouping rows in excel like they are converted and displayed in the xamdatagrid-excel-export...

Thanks

voks

Hi voks,

Do you require further assistance on this?