Extract ZIP

The Extract Zip function helps in extracting a zip file

Step 1:

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

Step 2:

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:

1) You can keep it empty

By default, this function will Extract files in Temp Folder

Temp location : C:\Users\dave\AppData\Local\SheetKraft\Temp\


2) Or you can provide the cell reference which contains the path for Destination Folder

In this case (C3)


Step 3:

Overwrite file will overwrite the existing file if present in then Destination Folder

Step 4:

Getting Extracted files

Again, we can use =GetAllFiles.SK to get the unzipped file.