Sheet name does not match a sheet or range name

Hi,

I'm trying to get the first sheet in a excel file into the workflow. I used directory tool to get all the file paths, then filter tool to get the file that I want and add a sheet name behind it using formula tool.

This works fine for one of the files but for another, it showed me an error saying that the sheet name does not match. I have checked for spelling mistake or white space but still haven't found a problem. Does anyone know what's going on here?

this is the directory tool :

Directory tool

And here's the one that worked perfectly fine. :The case when it worked

Here's the error I got. The formula is exactly the same. Sheet name is correct : Error Error

I don't know what went wrong with this input.

Input

Dynamic Processing

Accepted answers

LinhNguyen

I think I found where the problem is.

Instead of the normal xlsx format, I used the Excel legacy format (still xlsx, I don't know where the difference is) and it worked. Not sure why though )

And without the $ Alteryx couldn't read it in, which is strange. I saw some other posts where people used sheet name without $ but I haven't been able to use that even once.

Thank you so much!!!

All comments

Thableaus

Hi @LinhNguyen

Is the sheet name really Report$ or you added the "$" for a convention?

Did you try without "$"?

Cheers,

LinhNguyen

Hi @Thableaus ,

I tried both with $ and without $. I also tried putting another quote around the sheet name 'Report' . All of those didn't work and I still got the same error.

sazit

I had ran into the same error, the issue for me was that the pull file path exceeded the character limit, so that could also be a reason for some other cases.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703