python之表格操作

读取表格内容

一：方法一

 

def get_excelData(filename,sheetName,startcell,endcell,requestRow,responseRow):
    '''
    :param filename: 文件名
    :param sheetName: sheet名
    :param startcell: 开始行
    :param endcell: 结束行
    :param requestRow: 请求参数列
    :param responseRow: 返回参数列
    :return:
    '''
    dataList = []

    file_path =os.path.dirname(os.path.dirname(__file__))+f'/data/apiData/{filename}'
    workbook = xlrd.open_workbook(file_path,formatting_info=True)
    workSheet = workbook.sheet_by_name(sheetName)
    for cell in range(int(startcell)-1,int(endcell)):
        requestData = workSheet.cell(cell,int(requestRow)-1).value
        responseData = workSheet.cell(cell,int(responseRow)-1).value
        dataList.append((json.loads(requestData),json.loads(responseData)))
    return dataList

二：方法二

def excelData(filename,sheetName,startcell=None,endcell=None):
    '''
    
    Args:
        filename: 文件名
        sheetName: sheet名字
        startcell: 开始行
        endcell: 结束行

    Returns:

    '''
    dataList = []
    file_path =os.path.dirname(os.path.dirname(__file__))+f'/data/apiData/{filename}'
    workbook = xlrd.open_workbook(file_path,formatting_info=True)
    workSheet = workbook.sheet_by_name(sheetName)
    if startcell and endcell:
        for i in range(int(startcell) - 1, int(endcell)):
            date = workSheet.row_values(i)
            dataList.append(date)

    else:
        sum_cell = workSheet.nrows
        for i  in range(sum_cell):
            date = workSheet.row_values(i)
            dataList.append(date)
    return dataList