This function helps in extracting a zip file
Getting the full path of zip file
You can directly input the file path C:\Users\dave\AppData\Local\SheetKraft\Apps\dbo\Extractzip\Inputs\ExtractZipDestinationFolder
Note: This will be static and can cause error
Alternative
Get File Path
You can use =RelativePath.SK this is the relative path of your workbook
But here my files are in ->Activity Folder->Input -> Upload Daily
So, we can use following formula to get complete path
=RelativePath.SK("Inputs\Upload Daily") (C7)
Note: Leave the rows blank below the formula as there can be multiple files at it can overwrite other formulas
Searching Zip File
Getting zip files in Upload Daily file by =GetAllFiles.SK
=GetAllFiles.SK($C$7,".",FALSE,"Full Path") look in formula explorer for arguments (C9)
Note: Leave the rows blank below the formula as there can be multiple files at it can overwrite other formulas
Extracting ZIP file
Type in the formula=ExtractZip.SK() and choose the cell with file path and cell reference for the password
For destination folder:
You can keep it empty
By default, this function will Extractfiles in Temp Folder
Temp location :C:\Users\dave\AppData\Local\SheetKraft\Temp\
Overwrite file will overwrite the existing file if present in then Destination Folder
Getting Extracted files
Again, we can use =GetAllFiles.SK to get the unzipped file.