Exporting The Organisation Chart To Excel

The OrgChartComponent has an export to Excel feature that allows end users to open the current organisation chart into Excel. This useful feature allows users to get data into Excel easily from where they can perform advanced analysis.

To do this simply:

• Ensure that the CommandBar is visible
• Set the ShowExport property to True.
• Set the ExportSettings.FieldNames property to indicate which fields should be exported, in this example it is set to "FirstName,Email"
  

Code

        // First ensure that the command bar is visible
        MyChart.CommandBarSettings.Visible = true;
        // And that the "Export" Link is enabled
        MyChart.CommandBarSettings.ShowExport = true;

        // Set the fields to be exported
        MyChart.ExportSettings.Fields = "Firstname,eMail";
        // Optionally set the field headers, by first disabling the Auto Generated headers
        MyChart.ExportSettings.AutogenerateHeaders = false;
        // And then by setting the field headers
        MyChart.ExportSettings.FieldHeaders = "First Name, email";