python基础之文件表格读取

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

实现功能：提取表格某一列的值。

所用库：xlrd

打开表格的函数

def open_excel_file(filename,sheet_num=0):

    xlsfile = filename

    book = xlrd.open_workbook(xlsfile)

    sheet = book.sheet_by_index(sheet_num)

    nrows = sheet.nrows

    ncols = sheet.ncols

    return sheet,nrows,ncols

读取表格的函数

def read_excel_file(filename,read_col = 0):

    sheet,nrows,ncols = open_excel_file(filename)

    data_list = []

    for i in range(1,nrows-1):

        data = sheet.cell_value(i,read_col)

        data_list.append(data)

    return data_list

主函数

def main():

    filename1 = 'phone.xlsx'

    data_list1 = read_excel_file(filename1,read_col = 9)

    data_list2= read_excel_file(filename1,read_col = 14)

    data_list3= read_excel_file(filename1,read_col = 17)

    left_data = []

    for item in data_list1:

        item=""+str(item)[:-2]

        if(item.isdecimal()):

            left_data.append(item)

    for item in data_list2:

        item=""+str(item)[:-2]

        if(item.isdecimal()):

            left_data.append(item)

    for item in data_list3:

        item=""+str(item)[:-2]//由于这个值小数点后面保留一位，但只需要整数部分，所以取字符串的开头到倒数第二位就够了。

        if(item.isdecimal()):

            left_data.append(item)

    print(left_data)

    with open("phone.txt","w",newline="") as f:

        for i in left_data:

            f.write(i)

            f.write("\r\n")