python利用xlwings写入一行或一列Excel数据

import xlwings as xw


def write_col(io, sheet=0, col=‘A1‘, data=None):
    """
    写入一列数据
    :param io: Excel文件
    :param sheet: sheet，int或者str类型
    :param col: 哪一列，如:‘A1‘
    :param data: 要写入的数据，list类型
    :return:
    """
    wb = xw.Book(io)
    if isinstance(sheet, str):
        sht = wb.sheets(sheet)
    else:
        sht = wb.sheets[sheet]
    sht.range(col).options(transpose=True).value = data
    wb.save()
    wb.app.quit()

def write_row(io, sheet=0, row=‘A1‘, data=None):
    """
    写入一行数据
    :param io: Excel文件
    :param sheet: sheet，int或者str类型
    :param row: 哪一行，如:‘A1‘
    :param data: 要写入的数据，list类型
    :return:
    """
    wb = xw.Book(io)
    if isinstance(sheet, str):
        sht = wb.sheets(sheet)
    else:
        sht = wb.sheets[sheet]
    sht.range(row).value = data
    wb.save()
    wb.app.quit()