workbook = xlsxwriter.Workbook('model.xlsx')
business_transactions_sheet = workbook.add_worksheet(
'Input Business Transactions')
it_transactions_sheet = workbook.add_worksheet('Input IT Transactions')
# Create styles
bold = workbook.add_format({'bold': True})
header_row = 7
btHeaders = [
'Business Transaction Name', 'Transaction Description',
'Business Volumes', 'Frequency', 'Notes'
]
btSheet = Sheet(business_transactions_sheet)
btSheet.add_header(btHeaders)
btSheet.write_headers(header_row, bold)
itHeaders = [
'Business Transaction', 'IT Transaction Name',
'IT Transaction Description', 'Qty per transaction',
'Transaction Rating', 'TPS', 'Notes'
]
itSheet = Sheet(it_transactions_sheet)
itSheet.add_header(itHeaders)
itSheet.write_headers(header_row, bold)
# Parse the xml data.
tree = ET.parse('data.xml')
root = tree.getroot()
