0

I'm receiving daily .xlsx files sent to my Gmail account via attachments and I'm trying to use apps script to parse the file into text so I can reformat it and eventually upload arrays to BigQuery. I've seen some questions similar that convert the Excel files to Google Sheets and I am NOT trying to do that. I simply want to be able to see the text in apps script similar to a parsing CSV file.

I tried parsing like a CSV and found that the text was completely random.

Nithin Reddy
  • 1
  • 1
    Does this answer your question? [Converting Google Spreadsheet to Excel with AppScript and send it via email](https://stackoverflow.com/questions/32356863/converting-google-spreadsheet-to-excel-with-appscript-and-send-it-via-email) – liquidkat Apr 05 '22 at 18:58
  • It's seems converting the excel to spreadsheet then get the values is the only way to achieve that. Parsing csv would be the best way to do that. I'm not sure why you getting completely random data from parsed csv, I have multiple files parsed on daily basis, and they work fine. – liquidkat Apr 05 '22 at 19:02

0 Answers0