It's easy with pandas:

import pandas as pd

header = pd.read_excel(r"test\header.xlsx") 
df = pd.read_excel(r"test\stations.xlsx", header=None) 
 
for i in df.index:
    df.loc[i,:].to_frame().T.to_excel(f'test/{i}.xlsx')