Forums Ultimate UI for ASP.NET Web Forms
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
Close
Hongguang
560
Excel Format - Automatic Outline expand/collapse buttons
posted


I have to format Excel data as doc in attached link ..
This attached format was created with UltraWebGrid and DataSet, but
for my project I have to use ONLY Infragistics.Excel.Workbook/Worksheet  components [c#]..

Input data is XML..parsing, extracting data and populate Infragistics.Excel.Workbook/Worksheet .. no problem there ..

But I could not find any example for Infragistics.Excel.Worksheet to create "Automatic Outline" ,
how to group/expand rows by expand/collapse  buttons [+/-] on left side of worksheet.

I will really appriciate any help …

  • 560
    posted

    OK.. I figured out this..it was quite simple

    Worksheet has property OutlineLevel , you need only to set correct Level

    Worksheet.Rows[x].OutlineLevel = Level;