How to place data in a cell on a spreadsheet?

jospercomp shared this question 10 months ago
Answered

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

Best Answer
photo

use Execute()

attached a sample

Comments (9)

photo
1

f67e4878fc8be72f480cd3b1737fae0e

photo
1

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

photo
photo
2

With exists GGB commands this is not possible.

Mayby the attached golbal JS function is usefull for you.

photo
1

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?

photo
photo
1

Exemples :

A1="Hello"

A2=457

photo
1

use Execute()

attached a sample

photo
1

Amazing.

photo
photo
2

works also with SetValue()

photo
1

Amazing

photo
© 2020 International GeoGebra Institute