def set_xls_range2(sheet, rows, start): rows = autils.make_rec(rows) c_end = start[0] + len(rows[0]) r_end = start[1] + len(rows) xi = nums2xlsIndices([start, [c_end, r_end]]) sheet.range(xi[0], xi[1]).value = rows
def set_xls_range3(sheet, rows, empty_row): rows = autils.make_rec(rows) width = len(rows[0]) height = len(rows) c_start = 1 r_start = empty_row[0] empty_row[0] += height c_end = c_start + width - 1 r_end = r_start + height - 1 xi = nums2xlsIndices([[r_start, c_start], [r_end, c_end]]) sheet.range(xi[0], xi[1]).value = rows