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")

 

读取第9，14,17列的数据并存入phone.txt中。