How to search string in excel sheet if does not have column header

Excel file will look like this

I have to filter "Not completed " exercises for that week and send the notification to that person.

Please any one help me
Thanks,
Barathi

1 Like

Read Excel File, Use Filter DataTable

3 Likes

hi barathi,

can you please attach test excel file. and also can you please explain more clear about the usecase.

Regards,
Praneeth

Hi ,
Thank you for your response. This will work only for specific column .
Regards,
barathi

Hi Praneeth,
Thanks for your reply
This is a weekly Tracker .If the student finished their exercise with in due date the Exercise column will be changed to “Completed” and their completion date will also reflected on Date column. If the Exercise is “Not Completed” the date column is empty. All the Date columns are due date of that particular exercise. If they failed to submit their exercises within due date bot should send a email to them as a reminder.

Thank you
Barathi

Haii @barathi


Refer this😀

Hi barathi,

Is the structure of excel is fixed always.

Thank you

Thank you @sowndaryacse1505. I will check …
Regards,
Bharathi

hi @praneeth.peyyeti ,

Yes the structure of excel is fixed

Thank you
barathi