Name='fruits', comment=None, customMenu=None, description=None, help=None, statusBar=None, localSheetId=None, hidden=None, function=None, vbProcedure=None, xlm=None, functionGroupId=None, shortcutKey=None, publishToServer=None, workbookParameter=None, attr_text='Sheet1!$B$2:$D$8', Name='apple_range', comment=None, customMenu=None, description=None, help=None, statusBar=None, localSheetId=None, hidden=None, function=None, vbProcedure=None, xlm=None, functionGroupId=None, shortcutKey=None, publishToServer=None, workbookParameter=None, attr_text='Sheet1!$C$3', Wb = openpyxl.load_workbook('Book1.xlsx') Note the first two names “apple_range” and “fruits” both have localSheetId=None that implies they are a global range. Let’s load the Excel file into Python, then check the workbook’s defined_names attribute. and ‘private_range’ – Note this is a “private” range which means this named range is only accessible within the scope of the sheet “calc”.
0 Comments
Leave a Reply. |