Automation Designer - Folder Iterator cannot take file extension for Excel

Toad for Oracle & DevOps Toolkit
1

I want to read the contents of a folder, copy the file to a static name (like A.xls), then import each file I find to append to A.xls. Eventually export the entire file. (maybe there is a better way than what I was planning).

Unfortunately, the only file extensions are listed in a drop down to choose from. Why can't I just type the extension myself of include windows software extensions, like .xls, xlsx, xlsm or mdb etc.?

Thanks.
John

2

It's true that we have some file extensions in the list, but you should be able to type in *.xls or whatever you want.

Does that work?

3

OMG, that didn't come to mind. So simple and it works fine. Thank you.

1 Like