Opening and reading Zip file

Hi community,

I am trying to resolve problem with my alteryx workflow regarding to zip files.

First of all, I wanted to open xlsx file from zip but during choosing the exact file I cannot choose the exact sheet (please find screenshot below).

Do you know what could cause this problem?

Thank you in advance for your support.

Workflow

Accepted answers

MK97pro

Okay, I found the solution. When I deleted all sheets except one, it works on my "Summary" sheet. Thank you for your support!

All comments

echuong1

Are you able to upload a copy of the data?

DavidP

This is the format for a zipped excel file in the Input Data tool. You can type the fullpath with filename and sheet name in this format in the file path at the top in the Input Data tool.

C:\Users\david\Documents\Alteryx\Testfile.zip|||Testfile.xlsx[Sheet1$]

MK97pro

Unfortunately no

MK97pro

When I wrote the full path in the first row it results in such an error:

Do you know why I cannot specify a sheet as normally in xlsx file? Or where can I do this to read some of sheets?

MK97pro

You are right, when I am using your test file it works. Do you know what could cause this problem? It is possible that xlsx file with few sheets cannot be read?

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335