Gridview Export to Excel

[Prasad]

1)I have done my hirarchy grid export excel functionality but it is showing button types (Hirarchy simbles) left side as mentioned in the screenshot.

Suggest me how to overcome above one.

2)The content (rows) of exported excel file data cannot be understood by user means that is not showing properly, is there any property to set to show columns and rows data properly.

Advance Thanks.

[Princy]

Hello Prasad,

Try setting the ExportSettings as shown below.
aspx:

<ExportSettings ExportOnlyData="true" Excel-Format="Html" IgnorePaging="true">
</ExportSettings>

Also check the following help documentation which explains formatting an exported excel file.
Word/Excel export (HTML-based).

Thanks,
Princy.

[Prasad]

I applied your suggested settings but I could not see any difference and I'm getting same thing which I have sent you screenshot.

Prasad.