Open all files in a specific folder

[saachitalwar]

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.

[saachitalwar]

No, it isn't working

[binu_acs]

@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?