Script to write device status to google spreadsheet.

[francrouge]

Hi all

I'm looking to make a script to be able to export data from a device to a google spreadsheet.

I'm monitoring my KwH consomption every day.


So is there someone able to tell me if its possible to take the device statusof my consomption and send it to a google spreadsheet.


thank you all

[Uncle Michael]

I am not aware of a way to write directly to a xlsx file, but you can certainly write to a delimited text file, a csv file, for example. It should then be possible to use an Excel macro to import the contents of the csv, but it's been many years - and many generations of Excel - since I last did that sort of thing, and I'm sure the process has evolved significantly in the interim.