How Can I Iterate Through Excel Files Sheets And Insert Formula In Python?

I get this error TypeError: 'Workbook' object is not subscriptable when i run this code import xlsxwriter from openpyxl import load_workbook in_folder = r'xxx' #Input folder ou

Solution 1:

Documentation for xlsxwriter.Workbook shows

 work_book.get_worksheet_by_name('test1')

Maybe openpyxl or other module could use ['test1']