rowdata.append(bt.get('name')) rowdata.append(bt.find('description').text) rowdata.append(bt.find('volume').text) rowdata.append(bt.find('frequency').text) rowdata.append(bt.find('notes').text) btSheet.track_column(0, 0) mappingName = rowdata[0] btSheet.track_column(0, 2) btSheet.write_row(row + header_row, rowdata) for it in bt.findall('it_transaction'): rowdata = [] btSheet.print_mappings() busMappingName = mappingName + '#0' data = itSheet.write_mapping(busMappingName, btSheet) rowdata.append(data) rowdata.append(it.get('name')) rowdata.append(it.find('description').text) qty = 0 try: qty = it.find('qty').text rowdata.append(float(qty)) except: rowdata.append('') rowdata.append(1) busMappingName = mappingName + '#2'