This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: [1]
2
Programming / Google Sheet Objects
« on: January 20, 2022, 01:17:57 AM »
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
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
3
Programming / Increased Font Size within pdf file
« on: October 22, 2021, 03:06:33 AM »
03643 PRINT (W0)" "
03644 LET L0=L0+1
03645 LET L$=PAD("Account ID:"+*****+" "+*****,140,"C")
03650 PRINT (W0)'FONT'(FONT$,-8,"B"),'BLUE',L$
03670 LET L0=L0+1
03680 PRINT (W0)" "
03681 LET L0=L0+1
03690 RETURN
Hello,
This is the code which I am using to print the Account ID and Account Name. When I increase the font size from 8 to 9 or 10 the alignment is getting collapsed. How do I do without any changes in the alignment could you please help me.
03644 LET L0=L0+1
03645 LET L$=PAD("Account ID:"+*****+" "+*****,140,"C")
03650 PRINT (W0)'FONT'(FONT$,-8,"B"),'BLUE',L$
03670 LET L0=L0+1
03680 PRINT (W0)" "
03681 LET L0=L0+1
03690 RETURN
Hello,
This is the code which I am using to print the Account ID and Account Name. When I increase the font size from 8 to 9 or 10 the alignment is getting collapsed. How do I do without any changes in the alignment could you please help me.
Pages: [1]