09-27-2019 06:28 PM - edited 09-27-2019 06:29 PM
Is there currently a reliable LabVIEW library or method available for the use of dumping information to Google Sheets? I am trying to periodically update a spreadsheet using data that users generate from a test screen in one of my applications.
I have tried the approach (method #3) mentioned here, but am getting an HTML body returned that informs me Google is "unable to open the file at this time."
http://asee-ne.org/conferences/aseene/2018/index.php/aseene/aseene2018/paper/viewFile/321/204
I have seen some other threads but they seem to fizzle out into uncertainty regarding the results.
Thank you
09-27-2019 07:00 PM
There's an API for .NET that you could theoretically use.
By getting the package and all its dependencies I was able to get the DLL to be readable in LabVIEW. Since I went to the effort I went ahead and zipped up the file.
You might need to add a LabVIEW.exe.config file next to your EXE in Program Files to get them to work:
<?xml version ="1.0" encoding="utf-8" ?> <configuration> <startup useLegacyV2RuntimeActivationPolicy="true"> <supportedRuntime version="v4.0.30319"/> <requiredRuntime version="v4.0.30319"/> </startup> <runtime> <loadFromRemoteSources enabled="true" /> </runtime> </configuration>
However, beyond getting it to be loadable in LabVIEW, I didn't try anything else. So I hope you like reading their documentation.