TTMSFNCDataGridExcelIO.AutoResizeDataGrid Property

When True (default), the grid's row and column count are adjusted on import to fit the worksheet's used range and any picture anchors.

API unit family: TMSFNCDataGridExcelIO Declaring type: TTMSFNCDataGridExcelIO Type: Boolean

Syntax

FMX.TMSFNCDataGridExcelIO.hppPascalC++

property AutoResizeDataGrid: Boolean;

__property bool AutoResizeDataGrid = {read=FAutoResizeDataGrid, write=FAutoResizeDataGrid, default=1};

Default: true

Remarks

Existing fixed bottom rows and fixed right columns are kept in addition to the imported area. When False, cells that fall outside the current grid size are not imported. This option changes the number of rows and columns, not their sizes; sizes are controlled by Options.ImportCellSizes.