python txt excel的一些简单运用

import os
import urllib
from urllib import parse

import xlrd
import xlsxwriter
import xlwt

data = []
def getpath(rootpath):
    '''
    :param rootpath: 根目录
    :return:path(string)，dir(list)，filelist(list)
    '''

    for path ,dir, filelist in os.walk(rootpath):
        #print(dir)

        # for dir_list in dir:
        #     print(dir_list)
         for file in filelist:
             if file.endswith('1.jpg'):
                 file_path = os.path.join(path,file)
                 #print(file_path)
                 data.append(os.path.join(path,file))
         #print(data)



def write_file_path_to_txt(new_txt):
    """

    :param new_txt: 将原始的文件路径写到该文件中
    :return:
    """
    with open(new_txt,'w+') as file: #w--覆盖写入；a--追加写入
        for item in data:
            file.write(item+'\n' )

        file.close()

def write_file_path_to_excel(excel):
    workbook = xlsxwriter.Workbook(excel)#创建一个excel文件
    worksheet = workbook.add_worksheet()

    style = workbook.add_format({
        "fg_color": "white",  # 单元格的背景颜色
        "bold": 1,  # 字体加粗
        "align": "center",  # 对齐方式
        "valign": "vcenter",  # 字体对齐方式
        "font_color": "blue"  # 字体颜色

    })

    #for item in data:
    i=0
    for i in range((len(data))):
        rowA = "A" + str(i+1)
        rowB = "B" + str(i+1)

        worksheet.write(rowA,data[i])

        worksheet.write(rowB,'=HYPERLINK("%s")'% data[i],style)#制作超链接 直接查看文件
        #worksheet.write(rowB,"2",style)
        i +=1
    workbook.close()


def read_data_from_excel(excel):
    readbook = xlrd.open_workbook(excel)
    sheet = readbook.sheet_by_name("Sheet1")
    for i in range((len(data))):
        num = sheet.row_values(i)
        sheet.write(1,1,num)
        #print(num)

def string_to_url(new_txt):
    string = open(new_txt)
    lines = string.readlines()
    for item in lines:
        url_code_naem = urllib.parse.quote(item)
        print(url_code_naem)

def modify_path(new_txt,last_txt):
    """

    :param new_txt:
    :param last_txt: 根据需求获得最终的路径格式，并写到该文件中
    :return:
    """
    data1= []
    read_txt = open(new_txt)
    lines = read_txt.readlines()
    for line in lines:
        if "/L_Outdoor_Back/" in line:
            data1.append(line)

    with open(last_txt,"w+") as file:
        for item in data1:
            file.write(item)












if __name__ == "__main__":
    rootpath = r'D:\test_aggregate_merge_random_EXP'
    getpath(rootpath)
    #new_txt = r'C:\xiongjianhua_vendor\桌面\liveness_result_c2_1.20.txt'
    #write_file_path_to_txt(new_txt)
    #last_txt = r'C:\xiongjianhua_vendor\桌面\liveness_result_c2_L_Outdoor_Back_1.20_0528.txt'
    #modify_path(new_txt, last_txt)
    #string_to_url(new_txt)
    excel = r'C:\xiongjianhua_vendor\桌面\1.xlsx'
    write_file_path_to_excel(excel)
    #read_data_from_excel(excel)