LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Using LabVIEW to insert rows to Google Sheets

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 

0 Kudos
Message 1 of 2
(2,923 Views)

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.

0 Kudos
Message 2 of 2
(2,898 Views)