excel - Want to read Worksheets from a workbook using Python Wincom32 -
i want read worksheets workbook using python wincom32 module not able read if number of sheets more. example have excel workbook total 150 worksheets in , trying read 89th excel worksheet using python wincom32 module giving me sheet name not present in excel workbook @ all. using below python code import win32com.client dispatch = win32com.client.dispatch excel = dispatch("excel.application") excel.visible = 1 wb = excel.workbooks.open('<path excel>') count = wb.sheets.count # count stores total number of worksheets present print count ws_name = wb.sheets[ 89 ].name """ supposed read name of 89th worksheet instead giving me garbage name """ print ws_name there mistakes in code: 1) instead excel.visible = 1 should excel.visible = 1 , 2) instead excel.workbooks.open('<path excel>') - excel.workbooks.open('<path excel>') 3) instead wb.sheets.count - wb.sheets.count , 4) instea...