Announcement

Collapse
No announcement yet.

Script to write device status to google spreadsheet.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Script to write device status to google spreadsheet.

    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

  • #2
    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.
    Mike____________________________________________________________ __________________
    HS3 Pro Edition 3.0.0.548

    HW: Stargate | NX8e | CAV6.6 | Squeezebox | PCS | WGL 800RF, Rain8Net+ | RFXCOM | QSE100D | Vantage Pro | Green-Eye | X10: XTB-232, -IIR | Edgeport/8 | Way2Call | Ecobee3

    Comment

    Working...
    X