自動(dòng)提取表格中單號(hào)工具镶苞，作用比如策劃將總結(jié)好鞠评，需要合并的單號(hào)全都放到表格中，可以使用此腳本一鍵提取表格中所有單號(hào)聋涨，單號(hào)會(huì)保存到Txt文本中负乡，然后程序復(fù)制所有單號(hào)，粘貼到合并svn處淹朋，就可以一鍵查找此次需要合并的內(nèi)容钉答，進(jìn)行一鍵合并杈抢，非常方便
image.png
image.png
image.png
#!/usr/bin/python
# -*- coding:utf-8 -*-
import os
import xlrd
import re
import sys
isHaveChar = input('不帶有"SRPG-"輸入y右蹦，其他回車:')
file_ext = ['.xlsx']
current_directory = os.path.dirname(os.path.abspath(__file__))
current_directory = current_directory.replace('\\','/')
data = ","
filenames = ""
needSaveStr = ""
for path in os.listdir(current_directory):
temp_name = re.search("~\$.*?\.xlsx",path)
if temp_name == None:
path_list = os.path.join(current_directory, path) # 連接當(dāng)前目錄及文件或文件夾名稱
if os.path.isfile(path_list): # 判斷當(dāng)前文件或文件夾是否是文件歼捐，把文件夾排除
if (os.path.splitext(path_list)[1]) in file_ext: # 判斷取得文件的擴(kuò)展名是否是.xls、.xlsx
filenames = path_list # 打印輸出
filenames = filenames.replace('\\','/')
xlsx = xlrd.open_workbook(filenames)
sheets = xlsx.sheets()
for table in sheets:
if table.visibility == 0:
row = table.nrows
for i in range(row):
rowdate = table.row_values(i)
for a, b in enumerate(rowdate):
data = data + str(b)
data = data + "\n"
strCount = len(re.findall(r"SRPG-(.+)",data))
for i in range(strCount):
if isHaveChar == "Y" or isHaveChar == "y":
if i + 1 >= strCount:
needSaveStr = needSaveStr + re.findall(r"SRPG-(\d+)",data)[i]
else:
needSaveStr = needSaveStr + re.findall(r"SRPG-(\d+)",data)[i] + " "
else:
if i + 1 >= strCount:
needSaveStr = needSaveStr + "SRPG-" + re.findall(r"SRPG-(\d+)",data)[i]
else:
needSaveStr = needSaveStr + "SRPG-" + re.findall(r"SRPG-(\d+)",data)[i] + " +"
file = open(current_directory + "/lookJira.txt",'w')
file.write(needSaveStr)
