Excel Library for Python 3

[synthia]

What's the best library for manipulating Excel workbook and worksheet? including basic editing and encryption.

[heiner55]

http://www.python-excel.org/

[synthia]

http://www.python-excel.org/

thanks for the heads up. I read the manual and there is no functions to deal with encryption.

[buran]

there is no functions to deal with encryption

"encryption" is general term (i.e. not excel-specific) and you need to be more specific what you want to do:

• Apply some general encryption algorithm on excel file (i.e. in this case it's irrelevant that it's an excel file, it will work on any file all the same).
  
• Password protect excel file using built-in excel functionality, i.e. make the excel file password protected.
  
• Encrypt the content in some/all cell(s) in the excel file
  
• Something else (what?) ...
  

Also there are other packages to work with excel, e.g. xlwings

[synthia]

there is no functions to deal with encryption

"encryption" is general term (i.e. not excel-specific) and you need to be more specific what you want to do:

• Apply some general encryption algorithm on excel file (i.e. in this case it's irrelevant that it's an excel file, it will work on any file all the same).
  
• Password protect excel file using built-in excel functionality, i.e. make the excel file password protected.
  
• Encrypt the content in some/all cell(s) in the excel file
  
• Something else (what?) ...
  

Also there are other packages to work with excel, e.g. xlwings

1.Encrypt excel workbook
2.Decrypt excel protection

[Easluy]

thanks for the heads up. I read the manual and there is no functions to deal with encryption.

I can understand it as adding a password to your Excel.
Anyone(including you)who wants to open or edit Excel will need the correct password (which you set) to access it.Right?
That's what i did on my computer as i have lots of important files on my computer.

[synthia]

thanks for the heads up. I read the manual and there is no functions to deal with encryption.

I can understand it as adding a password to your Excel.
Anyone(including you)who wants to open or edit Excel will need the correct password (which you set) to access it.Right?
That's what i did on my computer as i have lots of important files on my computer.

Adding password and decrypting the file are the two features i am looking for to build this app

[buran]

openpyxl - https://openpyxl.readthedocs.io/en/stabl...ction.html

[heiner55]

@synthia: How get you along ?

[synthia]

@synthia: How get you along ?

still working on it