Contents
- Index
- Previous
- Next
ImportFromExcelFile method
Applies to
TProfGrid component
Declaration
function ImportFromExcelFile(const FileName: TFileName; const SheetNameOrIndex: Variant; ImportCellBorders: Boolean = False): Boolean;
Description
Imports the grid from the specified XLS file via OLE.
The first parameter is the name of the file to import.
The second parameter may be either the name of sheet or the index of sheet to import. To import an active sheet, you may pass Null() as the second parameter.
The third optional parameter specifies whether any cell-wise borders should be imported. (Importing cell-wise borders may significantly slow down the import process).
Tip: You may use the OnImportProgress event to visualize the process of import if necessary.