Misc

Validate: Validate.SK is a SheetKraft function used to validate a condition and report custom message.

Write Array: The WriteArray.SK Function expands a formula as an array.

Region Function: Region functions can be used widely across various array based functions like vlookup, import and export functions, pivot, stack rows, filter, fill, etc.

Extract ZIP: The Extract Zip function helps in extracting a zip file

Run Command And Command Line: CommandLine.SK is used to construct CMD commands to be executed using RunCommand.SK.

Sheet Names: SheetNames.SK is a SheetKraft function used to get the sheet name(s) of excel workbook.

Count Down & Count Right: We may encounter scenarios where we need the count of dynamic vertical/horizontal range, we can achieve this by using SheetKraft count functions.

Get All Files: This function is used to get all the files in a folder.