How can I open the latest Excel file within a directory?

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

Input

Dynamic Processing

Accepted answers

RodL

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.

All comments

RodL

hamdylie

That fixes the problem. Thanks, RodL

hamdylie

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703