for sheet in doc.sheets:
    print('-' * 40)
print("   Sheet name : '%s'" % sheet.name)
print('Size of Sheet : (rows=%d, cols=%d)' % (sheet.nrows(), sheet.ncols()))
sheet = doc.sheets[0]
df_dict = {}
for i, row in enumerate(sheet.rows()):
    if i == 0:
        df_dict = {cell.value: [] for cell in row}
col_index = {j: cell.value for j, cell in enumerate(row)}
continue
for j, cell in enumerate(row):
    df_dict[col_index[j]].append(cell.value)
df = pd.DataFrame(df_dict)
How to convert OpenDocument spreadsheets to a pandas DataFrame?