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]