查找列表中定义生成代码

Li_凌澜

已于 2022-11-01 17:10:00 修改

阅读量62

点赞数 1

分类专栏：笔记文章标签： python 单片机程序人生

于 2022-11-01 16:48:15 首次发布

本文链接：https://blog.csdn.net/qq_38780508/article/details/127636577

版权

笔记专栏收录该内容

10 篇文章 0 订阅

订阅专栏

简单修改即可使用
| ![在这里插入图片描述](https://img-blog.csdnimg.cn/d8ac0760d9e64c36989738d62bf8fed4.png
| |
|--|--|
| | |

#导入模块
import os
import openpyxl
import time

def fun1():
    #打开需生成的.c
    with open('C:/Users/CQ-rjb-lww/Desktop/a/a.c' , 'w') as f_c:
        wb = openpyxl.load_workbook("C:/Users/CQ-rjb-lww/Desktop/a/1.xlsx")
        sheet = wb['Sheet1'] #指定表格
        f_c.write("//data: " + time.asctime() ) #添加时间搓
        f_c.write("\n\n")
        f_c.write("void GpioInit( void)")
        f_c.write("\n{ \n") 
        f_c.write(" GPIO_Reset(GPIOx); \n") 
        f_c.write(" GPIO_InitTypeDef GPIO_InitStructure; \n") 
        f_c.write(" GPIO_Struct_Init(&GPIO_InitStructure); \n") 
        for rowNum in range( 2 , sheet.max_row + 1):    #循环   
            value1 = sheet.cell(rowNum ,1).value #读取第一列 第n行数据
            f_c.write(" //init gpio" +value1 ) 
            f_c.write("\n") 
            f_c.write(" GPIO_InitStructure.m_Pin = " +value1 ) 
            f_c.write("; \n") 
            f_c.write(" GPIO_InitStructure.m_Speed = " +  sheet.cell(rowNum ,2).value) 
            f_c.write("; \n") 
            f_c.write(" GPIO_InitStructure.m_Mode = " +  sheet.cell(rowNum ,3).value) 
            f_c.write("; \n") 
            f_c.write(" GPIO_InitStructure.m_PullUp = " + sheet.cell(rowNum ,4).value) 
            f_c.write("; \n") 
            f_c.write(" GPIO_InitStructure.m_PullDown = " +  sheet.cell(rowNum ,5).value) 
            f_c.write("; \n") 
            f_c.write("\n")
            bit_set = sheet.cell(rowNum ,6).value
            if value1 == "GPIO_1": #判断gpio组
                f_c.write(" GPIO_Configuration(GPIOA,&GPIO_InitStructure); \n") 	
                if bit_set != "NULL" :
                    f_c.write(" GPIO_Set_Output_Data_Bits(GPIOA, "+value1+", "+ bit_set +" ); \n")    	
            else:
                f_c.write(" GPIO_Configuration(GPIOB,&GPIO_InitStructure); \n") 
                if bit_set != "NULL" :
                    f_c.write(" GPIO_Set_Output_Data_Bits(GPIOB, "+value1+", "+ bit_set +" ); \n")
            f_c.write("\n")
        f_c.write("}")
        f_c.close()#关闭文件
    myname=input("修改成功 任意键退出：")

def main():
    fun1()
    
if __name__=='__main__':
    print("main runing...")
    main()