Google spreadsheet API

[Virginia_Solomon]

Did anyone try to use the Google spreadsheet API version 3.0 for test report rather then the Microsoft office spreadsheet tools for Labview?

If so, is any tool available for this API?

Virginia

[MoviJOHN]

3.0 is pretty recent, so I don't know, but the following is available as a starting point.

https://decibel.ni.com/content/docs/DOC-9882

[Virginia_Solomon]

Thank you for the answer, it is a type of application for querying a spreadsheet information.

My intention is to show in Labview interface having an ActiveX container with an inserted WebBrowser showing an existing spreadsheet (which is a test result report containing even a multi plot graph). In this container I would like user to modify few cells information.

For more clarification I have to mention that the report is already created. I thought the best is to have the report spreadsheet registered under the Google drive, then to open it and insert it into the browser for being modified and to have it as final version under Google drive, having in this way visibility for my customer.

So here are the steps I would like to complete:

1- To add my spreadsheet report to Google drive (my spreadsheet is created and saved on computer hard drive now)

2- To load a container having the WebBrowser in Labview with the new added report from Google drive

3- To let user to modify the spreadsheet then to exit application

All the above steps I did them manually (not with Labview) and similar I would like to programmatically do them.

Did anyone try this?

Thank you,

Virginia

[TBirkulosis]

According to the documentation for Google API, it looks like you can create a new spreadsheet by uploading an existing spreadsheet using the Google Documents List API:

https://developers.google.com/google-apps/spreadsheets/#creating_a_spreadsheet

Here is an NI Community Example using a web browser in LabVIEW:

https://decibel.ni.com/content/docs/DOC-2042

Hope that helps!