Extract Zip


This 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 Extractfiles in Temp Folder

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

img1


  1. Or you can provide the cell reference which contains the path for Destination Folder In this case(C3)

img2


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.