#! /usr/bin/env python
# -*- coding: utf-8 -*-
# import load_workbook
from openpyxl import load_workbook
# set file path
filepath = 'c:/Users/Андрей/Download/data.xlsx'
# load demo.xlsx
wb = load_workbook(filepath)
# select demo.xlsx
sheet = wb.active
# set value for cell A1=1
sheet['L1'] = 1

 C:\Users\Андрей\PycharmProjects\project\venv\Scripts\python.exe C:/Users/Андрей/PycharmProjects/project/from_excel.py
Traceback (most recent call last):
  File "C:/Users/������/PycharmProjects/project/from_excel.py", line 11, in <module>
    wb = load_workbook(filepath)
  File "C:\Python27\lib\site-packages\openpyxl\reader\excel.py", line 311, in load_workbook
    data_only, keep_links)
  File "C:\Python27\lib\site-packages\openpyxl\reader\excel.py", line 126, in __init__
    self.archive = _validate_archive(fn)
  File "C:\Python27\lib\site-packages\openpyxl\reader\excel.py", line 98, in _validate_archive
    archive = ZipFile(filename, 'r')
  File "C:\Python27\Lib\zipfile.py", line 779, in __init__
    self.fp = open(file, modeDict[mode])
IOError: [Errno 2] No such file or directory: 'c:/Users/\xd0\x90\xd0\xbd\xd0\xb4\xd1\x80\xd0\xb5\xd0\xb9/Download/data.xlsx'
Process finished with exit code 1

 C:\Users\Andrew\PycharmProjects\project\venv\Scripts\python.exe C:/Users/Andrew/PycharmProjects/project/excel.py
Traceback (most recent call last):
  File "C:/Users/Andrew/PycharmProjects/project/excel.py", line 11, in <module>
    wb = load_workbook(filepath)
  File "C:\Users\Andrew\AppData\Local\Programs\Python\Python37\lib\site-packages\openpyxl\reader\excel.py", line 311, in load_workbook
    data_only, keep_links)
  File "C:\Users\Andrew\AppData\Local\Programs\Python\Python37\lib\site-packages\openpyxl\reader\excel.py", line 126, in __init__
    self.archive = _validate_archive(fn)
  File "C:\Users\Andrew\AppData\Local\Programs\Python\Python37\lib\site-packages\openpyxl\reader\excel.py", line 98, in _validate_archive
    archive = ZipFile(filename, 'r')
  File "C:\Users\Andrew\AppData\Local\Programs\Python\Python37\lib\zipfile.py", line 1204, in __init__
    self.fp = io.open(file, filemode)
FileNotFoundError: [Errno 2] No such file or directory: 'c:/Users/Andrew/Download/data.xlsx'
Process finished with exit code 1

 filepath = 'c:/Users/Andrew/Download/data.xlsx'

 filepath = r'C:\Users\Andrew\Download\data.xlsx'

 open(filepath,"r")

 import pathlib
for i in Path("c:/Users/Andrew/Download").glob("*.xlsx"):
    print(i)

 import pathlib
for i in Path("c:/Users/Andrew/Download").glob("*.*"):
    print(i)