Hi Guys,
In my grid, i have 3 level depth, i mean 3 bands, while export this grid to excel, Im able to see the depth as such, but in a collapsed manner.
I need to expand the band while export to excel.
I tried the event endeportexcel, in that i tried e.currentworksheet.rows[0].expanded = true; property as well, but I failed badly in that.
please advice.
looking for your valuable reply.
With Thanks & Regards
Amjath
I saw in other post, MIKE suggest to did row.hidden = false in end_export.
but I think am using Version 5.3 , which doesnt have that property at all.
moreover am getting following error as well,
e.CurrentWorksheet.Rows "foreach statement cannot operate on variables of type 'Infragistics.Excel.WorksheetRowCollection' because 'Infragistics.Excel.WorksheetRowCollection' does not contain a public definition for 'GetEnumerator'"
again row.hidden is not avaiable..
please help me with some other solution
In endexport am doing like this, will this correct..
for (int iRowCount = 0; iRowCount < e.CurrentRowIndex; iRowCount++)
e.CurrentWorksheet.Rows[iRowCount].Expanded =
true;
it expand all the rows, but I want only the groupby rows needs to get expand...
how to do that..
-amjath
Im checking outlinelevel == 1 to check its group by row or not...am getting the output what am aiming for..
please revie the code, its happening in endexport right now..
if(e.CurrentWorksheet.Rows[iRowCount].outlinelevel == 1)
That seems like a good way to do it.
Thanks Mike