Hello, ­­­­­

I am just checking about the progress of this issue. Let me know If you need my further assistance on this  issue?

Thank you for using Infragistics Components.

Hello,

I have modify the sample and now if you have a hidden column in the grid, UltraGridExcelExporter  doesn’t export this column.
For the rows I am not sure if you mean hidden rows or collapsed , however and both cases this shouldn’t be easy to find a way to achieve this, because you shouldn go trough hierarchical data to skip or to avoid exporting of this row and its child rows.

Please let me know if you have any further questions.

Ok this works.

And it exports the each band seperately like I wanted. But now it exports all the rows instead of the rows I have hidden on the grid. Which what I dont want.

When I try to call the table directly I get a error.

Child list for field table cannot be created.

How to get the table with only the columns I ask for without getting the error

"Child list for field table cannot be created.".

the logic I use is below.

this.ultrgrid.datasouce = this.dataset.table; // i get the error on this line

Worksheet

sheet2 = wb.Worksheets.Add("Table1");

ultraGridExcelExporter1.Export(ultraGrid, sheet2, 0, 0);

Hello ,

I have created a small sample in order to illustrate my idea. Please run the sample and press “Export” button. Please let me know if this is what you are looking for.

Please let me know if you have any further questions.

How to get access to GetChildBand();

What class or library this functions is in?

This is what i have below i havent tried it yet.

Infragistics.Documents.Excel.

();

Infragistics.Documents.Excel.

GetChildBand();  // THis line is giving me an error. dont know what getchild band is

wb.Save(dlg.FileName);