Hej, korzystam z tego kursu pythona: https://www.youtube.com/watch?v=_uQrJ0TkZlc
jestem na tym etapie: Project 1: Automation with Python
oto mój kod:
import openpyxl as xl
from openpyxl.chart import BarChart, Reference
wb = xl.load_workbook("transactions.xlsx")
sheet = wb["Arkusz1"]
# cell = sheet['a1']
cell = sheet.cell(1, 1)
for row in range(2, sheet.max_row + 1):
cell = sheet.cell(row, 3)
corrected_price = cell.value * 0.1
corrected_price_cell = sheet.cell(row, 4)
corrected_price_cell.value = corrected_price
values = Reference(sheet,
min_row=2,
max_row=sheet.max_row,
min_col=4,
max_col=4)
chart = BarChart()
chart.add_data(values)
sheet.add_chart(chart, 'e2')
wb.save('transactions.xlsx')
mam następujące błędy:
Traceback (most recent call last):
File "C:/Users/komputer/PycharmProjects/first/app.py", line 4, in <module>
wb = xl.load_workbook("transactions.xlsx")
File "C:\Users\komputer\PycharmProjects\first\venv\lib\site-packages\openpyxl\reader\excel.py", line 312, in load_workbook
reader.read()
File "C:\Users\komputer\PycharmProjects\first\venv\lib\site-packages\openpyxl\reader\excel.py", line 268, in read
self.read_manifest()
File "C:\Users\komputer\PycharmProjects\first\venv\lib\site-packages\openpyxl\reader\excel.py", line 136, in read_manifest
src = self.archive.read(ARC_CONTENT_TYPES)
File "C:\Users\komputer\AppData\Local\Programs\Python\Python37-32\lib\zipfile.py", line 1428, in read
with self.open(name, "r", pwd) as fp:
File "C:\Users\komputer\AppData\Local\Programs\Python\Python37-32\lib\zipfile.py", line 1467, in open
zinfo = self.getinfo(name)
File "C:\Users\komputer\AppData\Local\Programs\Python\Python37-32\lib\zipfile.py", line 1395, in getinfo
'There is no item named %r in the archive' % name)
KeyError: "There is no item named '[Content_Types].xml' in the archive"
jak na razie nie wiele jeszcze z tego rozumiem, dodam że korzystam z systemu windows...
Z pythonem mam kontakt dopiero od kilku godzin więc proszę o wyrozumiałość ;) Z góry dziękuje za pomoc i pozdrawiam.