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

Help Studio
, ,
1

Excel file will look like this

image
image1067×175 6.69 KB

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
2

Read Excel File, Use Filter DataTable

image
image1267×651 20.2 KB

3 Likes
3

hi barathi,

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

Regards,
Praneeth

4

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

5

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

6

Haii @barathi

Refer this😀

7

Hi barathi,

Is the structure of excel is fixed always.

Thank you

8

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

9

hi @praneeth.peyyeti ,

Yes the structure of excel is fixed

Thank you
barathi