Workbookwbget_sheet_by_name was deprecated in 16 (as of openpyxl version 240) openpyxlreadthedocsio/en \excelxlsx') sheets = wbsheetnames ws = wbsheetsn the refernce How to switch between sheets in excel openpyxl python to make changes Share Improve this answer Follow answered Apr 23 '19 at 857 Youssri Abo Access Excel Tables with Python This post is about extracting data from Excel tables into Python Source data is with permission from ExcelisFun Excel Tables are a great way of grouping related data, as it makes analysis easier Usually,these tables will have names to identify them, as well as some other cool features An example image is shown below SourceNow, it is a bit fancier, as the code could be executed with a click On the previous one, I have written quit() , thus one should execute it from the consoleStill, B10 is found Thirdly, I have read a comment from @ashleedawg, that one should be able to use the Excel API and thus use the Find() method from it The whole programming becomes quite easy this way, using the xlwings library
How To Generate A List Of Sheet Names From A Workbook Without Vba How To Excel
