4

have dataframe how to encrypt it with a password

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) 

are there any pandas options to add a password excel or csv which is created with data frame.

So that a password is required to open that csv or excel with GUI.

Tried this:

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')

But when i open it. the file is opening without any prompt of password . tried in google sheets and libre office

Found out that : Openpyxl's WorkbookProtection only works for preventing modifying sheets that are there.

os: Linux

yopmuios
  • 41
  • 3

0 Answers0