Deployment failure due to excel directory problems

bahageel88 · February 16, 2023, 5:33am

Good Morning
I have been load
Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:10 AM Feb 16 08:19:39 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:19:50 AM Feb 16 08:20:46 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM Feb 16 08:20:55 AM what does this is my github respository trying to deploy my dash application on render using excel sheet to read the data , but I failed consistently may anyone help resolve this issues , the error message I received states:
return self.load_wsgiapp()
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/gunicorn/app/wsgiapp.py”, line 48, in load_wsgiapp
return util.import_app(self.app_uri)
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/gunicorn/util.py”, line 359, in import_app
mod = importlib.import_module(module)
File “/usr/local/lib/python3.7/importlib/init.py”, line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File “”, line 1006, in _gcd_import
File “”, line 983, in _find_and_load
File “”, line 967, in _find_and_load_unlocked
File “”, line 677, in _load_unlocked
File “”, line 728, in exec_module
File “”, line 219, in _call_with_frames_removed
File “/opt/render/project/src/app.py”, line 23, in
df= pd.read_excel(os.path.join(APP_PATH, os.path.join(“data”, “unemplo_figures_1991.xlsx”)))
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/pandas/util/_decorators.py”, line 311, in wrapper
return func(*args, **kwargs)
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/pandas/io/excel/_base.py”, line 364, in read_excel
io = ExcelFile(io, storage_options=storage_options, engine=engine)
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/pandas/io/excel/_base.py”, line 1233, in init
self._reader = self._engines[engine](self._io, storage_options=storage_options)
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/pandas/io/excel/_openpyxl.py”, line 522, in init
super().init(filepath_or_buffer, storage_options=storage_options)
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/pandas/io/excel/_base.py”, line 420, in init
self.book = self.load_workbook(self.handles.handle)
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/pandas/io/excel/_openpyxl.py”, line 534, in load_workbook
filepath_or_buffer, read_only=True, data_only=True, keep_links=False
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/openpyxl/reader/excel.py”, line 346, in load_workbook
reader.read()
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/openpyxl/reader/excel.py”, line 303, in read
self.parser.assign_names()
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/openpyxl/reader/workbook.py”, line 109, in assign_names
sheet.defined_names[name] = defn
AttributeError: ‘ReadOnlyWorksheet’ object has no attribute ‘defined_names’
==> Starting service with ‘gunicorn app:server’
Traceback (most recent call last):
File “/opt/render/project/src/.venv/bin/gunicorn”, line 8, in
sys.exit(run())
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/gunicorn/app/wsgiapp.py”, line 67, in run
WSGIApplication(“%(prog)s [OPTIONS] [APP_MODULE]”).run()
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/gunicorn/app/base.py”, line 231, in run
super().run()
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/gunicorn/app/base.py”, line 72, in run
Arbiter(self).run()
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/gunicorn/arbiter.py”, line 58, in init
self.setup(app)
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/gunicorn/arbiter.py”, line 118, in setup
self.app.wsgi()
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/gunicorn/app/base.py”, line 67, in wsgi
self.callable = self.load()
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/gunicorn/app/wsgiapp.py”, line 58, in load
return self.load_wsgiapp()
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/gunicorn/app/wsgiapp.py”, line 48, in load_wsgiapp
return util.import_app(self.app_uri)
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/gunicorn/util.py”, line 359, in import_app
mod = importlib.import_module(module)
File “/usr/local/lib/python3.7/importlib/init.py”, line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File “”, line 1006, in _gcd_import
File “”, line 983, in _find_and_load
File “”, line 967, in _find_and_load_unlocked
File “”, line 677, in _load_unlocked
File “”, line 728, in exec_module
File “”, line 219, in _call_with_frames_removed
File “/opt/render/project/src/app.py”, line 23, in
df= pd.read_excel(os.path.join(APP_PATH, os.path.join(“data”, “unemplo_figures_1991.xlsx”)))
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/pandas/util/_decorators.py”, line 311, in wrapper
return func(*args, **kwargs)
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/pandas/io/excel/_base.py”, line 364, in read_excel
io = ExcelFile(io, storage_options=storage_options, engine=engine)
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/pandas/io/excel/_base.py”, line 1233, in init
self._reader = self._engines[engine](self._io, storage_options=storage_options)
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/pandas/io/excel/_openpyxl.py”, line 522, in init
super().init(filepath_or_buffer, storage_options=storage_options)
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/pandas/io/excel/_base.py”, line 420, in init
self.book = self.load_workbook(self.handles.handle)
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/pandas/io/excel/_openpyxl.py”, line 534, in load_workbook
filepath_or_buffer, read_only=True, data_only=True, keep_links=False
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/openpyxl/reader/excel.py”, line 346, in load_workbook
reader.read()
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/openpyxl/reader/excel.py”, line 303, in read
self.parser.assign_names()
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/openpyxl/reader/workbook.py”, line 109, in assign_names
sheet.defined_names[name] = defn
AttributeError: ‘ReadOnlyWorksheet’ object has no attribute ‘defined_names’
==> Starting service with ‘gunicorn app:server’
Traceback (most recent call last):
File “/opt/render/project/src/.venv/bin/gunicorn”, line 8, in
sys.exit(run())
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/gunicorn/app/wsgiapp.py”, line 67, in run
WSGIApplication(“%(prog)s [OPTIONS] [APP_MODULE]”).run()
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/gunicorn/app/base.py”, line 231, in run
super().run()
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/gunicorn/app/base.py”, line 72, in run
Arbiter(self).run()
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/gunicorn/arbiter.py”, line 58, in init
self.setup(app)
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/gunicorn/arbiter.py”, line 118, in setup
self.app.wsgi()
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/gunicorn/app/base.py”, line 67, in wsgi
self.callable = self.load()
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/gunicorn/app/wsgiapp.py”, line 58, in load
return self.load_wsgiapp()
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/gunicorn/app/wsgiapp.py”, line 48, in load_wsgiapp
return util.import_app(self.app_uri)
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/gunicorn/util.py”, line 359, in import_app
mod = importlib.import_module(module)
File “/usr/local/lib/python3.7/importlib/init.py”, line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File “”, line 1006, in _gcd_import
File “”, line 983, in _find_and_load
File “”, line 967, in _find_and_load_unlocked
File “”, line 677, in _load_unlocked
File “”, line 728, in exec_module
File “”, line 219, in _call_with_frames_removed
File “/opt/render/project/src/app.py”, line 23, in
df= pd.read_excel(os.path.join(APP_PATH, os.path.join(“data”, “unemplo_figures_1991.xlsx”)))
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/pandas/util/_decorators.py”, line 311, in wrapper
return func(*args, **kwargs)
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/pandas/io/excel/_base.py”, line 364, in read_excel
io = ExcelFile(io, storage_options=storage_options, engine=engine)
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/pandas/io/excel/_base.py”, line 1233, in init
self._reader = self._engines[engine](self._io, storage_options=storage_options)
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/pandas/io/excel/_openpyxl.py”, line 522, in init
super().init(filepath_or_buffer, storage_options=storage_options)
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/pandas/io/excel/_base.py”, line 420, in init
self.book = self.load_workbook(self.handles.handle)
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/pandas/io/excel/_openpyxl.py”, line 534, in load_workbook
filepath_or_buffer, read_only=True, data_only=True, keep_links=False
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/openpyxl/reader/excel.py”, line 346, in load_workbook
reader.read()
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/openpyxl/reader/excel.py”, line 303, in read
self.parser.assign_names()
File “/opt/render/project/src/.venv/lib/python3.7/site-packages/openpyxl/reader/workbook.py”, line 109, in assign_names
sheet.defined_names[name] = defn
AttributeError: ‘ReadOnlyWorksheet’ object has no attribute ‘defined_names’
this mean ? please help me

with best regards

al_ps · February 16, 2023, 11:33am

Hi,

It seems you’ve been making a lot of updates to your repo. Were you able to resolve your issue?

Alan

system · March 18, 2023, 5:34am

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Unable to deploy app	2	1138	March 9, 2023
Dash application Deployment	2	266	March 2, 2023
Deploying Dash by Plotly App on render	6	3739	September 9, 2022
Tutorial deploy failure	4	1643	November 5, 2022
Hello, please help me I have been struggling for over 2 days - I am trying to deploy a Django project	2	510	May 18, 2023

Deployment failure due to excel directory problems

Related Topics