Write in Excel using Python

Question

I am using python for automation, where I need to set a series of information in the spreadsheet.

I understand I need 2 for, one to traverse a row and the other the column, I need to define a limit because each row and column has to go to j. I wanted to know how the information in the spreadsheet within these 2 for. I know how to set but not inside a for.

I’m using library openpyxl import load_workbook

The code is like this:

max_linha = sheet.max_row

max_coluna = sheet.max_column

for i in range(1,max_coluna + 1)

 for j in range(1,max_linha + 1)

For setar I do so:

sheet[A1] = "Ok"

It would be something like?

sheet["A"][i][j] = variavel