i wish to read a single sheet from each files with path:-
C:\Users\user\Documents\testenviroment\test_20190715_1220.xlsx C:\Users\user\Documents\testenviroment\test_20190714_1420.xlsx C:\Users\user\Documents\testenviroment\test_20190713_1020.xlsx . . . C:\Users\user\Documents\testenviroment\test_20190715_0820.xlsx
20190715 is about yyyy,mm,dd
0820 is about time now
time now is the one i wish to wildcard, which no algorithm, or tracking part can be used to track it.
for example, in read file, with path “C:\Users\user\Documents\testenviroment\test_todayDate_*.xlsx”
to me, is failed with reason
any solution or suggestion?