fork download

copy

# your code goes here
from openpyxl import load_workbook
 
wb = load_workbook('Base.xlsx')
ws = wb.get_sheet_by_name('Крышка багажника')
 
f = open('tmpFile.txt', 'a')
 
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
 
        print(NameP)
 
    print (ws.title + "Success!")
 

Traceback (most recent call last):
  File "/usr/lib/python3.5/py_compile.py", line 125, in compile
    _optimize=optimize)
  File "<frozen importlib._bootstrap_external>", line 735, in source_to_code
  File "<frozen importlib._bootstrap>", line 222, in _call_with_frames_removed
  File "./prog.py", line 14
    print(NameP)
        ^
SyntaxError: invalid syntax

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "<string>", line 1, in <module>
  File "/usr/lib/python3.5/py_compile.py", line 129, in compile
    raise py_exc
py_compile.PyCompileError:   File "./prog.py", line 14
    print(NameP)
        ^
SyntaxError: invalid syntax

Standard output is empty