openpyxl to df set headers

PHOTO EMBED

Fri Sep 30 2022 08:22:07 GMT+0000 (Coordinated Universal Time)

Saved by @quaie #python

wb = op.load_workbook(filename=BytesIO(bb))
ws = wb.worksheets[0]
_data = ws.values
columns = next(_data)[0:]
df = pd.DataFrame(_data, columns=columns)
content_copyCOPY