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)
python txt excel的一些简单运用
最新推荐文章于 2024-04-26 01:45:18 发布