I’m trying to copy and paste the values of cells containing the formula =IMAGE(Url) in Excel. The result is an image embedded in the cell and no longer linked to the Url.

I am able to do it with pywin32 with the following script:

ws.Range(f"C2:C{last_row}").PasteSpecial(Paste=win32.constants.xlPasteValues)

Given my goal to automate the entire script within an Azure Function App, I understand that pywin32 isn’t the ideal solution? Is there an equivalent of the above script using openpyxl or another library?

Thanks!