Hi All,
I need to read in the latest Excel file, say, column A.. T and ignore the rest, from within a directory. The directory contains files with name format "LCR-DDMMYYYY". I calculate to find the max DDMMYYYY, then feed the file (from a Directory tool FullPath field) into a Dynamic Input tool. When I run the workflow, I get an error "No Sheet specified, you must specify a sheet" from the Dynamic Input tool.
Can someone show me how to dynamically read in an Excel column A..T?
Thanks.
Regards,
=Hamdy
Solved! Go to Solution.
Since Excel requires a sheet name as part of the path, you can add a Formula tool after the Directory tool with something like [FullPath] + "|Sheet1$" where you are basically concatenating the sheet name onto the file path.
That fixes the problem. Thanks, RodL
Suddenly after my posting had been answered, I was presented with the following article How to dynamically run the most recent file in a file folder with similar solution to my issue.