ワークノート(python excel暗号化)

pythonはexcelに暗号化し、ファイルに読み取り専用に設定し、編集するにはパスワードが必要です.

from xlsxwriter.workbook import Workbook

book = Workbook(r" excel    ")
sheet = book.add_worksheet('ceshi')    #  sheet

# Add separate format for unlocked cells
# unlocked = book.add_format({'locked': 0})
# Protect all cells in your sheet by default
sheet.protect('  ')  
# Write cell, locked by default
sheet.write(0, 0, 'aaa')   #  ， ，  
# sheet.write(row_number, column_number, data, unlocked)
book.close()

#       
def get_file_path(rootdir):
    pathname = []
    for (dirpath, dirnames, filenames) in os.walk(rootdir):
        for filename in filenames:
            # print(os.path.join(dirpath, filename))
            pathname.append(os.path.join(dirpath, filename))
    return pathname