I have two kinds of excel files named either A or B in a folder. The task that I’m trying to achieve is that if it is an excel titled A, then check the values of first 4 columns (eg. Age = 20, Name = isnotNothing, Action = Create Code = isnotNothing) , if not I’ll have a log message or trigger an email response.
If it is an excel titled B, then check values of 3 columns (eg. Type = car, Name = isnotNothing, Action = Update)
I’m having problems just differentiating the two types of excel as I have no idea how to read the Excel filename.
Thanks for your help!