批量提取txt前七个字符

Question

工作中遇到了一些问题，写代码咱也不会

前七个字符是车牌号，有好多txt，需要把车牌号导出来弄一个表

Answer 1

import os
import openpyxl

path = r"E:/xxx" #目录路径
FileNames=os.listdir(path)
li = [["文件名","车牌号"]]
for fn in FileNames:
    if fn.endswith(".txt"):
        afn=os.path.join(path,fn)
        with open(afn, 'r', encoding='utf-8') as fileObj:
            txt = fileObj.read(7)
            li.append([fn,txt])
print(*li)

wb = openpyxl.Workbook()
ws=wb.active
ws.title = "车牌号表"
for each in li:
    ws.append(each)
wb.save(r"车牌号表.xlsx")

遍历文件所在的目录，用fileObj.read(7)对所有txt文件读取前七个字符
如有帮助，望采纳！谢谢! 点击我这个回答右上方的【采纳】按钮