ajFileProperty function
Available since AlchemyJ v4.1.3
Description
The ajFileProperty function returns full list of file properties of specified file/folder.
Syntax
ajFileProperty (file_path, [include_header])
| Argument Name | Argument Type | Description |
|---|---|---|
| file_path (required) | String | The full path of the file. Both the forward-slash (/) and backslash (\) are supported as the folder separator. |
| include_header (optional) | Boolean | If it equals TRUE, the column headers will be included in the return value. If it equals FALSE, the column headers will not be included in the return value. The default value is TRUE. |
The function will return:
1) Return Value: Table records in array format.
2) Return Type: Multiple values (array formula)
Example
Take below file as example
ajFileProperty will return 10 file properties in total. Select B5 to K6 as a result range and input the formula,
=ajFileProperty(B1)
use Shift + Ctrl + Enter to make it become an array formula. Name, Is Directory, File Extension, Size, Date Modified, Parent Path, Full Path, Link, Read Only, Hidden columns returned as result.
Error Scenarios
It will return #VALUE! when missing any required parameter or mismatch parameter type. Besides, system will raise error for below scenario(s).
| Error Scenarios |
|---|
| Invalid file path. |