Export to excel removing the indentation of treecell.

[Administrator]

Hi,

Could somebody help me exporting GridControl to Excel without loosing the indentation of TreeCell in the GridControl.

I have a treecells in GridControl like the below

-Node1
- ChildNode1
- GrandChild1
- GrandChild2
- ChildNode2
- GrandChild1
- GrandChild2
- ChildNode3
- GrandChild1
- GrandChild2
-Node1
- ChildNode1
- ChildNode2
- ChildNode3


After exporting to Excel it looses the indent of each node and each node is drawn with same indent and displayed as below.


-Node1
- ChildNode1
- GrandChild1
- GrandChild2
- ChildNode2
- GrandChild1
- GrandChild2
- ChildNode3
- GrandChild1
- GrandChild2
-Node1
- ChildNode1
- ChildNode2
- ChildNode3




If you have any sample, please reply with the sample program.

Could you help me solve this issue as soon as possible. Thanks.

I am using 6.1.0.34.

[Administrator]

Hi,

I am sorry.

Please see the attached images to find the difference between before export and after export.






Indentation_85de8c3a.zip

[Rajadurai C]

Hi Rajendra,

Thanks for your interest in Syncfusion products.

There is no built-in support for exporting TreeView structure in gridcontrol to excel sheet. However, you can try to handle some code manually in such a way in GridExcelConverterControl class to reflect tree nodes in grid. This support is available in our gridgroupingcontrol. Please refer to our browser sample Grid.Grouping samples -> Serialization -> Excel Export in 6.1.0.34version dashboard.

Please let me know if you have any further concerns.

Regards,
Rajadurai