python读取excelxlsx,写入excel

# -*- coding: utf-8 -*-

import os
import openpyxl
import xlrd


def import_ras():

    file_path = "config/RSA.xlsx"
    exists_flag = os.path.exists(file_path)
    try:
        if exists_flag:
            print("file exists")
        else:
            raise Exception("excel file not exists")
    except Exception :
        print("excel file not exists,please once again ")
    rsa_public_key = []
    file_name_args = []
    my_read_workbook = xlrd.open_workbook(file_path)
    my_sheet = my_read_workbook.sheet_by_index(0)  # 通过索引顺序获取。
    raws = my_sheet.nrows
    for i in range(1, raws):
        name = my_sheet.cell(i, 2)

        file_name = 'pay-'+name.value+'.pubkey'
        file_name_args.append(file_name)
    for j in range(0, len(file_name_args)):
        public_file_name = file_name_args[j]
        with open("config/rsa_dir/"+public_file_name, 'r') as file:
            public_key = file.readline()
            rsa_public_key.append(public_key)
    print(rsa_public_key)
    # 参数说明: formatting_info=True 保留原excel格式
    workbook = openpyxl.load_workbook(file_path)
    worksheet = workbook.worksheets[0]
    for raw in range(len(rsa_public_key)):
        worksheet.cell(raw + 2, 8, rsa_public_key[raw])
    workbook.save(file_path)


import_ras()

转载于:https://www.cnblogs.com/keepMoveForevery/p/11358283.html