Class
ExcelDashboardOptions
OfficeIMO.Excel.Reports
Options for building a dashboard table and chart from tabular data.
Inheritance
- object
- ExcelDashboardOptions
Usage
Explore 2 API references to this type
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Accepted by parameters 2
- Extension method ExcelSheet.AddDashboard
- Method ExcelReportExtensions.AddDashboard
Constructors
public ExcelDashboardOptions() #Inherited Methods
Properties
public int TableColumn { get; set; } #Top-left column for the generated table.
public bool IncludeAutoFilter { get; set; } #Whether the table should include AutoFilter dropdowns.
public bool AutoFit { get; set; } #Whether table columns should be auto-fitted after insertion.
public bool 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 ExcelDashboardOptions.Title when omitted.
public int? ChartRow { get; set; } #Optional top-left chart row. Defaults to ExcelDashboardOptions.TableRow.
public int? ChartColumn { get; set; } #Optional top-left chart column. Defaults to two columns after the table.