openpyxl icon indicating copy to clipboard operation
openpyxl copied to clipboard

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

Open Mtushar22 opened this issue 9 months ago • 0 comments

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

Mtushar22 avatar May 14 '24 09:05 Mtushar22