Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
180
How to export Hierarchical Data using Infragistics.Excel apis
posted

Hi

Can you help me to export Hierarchical Data using Infragistics.Excel apis.

I cant use Excel exporter as I am using WebHierarchicalDataGrid of 2010.1 version and we do not have ExcelExporter for that control.

Thanks

  • 44743
    posted

    Excel itself does not support hierarchical data, but you can group rows and columns, and we leverage this to export hierarchies. You can do the same by setting the OutlineLevel property on rows or columns to a value greater than 0. Contiguous rows (or columns) with the same OutlineLevel value will become a group that can be expanded or collapsed. Within that group, some contiguous rows can even have a higher outline level to create a subgroup within the outer group. This can be done with up to seven levels.