Hi,
I am working with spreadsheet object. I have a sample code which is shown below.
00130 LET PATH$="PVX_test"
00140 IF X'OPENSPREADSHEETBYPATH(PATH$)=0 THEN MSGBOX "Couldn't find "+PATH$
00200 LET S4$=" XXX"
00201 CALL "XOPENS4"
00202 GET_XXX:
00203 READ (V[1],END=GET_XXX)R1$(1)
00204 LET I=1
00211 LET R1$=SUB(R1$,"'","`"),R1$=SUB(R1$,",","~")
00212 LET A$=STP(R1::AAA$,2)
00213 LET B$=STP(R1::BBB$,2)
00214 LET C$=STP(R1::CCC$,2)
00218 LET SEP$=SEP
00220 LET CELL_VALUE$=A$+SEP+B$+SEP+C$
00230 PRINT CELL_VALUE$
00231 IF X'SETRANGECOLUMN("A:C")=0 THEN MSGBOX "Failed setting a column range"
00232 ! IF X'SETRANGEROW("A1:C100")=0 THEN MSGBOX "FAILED SETTING A ROW"
00240 IF X'WRITE(CELL_VALUE$,"A1:C100")=0 THEN MSGBOX "COULDN'T WRITE"
00290 LET I=I+1
00300 GOTO GET_XXX
00310 END_FILE:
00320 END
In this code I have created a google sheet and want to write values. How to write values in a row once that row is completed how does it go to the next row for writing the rest of the values.
Thank you