0

I want to create a resource for a browser game and I need to export a ton of character portraits. The url of those portraits is automatically generated with character's id, so you can just load them with =image("url"), like this :

=image(concat("thegame.com/rendern/portraits/", A2, ".png"))

The problem is that it doesn't store loaded images and has to reload them every time, which will probably result in me getting banned.


Is there a way to make it load once and store somewhere? I'm going to access the spreadsheet exclusively through Google Docs.

  • Welcome. Please add a brief description of your search/research efforts as is suggested on How to Ask. – Rubén Sep 26 '19 at 15:49
  • Also please add more details about what you are expecting, like if you need the file to be available online all the time or if exporting to PDF/ODF/XLSX/HTML will work for you. – Rubén Sep 26 '19 at 15:55
0

First, you will not be get banned for using a built-in function like IMAGE(url) as the request is made from Google Servers and it's made anonymously. Anyway, if you want to "freeze" the images on your spreadsheet try the following

  1. Select the range having the IMAGE(url) formulas
  2. Copy
  3. Paste as value only

For the above procedure you could use the contextual menu (right clic), the Edit menu, or the Google Sheets keyboard shortcuts.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.