Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

IMP : Openpyxl by default making all the cells protected for a protected worksheet while reading an existing worksheet #54

Open
Mtushar22 opened this issue May 14, 2024 · 0 comments

Comments

@Mtushar22
Copy link

Steps to replicate :

  1. Create a workbook with a protected sheet .
  2. Make only certain cells of the worksheet protected .
  3. Load this worksheet using openpyxl load_workbook .
  4. Write data to the protected sheet and save it as a new file .
  5. Once you open the new file , in the protected sheet you will observe all cells have now become protected and you can't edit the cells which were unprotected earlier
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant