im working on a project in python where i have to collect some filtered date from google sheets and create a new .xlsx file, the problem is that one of the columns on google sheets, has a image formula on it, and i have to translate-it to portuguese so my excel can read-it, but when i create the new .xlsx file and open it, the formula doesn’t work because it has a “@” between the equals sign and the rest of the formula, like this: “=@IMAGE(“URL”)”
since my excel is in portuguese, the “=IMAGE” formula have to be translated to “=IMAGEM” to be able to work, i used .replace and it worked just fine. i read some questions here and it seems that the problem might be on the writing part, some people managed to do it using write_array_formula, others, using just write, but i tried all of this and nothing, i even tried extracting only the link part and rebuilt the formula manualy, but, now, instead of a “@” it has curly brackets between it, like this:excel print
it looks like it is interpreting the curly brackets that i used in python with fString, but im not sure, im sending the code here, hope someone could help me hahaWritting function
Jokers is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.