How to place data in a cell on a spreadsheet?

jospercomp shared this question 3 years ago

Answered

With which command you can send data to a spreadsheet by commands from Input bar using number in rows and columns indexes.

The same question

Best Answer

rami ● 3 years ago

use Execute()

attached a sample

Files: SpreadSheet-Num...

Comments (9)

alfabeta2 ● 3 years ago

f67e4878fc8be72f480cd3b1737fae0e

Reply URL

jospercomp ● 3 years ago

How do I create a command that takes the two indices in the form of numbers and the value to the spreadsheet? I don't have letter by column. I have index number position.

Cells(1,1,3)=>Cells(A,1,3)=>A1=3

URL

rami ● 3 years ago

With exists GGB commands this is not possible.

Mayby the attached golbal JS function is usefull for you.

Files: SpreadSheet-Num...

Reply URL

jospercomp ● 3 years ago

Yes, It is useful for me. I like Snippets Code in JavaScript.

colNum=1

Using SetValue(colNam+"1",3) don't working to send data to spreadsheet.

What other command could you use to send data to the spreadsheet?

URL

Seror ● 3 years ago

Exemples :

A1="Hello"

A2=457

Reply URL

rami ● 3 years ago ●

use Execute()

attached a sample

Files: SpreadSheet-Num...

Reply URL

jospercomp ● 3 years ago

Amazing.

URL

rami ● 3 years ago

works also with SetValue()

Files: SpreadSheet-Num...

Reply URL

jospercomp ● 3 years ago

Amazing

URL