TAdvGridExcelImport Class
Component to import an existing Excel file into an AdvStringGrid.
Syntax
Unit: UAdvGridExcelImport
TAdvGridExcelImport = class(TComponent);Constructors
| Name | Description |
|---|---|
| Create | Creates a new instance. |
Destructors
| Name | Description |
|---|---|
| Destroy | Frees all the resources associated with this component. |
Methods
| Name | Description |
|---|---|
| Import | Overloaded Import(TExcelFile) Import(TFileName, string) Import(TStream, string) |
Properties
| Name | Description |
|---|---|
| AdvStringGrid | The grid where to import. If you set this property, then AdvGridWorkbook will be set to nil. In the same way, when you set AdvStringWorkbook, this property will be set to nil. |
| AdvGridWorkbook | The workbook where to import. If you set this property, then AdvStringGrid will be set to nil. In the same way, when you set AdvStringGrid, this property will be set to nil. |
| ImportOptions | Settings that affect how the grid will be imported. |
| LocationOptions | Settings that define where the cells will be imported in the grid. |
| Zoom | The zoom level in the sheet that will be used when importing. If 0 (the default) the zoom in the sheet itself will be used. If not 0, this value must be between 10 and 400. |
| Version | The version of this component. |
Events
| Name | Description |
|---|---|
| OnProgress | Provides a progress indication of how many cells have been exported. |