[openpyxl] Set the locking property of all cells

[BelleroDev]

I'm dealing with cell locking (unlocking) using openpyxl module.

What I need to do is to set the locking property of all cells of a workbook. The openpyxl "standard" iterators are not going throught all the cells (only the ones that have values - not the whole workbook), and forcing that using the iter_rows() method is leading to time and memory issues.

import openpyxl

def reset_locking(file):

	workbook = openpyxl.load_workbook(file)
	
	# first implementation
	for sheet in workbook:
            for row in sheet.rows:
                for cell in row:
                    cell.protection = openpyxl.styles.Protection(locked = True)
	
	#second implementation
	#max data are related to Exel version >= 2016
	for sheet in workbook:
            for row in sheet.iter_rows(min_row=1, min_col=1, max_row=1048576, max_col=16384):
                for cell in row:
                    cell.protection = openpyxl.styles.Protection(locked = True)

Is there a different (or smarter) way to do it?
Maybe defining a style and applying it to all the cellls could help?

Based on what I understood from openpyxl documentation, seems that this approach (modifying property or styles of a cell range in one shot) is not feasible... but maybe I missed something.

Or are there any different modules that I could use?

Any kind of help is really appreciated. Thanks.

BelleroDev

[buran]

By default Lock property of a Cell is set to True (checked in Excel)
Unless it was set to False before that why do you need to iterate over every cell? Or am I missing something in your question?

[BelleroDev]

By default Lock property of a Cell is set to True (checked in Excel)
Unless it was set to False before that why do you need to iterate over every cell? Or am I missing something in your question?

Yes, you're right. But I need to process excel files where the locking status of some cells have been already changed to False.
My application needs first to reset the cell locking to True and than do the other stuff. That preliminary step of resetting can be done also manually in Excel before running my app (it will be not too much effort for my users), but I was trying to find a way to do it automatically.

[Pedroski55]

The openpyxl "standard" iterators are not going throught [sic] all the cells (only the ones that have values - not the whole workbook)

Why do you want to lock cells that do not have any value in them?

Post a sample of your XL file. What are you trying to do?