How to write data in excel spreadsheet to the right cells?

Question

Python

How to write data to the table in the desired cells where, for example, %name% is indicated (in the table) and the python takes a variable and writes it instead of %name%.
Ps %name% is listed as an option, not necessarily there.

Answer 1

import pandas as pd

df = pd.read_excel('file.xlsx', engine='openpyxl')
df = df.replace('%name%', 'John Doe')
df.to_excel('file.xlsx', index=False)