Following on @Werner Stinckens​ response, if you can give an example then it will be good.

Ideally you can read each row from excel file in python and pass each column as a parameter to a function.

Eg; def apply_mapping_logic(SourceTable ,SourceColumn, TargetTable, TargetColum , MappingLogic)

Within this function you can define what you would like to do with the mapping logic.

Again, to do this you'll have to come up with a logic based on different types of mapping logics you have in your excel file.