Python读取txt文档并清理空行存入Excel

【方法一】

file1 = open('old.txt', 'r', encoding='utf-8') # 打开要去掉空行的文件
file2 = open('new.txt', 'w', encoding='utf-8') # 生成没有空行的文件

for line in file1.readlines():
if line == '\n':
line = line.strip("\n")
file2.write(line)
print('输出成功....')
file1.close()
file2.close()

在spyder(python3.7) 测试有效

【方法二】

with open('old.txt','r',encoding = 'utf-8') as fr,open('new.txt','w',encoding = 'utf-8') as fd:
for text in fr.readlines():
if text.split():
fd.write(text)
print('输出成功....')

file1.close()
file2.close()

去掉txt文档中的空行

Parser_version = 'version_1.0'
print(Parser_version)

items = os.listdir(".")
w = openpyxl.Workbook()
table = w.create_sheet(title="password")  # 在将写的文件创建sheet

with open('YDP.txt', 'r', encoding='utf-8') as fr, open('YDP1.txt', 'w', encoding='utf-8') as fd:
    for text in fr.readlines():
        if text.split():
            fd.write(text)
    print('输出成功....')

afteritems = os.listdir(".")
for i in range(len(afteritems)):
    if os.path.isfile(afteritems[i]) and afteritems[i].startswith('YDP1.txt'):
        file_object = open(afteritems[i], "r", encoding='UTF-8')
        for (num, line) in enumerate(file_object):
            # print("第 %d 行:" % num + line)

            # 读取每一行的内容，根据个人内容及需求将内容写入excelName表格中
            ssid_pass = line.split('        ')
            # print(ssid_pass)
            ssid = ssid_pass[0].split(";")
            # print(ssid)
            table.cell(num + 1, 1, ssid[0])
            table.cell(num + 1, 2, ssid[1])  # num + 1 表示第几行，1 表示第几列
            table.cell(num + 1, 3, ssid[2])
            table.cell(num + 1, 4, ssid[3])
            table.cell(num + 1, 5, ssid[4])
        break
w.save(time.strftime('%Y_%m_%d_%H_%M_%S', time.localtime(time.time())) + " YDP.xls")  # 根据时间来保存文件名