Search the Community
Showing results for tags 'google sheets'.
I was working on this app over the past year. Happy to make it available under a "Non-Profit Open Software License" Allows any labview application on you computer to utilise your google drive and google sheets. This is achieved through a labVIEW executable (GDLVserver), that gets access to Google drive/sheets with a client secret json file, with OAuth 2.0 authentication. Other labVIEW applications can communicate with the executable, and request google drive and sheets function requests. A LabVIEW client library is included to add to your project files. The GDLVserver will work in the background and can be hidden. I used an executable to handle all the Google Drive API commands, to lessen the file dependency in projects, and also to aim to stabilise the drive connection which has a tendency to freeze on connection. This is still a problem, but is rare, and is unavoidable as it is on the google API side. Once connected the connection is maintained flawlessly. I've run apps for days with data writing data every second with no issues. There is a quota on function calls per user per API, 100 calls per 100 seconds. All code is written in LabVIEW 2015 SP1 API: Google.Apis.Drive.v3.dll, Google.Apis.Sheets.v4.dll Background: Origin of code maggie-otoole Modification Actions: All VI's re-written .NET testAuth.dll replaced with JNET.dll New VI created for more API features All library references updated to .net45 Google API widget, LabVIEW executable created Google Drive Functions: Get folder names / ID's, in root folder Get folder names / ID's, in specific folder Get file names / ID's, in specific folder Create new sheet Google Sheet Functions: Append 2D array data Insert 2D array data Read 1D array data Folders content: GDLVserver: includes .exe, data folder with .lib references (you will need to place your JSON file here), and an icon folder GDLVclient: includes a LabVIEw project, GDLVclient library, and example VI's Requirements: a LabVIEW 2015 SP1 32bit runtime engine is required to run the executable (here) a google email account Follow instructions in the "how do" pdf, (enable API's, create JSON, download & rename, run server (admin), try examples) GDLVserver.zip GDLVclient.zip GDLV License.pdf GDLV how do.pdf