def read(self, filename):
"""
Return dictionary with key => value pairs
:param filename is the file where the values exist
"""
data = dict()
empno = 0
keys = []
a_row = 0
try:
workbook = load_workbook(filename)
first_sheet = workbook.sheetnames[0]
worksheet = workbook[first_sheet]
for row in worksheet.iter_rows():
record = dict()
row_num = 0
for cell in row:
a_row = cell.row
if 1 == a_row:
keys.append(cell.value)
else:
valid = cell.value
if isinstance(cell.value, datetime):
valid = Validator.xlsx_date(cell.value)
record[keys[row_num]] = valid
row_num += 1
if a_row > 1:
data[empno] = record
empno += 1
# print(data)
result = Validator.save_dict(data)
return result
except PermissionError:
print("Sorry, you don't have enough permissions to access this file")
def test_xlxs_date(self):
""""
Tests static return function, test coverage purposes
"""
expected = "13-12-1994"
test_date = datetime(1994, 12, 13)
result = Validator.xlsx_date(test_date)
self.assertEquals(expected, result)