CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets-api
Jeremy
Jeremy

Reputation: 31

can you open a excel file directly with google sheets api

how can I open a excel file directly with google sheets api

Upvotes: 1

Views: 5433

Answers (2)

Sujay Phadke
Sujay Phadke

Reputation: 2196

Well you can read a .xlsx file as a binary blob from Google Apps Script API. So if you want to read the xlsx formatted file and do all the work of interpreting it yourself, then sure you can. But that's essentially writing the entire MS Excel interpreter in Google Script.

Upvotes: 1

Bardy
Bardy

Reputation: 2170

Not to my knowledge, however, using the Drive API you can upload and convert an Excel file to Sheets format automatically. This could then be used by the Sheets API. This may or may not work as a substitute in your use case.

Upvotes: 1

Related Questions