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()