Vue Common - Object Structures - ExcelExportPivotGridProps - topLeftCell

A cell used as a start position for export.

Type:

Object

|

String

Default Value: { row: 1, column: 1 }

The cell is specified using coordinates in the Excel document. For example, the following code specifies cell B2:

  • DevExpress.excelExporter.exportPivotGrid({
  • // ...
  • topLeftCell: { row: 2, column: 2 }
  • });

You can also specify the topLeftCell using the Excel notation:

  • DevExpress.excelExporter.exportPivotGrid({
  • // ...
  • topLeftCell: "B2"
  • });

column

The index of a column that contains the cell.

Type:

Number

This index begins with 1 which corresponds to column A in Excel.

row

The index of a row that contains the cell.

Type:

Number

This index begins with 1 to match the Excel indexing system.