Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Open all files in a specific folder

saachitalwar
8 - Asteroid

Hi,

I have a folder with various files and they all have 2-3 sheets each. How can I open all the files and get all the sheets?

 

I need to convert the .xls format files to .xlsx format essentially.

11 REPLIES 11
saachitalwar
8 - Asteroid

No, it isn't working

binu_acs
21 - Polaris

@saachitalwar I think .xls does not support the options to get the sheet names. You need to consider other methods. Are you comfortable using Python?

 

 

 

Labels
Top Solution Authors