Python excel写入

 exce单元格l写入

 #coding=utf-8

import openpyxl

PATH2 = 'E:\\AUTO\\pythonProject\\data\\test.xlsx'    #excel表
sw = "hello Python"
hw = "Py4"
fw = "3.5.3183919"
pdb = "50FAD4Bfrfr4"


#这段代码加载现有的 Excel 文件并获取活动工作表。
wb = openpyxl.load_workbook(PATH2)
ws = wb.active


#在指定的单元格写入新数据，使用单元格地址（例如 'A1'）直接指定要更新的数据。
ws['B18'] = hw
ws['B19'] = sw
ws['B20'] = fw
ws['B21'] = pdb

#保存文件：
wb.save(PATH2)

 判断单元格是否为空，为空写入，否则不写

 #coding=utf-8

import openpyxl

PATH2 = 'E:\\AUTO\\pythonProject\\data\\test.xlsx'    #excel表
sw = "hello Python"
hw = "Py4"
fw = "3.5.3183919"
pdb = "50FAD4Bfrfr4"

#从送样需求表中取出hw,sw,fw,pdb的值，并返回list，判断hw,sw,fw,pdb是否为空
def q_dev_info(PATH2):
    try:
        workbook = openpyxl.load_workbook(PATH2)
        sheet = workbook['Sheet1']

        cell_hw = sheet.cell(row=18, column=2).value
        cell_sw = sheet.cell(row=19, column=2).value
        cell_fw = sheet.cell(row=20, column=2).value
        cell_pdb = sheet.cell(row=21, column=2).value

        cell_info = [cell_hw, cell_sw, cell_fw, cell_pdb]
        return cell_info
        
    except IOError as e:
        print(u"文件信息错误，具体信息：\n{e}")
        return None
    finally:
        # 最后记得关闭工作簿，无论是否发生异常
        if 'workbook' in locals():
            workbook.close()
            print u"excel 已经关闭"

#写入hw,sw,fw,pdb参数，
def w_sheet(hw,sw,fw,pdb,PATH2):
    try:
        #这段代码加载现有的 Excel 文件并获取活动工作表。
        wb = openpyxl.load_workbook(PATH2)
        ws = wb.active


        #在指定的单元格写入新数据：
        ws['B18'] = hw
        ws['B19'] = sw
        ws['B20'] = fw
        ws['B21'] = pdb
        #使用单元格地址（例如 'A1'）直接指定要更新的数据。

        #保存文件：
        wb.save(PATH2)
    except IOError,e:
        print u"文件信息错误,具体信息：\n%s"%e
    finally:
        # 最后记得关闭工作簿，无论是否发生异常
        if 'wb' in locals():
            wb.close()
    
# Fetch cell values
cell_list = q_dev_info(PATH2)


# If cells are empty, update them
if not all(cell_list):
    try:
        w_sheet(hw,sw,fw,pdb,PATH2)
        print hw,sw,fw,pdb
    except IOError as e:
        print(u"保存文件错误：\n{e}")