for c, col_name in enumerate(col_names):
    sheet.cell(row=1, column=c + 2).value = col_name
for r, row in enumerate(data_tables):
    sheet.cell(row=r + 2, column=1).value = row_names[r]
for c, col in enumerate(row):
    sheet.cell(row=r + 2, column=c + 2).value = data_table[r][c]
Python: How can I create a correspondence matrix between values on rows and columns?