Simple utility command line tool to list the sheet names of an Excel workbook.

xlsx_sheetnames.py

"""
Simple utility command line tool to list the sheet names of an Excel workbook.
"""
import argparse
from xlrd import open_workbook


def get_args():
    """This function parses and return command line arguments"""
    parser = argparse.ArgumentParser(description='List sheetnames in Excel workbook.')
    parser.add_argument('filename', metavar='f', type=str, help='Filename')
    args = parser.parse_args()
    return args


if __name__ == '__main__':
    wb = open_workbook(get_args().filename)
    for sheet in wb.sheets():
        print(sheet.name)