from openpyxl import load_workbook
 
wb = load_workbook('Base.xlsx')
 
#ws = wb.get_sheet_by_name('Крышка багажника')
 
f = open('tmpFile.txt', 'a')
for sheet_name in wb.get_sheet_names():
    ws = wb.get_sheet_by_name(sheet_name)
 
    for r in range(2,ws.max_row):
        if not ws.cell(row=r,column=2).value == None:
            NameP = ws.cell(row=r,column=2).value + " " + ws.cell(row=r,column=3).value
            NameP = NameP + "\t" + str(ws.cell(row=r,column=9).value)
            f.write(NameP + "\n")

ZnJvbSBvcGVucHl4bCBpbXBvcnQgbG9hZF93b3JrYm9vawoKd2IgPSBsb2FkX3dvcmtib29rKCdCYXNlLnhsc3gnKQoKI3dzID0gd2IuZ2V0X3NoZWV0X2J5X25hbWUoJ9Ca0YDRi9GI0LrQsCDQsdCw0LPQsNC20L3QuNC60LAnKQoKZiA9IG9wZW4oJ3RtcEZpbGUudHh0JywgJ2EnKQpmb3Igc2hlZXRfbmFtZSBpbiB3Yi5nZXRfc2hlZXRfbmFtZXMoKToKICAgIHdzID0gd2IuZ2V0X3NoZWV0X2J5X25hbWUoc2hlZXRfbmFtZSkKCiAgICBmb3IgciBpbiByYW5nZSgyLHdzLm1heF9yb3cpOgogICAgICAgIGlmIG5vdCB3cy5jZWxsKHJvdz1yLGNvbHVtbj0yKS52YWx1ZSA9PSBOb25lOgogICAgICAgICAgICBOYW1lUCA9IHdzLmNlbGwocm93PXIsY29sdW1uPTIpLnZhbHVlICsgIiAiICsgd3MuY2VsbChyb3c9cixjb2x1bW49MykudmFsdWUKICAgICAgICAgICAgTmFtZVAgPSBOYW1lUCArICJcdCIgKyBzdHIod3MuY2VsbChyb3c9cixjb2x1bW49OSkudmFsdWUpCiAgICAgICAgICAgIGYud3JpdGUoTmFtZVAgKyAiXG4iKQ==