Read Excel file
import openpyxl
wb = openpyxl.load_workbook(filename = 'chart.xlsx')
for ws in wb.worksheets:
print(ws.title)
ws = wb.worksheets[0]
print(ws['A1'].value)
Press ← or → to navigate between chapters
Press S or / to search in the book
Press ? to show this help
Press Esc to hide this help
import openpyxl
wb = openpyxl.load_workbook(filename = 'chart.xlsx')
for ws in wb.worksheets:
print(ws.title)
ws = wb.worksheets[0]
print(ws['A1'].value)