import datetime

import xlrd

from xlrd import open_workbook

class OrderDetails(object):

.format(self.order_date, self.region, self.rep, self.item, self.units, self.unit_cost, self.total))

wb = open_workbook('OrderData.xlsx')

for sheet in wb.sheets():

number_of_rows = sheet.nrows

number_of_columns = sheet.ncols

items = []

rows = []

#skip the first row as it contains headers

for row in range(1, number_of_rows):

values = []

for col in range(number_of_columns):

if(sheet.cell_type(row,col) == 3):

value = (sheet.cell(row,col).value)

try:

value = datetime.datetime(* (xlrd.xldate_as_tuple(sheet.cell(row,col).value, wb.datemode))).strftime('%d.%m.%Y')

except ValueError:

pass

finally:

values.append(value)

else:

value = (sheet.cell(row,col).value)

try:

value = str(int(value))

except ValueError:

pass

finally:

values.append(value)

item = OrderDetails(*values)

items.append(item)

for item in items:

print(item)

print("Accessing single attribut's value (eg. Order Date): {0}\n".format(item.order_date))

print