Get Started

API Reference

Class

ExcelChartGridLayout

Edit on GitHub
Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Source OfficeIMO.Excel/ExcelChartGridLayout.cs:30
Modifiers sealed

Produces sequential chart placements for worksheet dashboards that use the default Excel row and column grid.

Inheritance

  • Object
  • ExcelChartGridLayout

Usage

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

Returned or exposed by

Constructors

public ExcelChartGridLayout(Int32 row, Int32 column, Int32 widthPixels = 520, Int32 heightPixels = 320, Int32 chartsPerRow = 2, Int32 horizontalGapPixels = 48, Int32 verticalGapRows = 2) #
OfficeIMO.Excel/ExcelChartGridLayout.cs:30

Initializes a chart grid layout.

Parameters

row System.Int32 requiredposition: 0
One-based worksheet row for the first chart.
column System.Int32 requiredposition: 1
One-based worksheet column for the first chart.
widthPixels System.Int32 = 520 optionalposition: 2
Chart width in pixels.
heightPixels System.Int32 = 320 optionalposition: 3
Chart height in pixels.
chartsPerRow System.Int32 = 2 optionalposition: 4
Number of charts to place before wrapping to the next row.
horizontalGapPixels System.Int32 = 48 optionalposition: 5
Minimum horizontal gap between chart slots, in pixels, calculated against default-width Excel columns.
verticalGapRows System.Int32 = 2 optionalposition: 6
Minimum vertical gap between chart rows, in worksheet rows, calculated against default-height Excel rows.

Methods

public ExcelChartPlacement Next() #
OfficeIMO.Excel/ExcelChartGridLayout.cs:60
Returns: ExcelChartPlacement

Gets the next chart placement and advances the layout cursor.

Returns

Chart placement for the next dashboard slot.