Write data in Excel file with use of Python code

import xlsxwriter as xw

wbTransaction = xw.Workbook('Transaction.xlsx')

wsTransaction= wbTransaction.add_worksheet('Transations1')

transaction = (
    ['Tran Date','Tran Type','Tran Amount'],
    ['5/01/2019','Buy',100.00],
    ['5/02/2020','Buy',200.00],
)

row_number = 0
col_number = 0

for tranDate,tranType,tranAmt in transaction:
    wsTransaction.write(row_number,col_number,tranDate)
    wsTransaction.write(row_number,col_number + 1,tranType)
    wsTransaction.write(row_number,col_number + 2,tranAmt)

    row_number += 1

wsTransaction.write(row_number,1,'Total Amount')
wsTransaction.write(row_number,2,'=SUM(C2:C' + str(row_number) + ')')

wbTransaction.close()