Для справки, мой список пакетов показывает, что docx и pandas оба установлены и обновлены.
Я также ищу лучший способ закодировать это! Мы будем очень благодарны за любую помощь!


import pandas as pd
from docx import Document
def assignteam(spreadsheet, tabname, teamnum):
df = pd.read_excel(spreadsheet, sheet_name=tabname)
check_team = df[df["Team Name"] == teamnum]
print("hello i work")
return check_team
print("hello i work")
def one_pager(check_team, teamnum):
doc = Document()
doc.add_heading(f'Team {teamnum} Data', level=1)
table = doc.add_table(rows = 1, cols = len(check_team.columns))
table.style = 'Table Grid'
print("hello i work")
header = table.rows[0].cells
for x, col in enumerate(check_team.columns):
header[x].text = str(col)
print("hello i work pt2")
for index, row in check_team.iterrows():
cells = table.add_row().cells
for x, value in enumerate(row):
cells[x].text = str(value)
print("hello i work pt3")
doc.save(f'Team_{teamnum}.docx')
def main():
# Self-explanatory
spreadsheet = input("Enter the path to the spreadsheet: ")
tabname = input("Enter the tab name: ")
teamnum = input("Enter team number: ")
totaldat = assignteam(spreadsheet, tabname, teamnum)
if totaldat.empty:
print(f"No data found for team {teamnum}.")
else:
one_pager(totaldat, teamnum)
print(f"Data for team {teamnum} has been written to Team_{teamnum}.docx")
```
Подробнее здесь: https://stackoverflow.com/questions/793 ... d-terminal