2

I have a .net core 3.1 console app that I need to use to connect to my Google Sheet and export data to a PDF file. I can retrieve all the textual data using service.Spreadsheets.Values.Get(spreadsheetId, $"{spreadsheetName}!C2:C8");

The issue I'm facing is that in cells B2:B8 (those are merged cells) I have an image which I've uploaded from my local folder (Image -> Insert -> Image in cell -> Upload) and I can't seem to retrieve that image. When I call service.Spreadsheets.Values.Get(spreadsheetId, $"{spreadsheetName}!B2:B8"); the Values property returns null

I've tried using =image("IMAGE_URL") in the cell instead of uploading the image but that didn't work as well. Also, the preferred option would be to use the first approach of uploading the image into the cell so I won't have to find where to store my images.

Is this even possible to accomplish?

Liran Friedman
  • 4,027
  • 13
  • 53
  • 96

1 Answers1

1

That's a very popular feature request

However, as of now it has not been implemented yet - given that images in cells are a rather new feature.

There are however some workarounds - either using Apps Script or a vlookup formula, have a look here.

ziganotschka
  • 25,866
  • 2
  • 16
  • 33