I have a spreadsheet that is opened via the package openpyxl and I want to apply a specific formula to every cell in row 14 “N” down to the bottom of my current table but make the formula results apply on open of the file because at the moment it populates the cells as required however I have to double click on the cell and hit enter to make the results appear on every row.

I am facing incorrect max_row result though there is no cell value. When cell format is in normal or general format, Max_row is giving me correct result based on cell containing data.

Any suggestions? If I ever the row height in openpyxl, delete_rows will appear to remove the rows, but when I save and open in Excel, the rows are empty but not all row information is removed. The scroll bar still scrolls to where the last row was prior to deleting. So “ghosts” of the empty rows remain. Sample code:

I am trying these lines

Problem Description
I have two files: input.csv containing data and template.xlsx containing styles. I’m trying to create output.xlsx using these files.

I have anEexcel file and need to get data from rows and columns and make a JSON text from it. I use openpyxl.

I’m new to openpyxl and already stuck with a problem. Also English is not my native language so sorry for mistakes. I have an excel file and need to get data from rows and columns and make a json text from it. I use openpyxl for my own reasons and another library won’t do for me.

I’m manipulating data from an Excel data sheet 87MB large using openpyxl and pandas but each one takes 10-30 minutes long.

First time working with openpyxl.
Created very simple spreadsheet tilted ‘example.xlsx’
enter image description here
tried to run this and get following error
enter image description here

I have this code where i want to take the value in the cell and use it in a function. But the problem is there is a formula in said cell. How would I evaluate the cell to get the value and not the formula.
ws[cell2] = f"{Func(ws[cell1].value)}
So cell 1 has a formula in it and i want to have the value that, that cell returns for example. =D1/F1 I want the value not the formula back.