Create separate CSV file for the data in each row of the Excel File

But the template of the CSV file is as follows
Data for the yellow shaded part would come from the above excel file
and the remaining fields are hard coded
Please advise. Thanks