TImportOptions Class
Options that affect how the file will be imported into the grid.
Syntax
Unit: VCL.TMSFNCGridExcelImport / FMX.TMSFNCGridExcelImport
TImportOptions = class(TPersistent);
Constructors
Name | Description |
---|---|
Create | Creates a new instance. |
Methods
Name | Description |
---|---|
Assign | Assigns an exisiting object to this one. |
Properties
Name | Description |
---|---|
Formulas | If true, formulas in Excel will be imported as formulas in the grid. You will need to use a TAdvSpreadGrid for those formulas to calculate. If false, the values of the formulas will be imported. |
Images | If true, images will be imported into the grid. Note that as Excel supports "floating" images over a range of cells and TTMSFNCGrid needs the full image to be on one cell, AdvGridExcelImport will merge the cells below the image when importing. |
Comments | If true, comments in Excel will be imported as comments in the grid. |
CellFormatting | If true, cell formatting like background color will be imported into the grid. |
IgnoreNumericFormat | If true, numbers will be imported with all the digits, even if they are formatted to have less decimals. Also dates will be imported with the current formatting instead of the format in Excel. |
CellSizes | If true, row heights and columns widths will be imported into the grid. If false they won't. |
LockedCellsAsReadonly | If true, locked cells in Excel will be imported as readonly cells in the grid. Note that by default all cells in Excel are locked but they won't be readonly unless the sheet is protected. So to use this property you need protected Excel sheets where cells have been unlocked, or all the file will be imported as readonly. |
Html | If true, rich text in Excel will be imported as html text in the grid. If false (the default) rich text will be imported as simple strings. |
Outlines | If true (the default) outlines in Excel will be imported as nodes in the grid. |
Hyperlinks | If true (the default) hyperlinks in Excel will be imported as links in the grid. |
ClearCells | If true, the cells in the grid will be cleared before importing. If false, the cells in Excel will just overwrite exiting ones, but empty cells in Excel will keep the old values in the grid. |
ResizeGrid | If true, the grid will be resized to fit exactly the used range in the sheet being imported. If false only cells that fit into the existing grid will be imported. |