-1

How to getValue() of Cell "A1" in an XLSX attachment (of sheet 1) received in Gmail by app script running from a google sheet? The daily gmail (with XLSX attachment) is from a particular email ID with a particular subject.

I tried various examples available. Making some silly mistake and not able to crack it.

arul selvan
  • 616
  • 4
  • 17
  • If you are looking for specific implementations, ask specific questions. Post the code you tried, the code you found somewhere else that is converting excel files to google sheets. In this way you will also get better, faster and more specific answers but you will also learn down the road. – Marios Nov 11 '20 at 11:47

1 Answers1

0

getValue() is a method of the class SpreadsheetApp, to be used on Google spreadsheets

You cannot use it on Excel files.

If you want to use a method of SpreadsheetApp or the Google Sheets API on your file, you need to convert it first from Excel to Google Sheets.

See here how to convert an Excel file from a Gmail attachment to a Google sheet.

ziganotschka
  • 25,866
  • 2
  • 16
  • 33