我有一个数据框,如何使用密码对其进行加密
import pandas as pd
# intialise data of lists.
data = {'Name':['Tom', 'nick', 'krish', 'jack'], 'Age':[20, 21, 19, 18]}
# Creating DataFrame
df = pd.DataFrame(data)
有没有pandas选项可以在使用数据框创建的Excel或CSV中添加密码。
这样,在GUI中打开该csv或excel时就需要密码。
尝试过以下方法:
df.to_excel('123.xlsx')
from openpyxl import Workbook
from openpyxl import load_workbook
test_spreadsheet = "123.xlsx"
wb = load_workbook(test_spreadsheet)
wb.security.workbookPassword = "password"
from openpyxl import Workbook
from openpyxl import load_workbook
test_spreadsheet = "123.xlsx"
wb = load_workbook(test_spreadsheet)
ws = wb.worksheets[0]
ws.protection
ws.protection.set_password('test')
wb.save('12344.xlsx')
from openpyxl import load_workbook
wb = load_workbook(filename = '123.xlsx')
wb.security.workbookPassword = 'test'
wb.security.lockStructure = True
wb.save('123_password.xlsx')
wb = Workbook('123.xlsx')
ws = wb.worksheets[0]
ws.protect('abc123.xlsx')
但是当我打开它时,文件没有提示输入密码就打开了。尝试在Google表格和Libre Office中打开也是如此。
发现:Openpyxl的WorkbookProtection只能防止修改那些已经存在的工作表。
操作系统:Linux
xlsxwriter
? - S3DEVwb = Workbook('123.xlsx') ws = wb.worksheets[0] ws.protect('abc123.xlsx')
但是出现了list index out of range
的错误提示。 - yopmuios