C
C
CyberW2015-10-31 20:12:50
API
CyberW, 2015-10-31 20:12:50

Is it possible to upload an MS Excel file to Google Drive via the API and share it in Google Spreadsheets?

The task arose to implement, through the Google APIs Client Library for PHP library, uploading a file to Google drive in MS Excel format and sharing it in Google Spreadsheets in order to display it in public access for visual review, respectively, with read-only access, so that you can was to see the contents of the Excel file, including the addresses of the columns and rows.
This can be done manually through the web interface, but the task is to do it automatically with getting a link to display in the frame, as you want it to look like
709350961aa949cfa9f061b4199fecd6.jpg
HTML code, an example of a real frame with an xls file

<iframe src="https://docs.google.com/spreadsheet/pub?key=0AkC6q_6fzB6WdDNGeTk2X1RGNzBJLVhaaWpld19FUlE&gid=4&range=B1%3AE11&widget=true&headers=true" height="500px" width="100%" frameborder="0" scrolling="yes" allowtransparency="true"></iframe>

The file can be uploaded to Google Drive, but it’s not clear how to share it in Google spreadsheets, so the question arose, is it even possible to do this through this library? Maybe someone has experience on this issue.
To work with the library, a service account with a key file is used.
We are talking about this library developers.google.com/api-client-library/php
Thanks in advance for your answers!

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question