Hi I am writing code to loop through all the excel spreadsheet in a workbook to pick up a certain range from each spreadsheet.
My code is as below:
from openpyxl import load_workbook
import pandas as pd
wb = load_workbook('D:\Temp\DD_Catalogues_6092020.xlsx')
sheetnames=wb.sheetnames'
for i in sheetnames:
i = wb[i]
row=i.max_row-3
data_rows = []
for row in i[1:row]:
data_cols = []
for cell in row:
data_cols.append(cell.value)
data_rows.append(data_cols)
df = pd.DataFrame(data_rows)
print(df)
However, it doesn't seem loop through all the worksheet and only pick up the first worksheet. May I know how to resolve that? Thank you so much!