Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR PYTHON

openpyxl check if worksheet exists

from openpyxl import load_workbook
 
wb = load_workbook(file_workbook, read_only=True)   # open an Excel file and return a workbook
    
if 'sheet1' in wb.sheetnames:
    print('sheet1 exists')
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #openpyxl #check #worksheet #exists
ADD COMMENT
Topic
Name
2+5 =