readIcdFile.py

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")
	parser.add_option("-s", "--sheet", dest="sheet", default='Main',
                  help="ICD Exel File Sheet ", metavar="SHEET")

	(options, args) = parser.parse_args()
	gen_dir=os.environ["PYGEN"]
	excel_file =options.book_file
	wb=excelIcd(excel_file)
	#wb.getMain()
	get=wb.getSheet(options.sheet)
	print(get['Unit'])