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.