from datetime import date import sys,os from optparse import OptionParser from GenDevice.excelIcd import excelIcd # Read the ICD excel file if __name__=="__main__": parser = OptionParser() today = date.today() parser.add_option("-f", "--file", dest="book_file", help="ICD Exel File ", metavar="FILE") (options, args) = parser.parse_args() gen_dir=os.environ["PYGEN"] excel_file =options.book_file wb=excelIcd(excel_file) #wb.getMain() get=wb.getSheet("Main") print(get)