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 inside the macro can you change the path .xls , save the macro and run again
@saachitalwar use batch macro, sample workflow attached
I's afraid I haven't worked with batch macros before.
It's giving this error. How to add my folder?
@saachitalwar are you trying to read .xls files?
Yes, multiple files with sheet name either ABC/abc/ABCD
I changed it to xls and need help with the list of sheet names. this error is popping up
@saachitalwar are you able to see the below option in your input file after connecting the .xls file
I'm using a directory.
Do you mean dynamic input?
@saachitalwar open a new workflow and connect any .xls file using input file and test the above settings
No, it isn't working
@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?
