batter and non-striker info from cricclubs

parse through all matches and extract batter and non-striker info as per attached excel file. please provide python code and excel file filled with data as part of delivery.

link to all matches : https://cricclubs.com/MiLC/viewAllLeagues.do?clubId=18036

Thanks,