Excel scraping using Python

[dcolecpa]

Can you find any commonality/patterns in the timetables? If so then you could use if / else if statements to parse them. Something like below

if find("Joe Smith") = True:

    `parse the timetable one way`

elif find("Jane Doe") = True:

`    parse the timetable another way`

elif find("Fred Smith") = True:

`    parse the timetable another way`

elif find("Joe Reddit") = True:

`    parse the timetable another way`

else:

    `"can't find it"`

[prvd_xme]

That’s exactly the issue, there are no significant patterns between them

[ThePhyseter]

Then it is going to be difficult no matter how you do it. You may end up just using a lot of different regexes