NGRP / node-red-contrib-viseo

Node-RED nodes OpenSourced by VISEO Technologies
Apache License 2.0
227 stars 83 forks source link

node-red-contrib-viseo-google-spreadsheet: Set data #91

Closed cbsantos closed 5 years ago

cbsantos commented 6 years ago

Hello,

I am using the node-red-contrib-viseo-google-spreadsheet to write. The google sheet accept the registry of an array but, each letter in a string is recorded in one different cell in the sheet. What I am missing?

cheers

Klervix commented 6 years ago

Hi cbsantos! Maybe you are trying to put data from an array, like : ["Red", "Blue", "Pink", "Yellow"]. But one array is for the lines, one for the columns. Try with : [["Red", "Blue", "Pink", "Yellow"]], or [["Red"], ["Blue"], ["Pink"], ["Yellow"]]. Is it better?

cbsantos commented 6 years ago

Hi Klervix!

Thank you very much! It is working now. Sorry for this silly question.

Cheers,

Cesar