print('Using xlrd:')
wb = xlrd.open_workbook('cell_formula_test.xlsx')
ws = wb.sheet_by_name('Sheet1')
for i in range(ws.nrows):
    for j in range(ws.ncols):
        if ws.cell_type(i, j) != xlrd.XL_CELL_EMPTY:
            print('  (%d, %d):%s:%s' % (i, j, ws.cell_type(i, j), ws.
                cell_value(i, j)))
Reading a cell value that contains a formula returns 0.0 when using xlrd