Python脚本1

Ajunyu

已于 2022-12-15 22:51:14 修改

阅读量152

点赞数

分类专栏： Python 文章标签： python

于 2022-12-12 22:29:53 首次发布

文章版权归Ajunyu所有，转载请注明

本文链接：https://blog.csdn.net/Ajunyu/article/details/128294300

版权

Python 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

import os
import openpyxl
import datetime

Date = datetime.datetime.now().strftime("%Y%m%d")
Version12 = '1001'
Version11 = '1000'
Dir = r'E:\Python\test\TestSDK'
FirDir = os.listdir(Dir)

def ModifyExcel(Version, Board):
    print(Version,Board,ExcelPath)

i = 0
while i < len(FirDir):
    DirPath = Dir + '\\' + FirDir[i]
    SecFile = os.listdir(DirPath)
    SecFile.remove('camek_make.make')
    SecFile.remove('part.xml')
    for a in range(0, len(SecFile)):
        ExcelPath = DirPath + '\\' + SecFile[a]
        if i == 0:
            ModifyExcel(Version11, FirDir[0])
        if i == 1:
            ModifyExcel(Version12, FirDir[1])
        if i == 2:
            ModifyExcel(Version12, FirDir[2])
    i += 1

第一次修改

import os
import openpyxl
import datetime

Date = datetime.datetime.now().strftime("%Y%m%d")
Version12 = '1001'
Version11 = '1000'
Dir = r'E:\Python\test\TestSDK'
FirDir = os.listdir(Dir)

def ModifyExcel(Version, Board):
    print(Version,Board,ExcelPath)

i = 0
while i < len(FirDir):
    DirPath = Dir + '\\' + FirDir[i]
    SecFile = os.listdir(DirPath)
    SecFile.remove('camek_make.make')
    SecFile.remove('part.xml')
    for a in SecFile:
        ExcelPath = DirPath + '\\' + a
        if i == 0:
            ModifyExcel(Version11, FirDir[0])
        elif i == 1:
            ModifyExcel(Version12, FirDir[1])
        elif i == 2:
            ModifyExcel(Version12, FirDir[2])
    i += 1