Script to read and show sheet of your excel file

excel_checker.py

#!/usr/bin/python3
#excel_checker.py ->Script will read your excel file

import sys
import openpyxl
from os import getcwd

if len(sys.argv) > 2 :
    a = getcwd()  #getcwd() to find out current directory
    print("Your current directory is : ",a)
    sys.exit("So Plese provide one argument -> Name of your excel file in current directory!")

def workbook():
    wb = openpyxl.load_workbook(sys.argv[1])
    #openpyxl.load_workbook() function takes in the filename 
    #and returns a value of the workbook data type
    print(type(wb))                          #return Workbook object which represent your excel file
    list1 = wb.get_sheet_names()
    print(list1)
    sheet = wb.get_sheet_by_name('Sheet1')
    print(sheet)                         # 
    print(type(sheet))
    print(sheet.title)
    anothersheet = wb.get_active_sheet()
    print(anothersheet)   
workbook()