Пример #1
0
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
Пример #2
0
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