def y_axis(sheet, range, data): M = row_values(sheet, range) for R in M: if len(R) != 1: raise ValueError if _is_garbage(data[1]): _y_axis_garbage_before_type(M, data) else: _y_axis_type_before_garbage(M, data)
def _data_values(sheet, values_range): cells = row_values(sheet, values_range) nrows = len(cells) ncols = len(cells[0]) for j in range(0, ncols): for i in range(0, nrows): if cells[i][j] == u"1.0": cells[i][j] = u"si" cells[i][j] = cells[i][j].lower() return cells
def _data_headers(sheet, range, separator=u": "): cells = row_values(sheet, range) _edit_inplace(cells) _compress(cells, separator) return cells[0]