Hi All,

I am using Hierarchical Ultrawebgrid control which displays my data in Parent rows n child rows format.

To export the data into excel, i am using UltraWebGridExcelExporter by

UltraWebGridExcelExporter1.Export(UG1);

Currently after exporting user can expand or collapse the data even in excel but, i want data to open by default in expanded form

Can you suggest me some solution

One more Query.

Can i add Forumla to add a cell in excel exported.

i.e i want to show total of grid cell in excel exported can i add a formula to excel created i.e(Sum).

Thanks

Yashkant 

.