API Reference

Class

ExcelDashboardOptions

Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Modifiers sealed

Options for building a dashboard table and chart from tabular data.

Inheritance

  • Object
  • ExcelDashboardOptions

Usage

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Accepted by parameters

Constructors

public ExcelDashboardOptions() #

Properties

public String Title { get; set; } #

Optional dashboard title.

public String Subtitle { get; set; } #

Optional dashboard subtitle.

public Int32 TableRow { get; set; } #

Top-left row for the generated table.

public Int32 TableColumn { get; set; } #

Top-left column for the generated table.

public String TableName { get; set; } #

Optional table name.

public TableStyle TableStyle { get; set; } #

Built-in table style.

public Boolean IncludeAutoFilter { get; set; } #

Whether the table should include AutoFilter dropdowns.

public Boolean AutoFit { get; set; } #

Whether table columns should be auto-fitted after insertion.

public Boolean AddChart { get; set; } #

Whether to add a dashboard chart beside the table.

public ExcelDashboardChartPreset ChartPreset { get; set; } #

Dashboard chart preset.

public String ChartTitle { get; set; } #

Optional chart title. Defaults to Title when omitted.

public Nullable<Int32> ChartRow { get; set; } #

Optional top-left chart row. Defaults to TableRow.

public Nullable<Int32> ChartColumn { get; set; } #

Optional top-left chart column. Defaults to two columns after the table.