Skip to content

Blog 우린친구 블로그에 오신것을 환영합니다.

✔ 뷰어로 보기
[Docs]스프레드시트
2019.01.09 09:25

구글 앱스 스크립트(Google Apps Script) 외부에서 실행하기

nanumi
조회 수 7050 추천 수 0 댓글 2
?

단축키

Prev이전 문서

Next다음 문서

가 크게 작게 위로 아래로 댓글로 가기 인쇄
?

단축키

Prev이전 문서

Next다음 문서

가 크게 작게 위로 아래로 댓글로 가기 인쇄

 

 

 

https://www.44bits.io/ko/post/google-app-script-external-execution-by-ruby

 

 

Facebook Twitter Google Pinterest
위로 아래로 댓글로 가기 인쇄
로그인 후 댓글쓰기가 가능합니다.

에디터 선택하기
?
에디터 사용하기 닫기
Comments '2'
  • ?
    nanumi 2019.01.24 11:48
    <Sat Jan 1 00:00:12 2000> UDHCPC[502]: udhcpc (v1.12.1) started
    <Sat Jan 1 00:00:14 2000> UDHCPC[502]: Sending discover...
    <Sat Jan 1 00:00:14 2000> UDHCPC[502]: received OFFER from 180.189.125.36 IP:36.38.46.58
    <Sat Jan 1 00:00:14 2000> UDHCPC[502]: Sending request for 36.38.46.58...
    <Sat Jan 1 00:00:16 2000> UDHCPC[502]: Receive ACK lease of 36.38.46.58 obtained, lease time 1996
    <Sat Jan 1 00:00:27 2000> UDHCPD[1277]: udhcpd (v1.12.1) started
    <Sat Jan 1 00:00:28 2000> syslog: LAN1 link up
    <Sat Jan 1 00:00:28 2000> syslog: LAN2 link up
    <Sat Jan 1 00:00:28 2000> syslog: LAN3 link up
    <Sat Jan 1 00:00:28 2000> syslog: LAN4 link up
    <Sat Jan 1 00:00:28 2000> syslog: LOOPTASK Send GARP
    <Sat Jan 1 00:00:30 2000> UDHCPD[1277]: received REQUEST From MAC 98:83:89:25:63:d2 Requested IP:192.168.200.152
    <Sat Jan 1 00:00:30 2000> UDHCPD[1277]: received DISCOVER From MAC 98:83:89:25:63:d2
    <Sat Jan 1 00:00:31 2000> UDHCPD[1277]: Sending OFFER to MAC 98:83:89:25:63:d2 Client IP:192.168.200.114
    <Sat Jan 1 00:00:31 2000> UDHCPD[1277]: received REQUEST From MAC 00:50:08:05:3a:08 Requested IP:192.168.200.170
    <Sat Jan 1 00:00:31 2000> UDHCPD[1277]: received REQUEST From MAC 98:83:89:25:63:d2 Requested IP:192.168.200.114
    <Sat Jan 1 00:00:31 2000> UDHCPD[1277]: Sending ACK to MAC 98:83:89:25:63:d2 Client IP:192.168.200.114
    <Sat Jan 1 00:00:31 2000> UDHCPD[1277]: received DISCOVER From MAC 00:50:08:05:3a:08
    <Thu Jan 24 11:46:17 2019> UDHCPD[1277]: Sending OFFER to MAC 00:50:08:05:3a:08 Client IP:192.168.200.198
    <Thu Jan 24 11:46:18 2019> UDHCPD[1277]: received REQUEST From MAC 00:50:08:05:3a:08 Requested IP:192.168.200.198
    <Thu Jan 24 11:46:18 2019> UDHCPD[1277]: Sending ACK to MAC 00:50:08:05:3a:08 Client IP:192.168.200.198
    <Thu Jan 24 11:46:30 2019> UDHCPD[1277]: Received a SIGTERM
    <Thu Jan 24 11:46:30 2019> UDHCPD[1975]: udhcpd (v1.12.1) started
    <Thu Jan 24 11:46:40 2019> kernel: Wireless: 2.4G Channel Scan:
    <Thu Jan 24 11:46:40 2019> kernel: Wireless: Ch BSSID SSID
    <Thu Jan 24 11:46:40 2019> kernel: Wireless: 1 0024C48DCA40 CVS4U
    <Thu Jan 24 11:46:40 2019> kernel: Wireless: 1 88366C22B23C jungang
    <Thu Jan 24 11:46:40 2019> kernel: Wireless: 1 909F33714CF8 Hospital_3
    <Thu Jan 24 11:46:40 2019> kernel: Wireless: 1 60D02C1AB978 Golden-Fi Gyeongju
    <Thu Jan 24 11:46:40 2019> kernel: Wireless: 1 24DEC6C43230
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 2 883C1C5475FD KT_GiGA_2G_75F9
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 2 085DDD243567 olleh_WiFi_3563
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 3 909F334E3524 Information
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 4 34FA9F25EC88 Golden-Fi Gyeongju
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 4 883C1CC1AAC5 KT_GiGA_2G_Wave2_AAC1
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 5 88366C585366 DO
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 6 883C1CBE367E KT_GiGA_2G_Wave2_367A
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 6 000B819F4AE4 janus_bb_gl200_9F4AE4
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 7 883C1C97D15E KT_GiGA_2G_Wave2_D15A
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 11 34FA9F2661D8 Golden-Fi Gyeongju
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 11 34FA9F25EBD8 Golden-Fi Gyeongju
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 13 02161F0336EE T wifi zone_secure
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 13 00161F0336EE T wifi zone
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: Channel [1] chanNum[5] score[15]
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: Channel [2] chanNum[2] score[25]
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: Channel [3] chanNum[1] score[27]
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: Channel [4] chanNum[2] score[22]
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: Channel [5] chanNum[1] score[19]
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: Channel [6] chanNum[2] score[13]
    <Thu Jan 24 11:46:42 2019> kernel: Wireless: Channel [7] chanNum[1] score[11]
    <Thu Jan 24 11:46:42 2019> kernel: Wireless: Channel [8] chanNum[0] score[10]
    <Thu Jan 24 11:46:42 2019> kernel: Wireless: Channel [9] chanNum[0] score[8]
    <Thu Jan 24 11:46:42 2019> kernel: Wireless: Channel [10] chanNum[0] score[9]
    <Thu Jan 24 11:46:42 2019> kernel: Wireless: Channel [11] chanNum[2] score[6]
    <Thu Jan 24 11:46:42 2019> kernel: Wireless: Channel [12] chanNum[0] score[12]
    <Thu Jan 24 11:46:42 2019> kernel: Wireless: Channel [13] chanNum[2] score[6]
    <Thu Jan 24 11:46:42 2019> kernel: Wireless: Channel select : 11
    <Thu Jan 24 11:46:49 2019> system: booting finish
    <Thu Jan 24 11:46:53 2019> aps: preparing
    <Thu Jan 24 11:46:55 2019> syslog: WlanInfo Trap will be sent at 11:29:28
    <Thu Jan 24 11:46:55 2019> syslog: Client Trap will be sent at 23:29:28
    <Thu Jan 24 11:46:56 2019> syslog: LOOPTASK Send GARP
    <Thu Jan 24 11:46:59 2019> aps: provision procedure starts
    <Thu Jan 24 11:47:00 2019> aps: to download PS info
    <Thu Jan 24 11:47:03 2019> aps: downloading PS info OK
    <Thu Jan 24 11:47:03 2019> aps: to parse PS info
    <Thu Jan 24 11:47:06 2019> aps: macaddr=1853e013407b
    <Thu Jan 24 11:47:06 2019> aps: apms_ip=180.182.38.52
    <Thu Jan 24 11:47:06 2019> aps: prov_ip=180.182.38.50
    <Thu Jan 24 11:47:06 2019> aps: config_url=http://180.182.38.50:8080/config_ap/7000/Hanyang_HYC-G800C_1.0.15CJ_CFG.txt
    <Thu Jan 24 11:47:06 2019> aps: cfgac=7000
    <Thu Jan 24 11:47:06 2019> aps: config_ver=Hanyang_HYC-G800C_1.0.15CJ_CFG
    <Thu Jan 24 11:47:06 2019> aps: firmware_url=http://180.182.38.50:8080/firmware_ap/7659/Hanyang_HYC-G800C_1.0.20CJ.bin
    <Thu Jan 24 11:47:06 2019> aps: fwac=7659
    <Thu Jan 24 11:47:06 2019> aps: firmware_ver=Hanyang_HYC-G800C_1.0.20CJ_20180424
    <Thu Jan 24 11:47:06 2019> aps: prov_interval=1
    <Thu Jan 24 11:47:07 2019> aps: prov_stime=00:00:00
    <Thu Jan 24 11:47:07 2019> aps: prov_etime=23:59:59
    <Thu Jan 24 11:47:07 2019> aps: retry_count=3
    <Thu Jan 24 11:47:07 2019> aps: retry_interval=10,20,30
    <Thu Jan 24 11:47:07 2019> aps:
    <Thu Jan 24 11:47:17 2019> aps: parsing PS info OK
    <Thu Jan 24 11:47:18 2019> aps: provision procedure ends
    <Thu Jan 24 11:47:21 2019> aps: next PS is reserved at 14:28:25
    댓글
  • ?
    nanumi 2019.01.24 11:48
    <Sat Jan 1 00:00:12 2000> UDHCPC[502]: udhcpc (v1.12.1) started
    <Sat Jan 1 00:00:14 2000> UDHCPC[502]: Sending discover...
    <Sat Jan 1 00:00:14 2000> UDHCPC[502]: received OFFER from 180.189.125.36 IP:36.38.46.58
    <Sat Jan 1 00:00:14 2000> UDHCPC[502]: Sending request for 36.38.46.58...
    <Sat Jan 1 00:00:16 2000> UDHCPC[502]: Receive ACK lease of 36.38.46.58 obtained, lease time 1996
    <Sat Jan 1 00:00:27 2000> UDHCPD[1277]: udhcpd (v1.12.1) started
    <Sat Jan 1 00:00:28 2000> syslog: LAN1 link up
    <Sat Jan 1 00:00:28 2000> syslog: LAN2 link up
    <Sat Jan 1 00:00:28 2000> syslog: LAN3 link up
    <Sat Jan 1 00:00:28 2000> syslog: LAN4 link up
    <Sat Jan 1 00:00:28 2000> syslog: LOOPTASK Send GARP
    <Sat Jan 1 00:00:30 2000> UDHCPD[1277]: received REQUEST From MAC 98:83:89:25:63:d2 Requested IP:192.168.200.152
    <Sat Jan 1 00:00:30 2000> UDHCPD[1277]: received DISCOVER From MAC 98:83:89:25:63:d2
    <Sat Jan 1 00:00:31 2000> UDHCPD[1277]: Sending OFFER to MAC 98:83:89:25:63:d2 Client IP:192.168.200.114
    <Sat Jan 1 00:00:31 2000> UDHCPD[1277]: received REQUEST From MAC 00:50:08:05:3a:08 Requested IP:192.168.200.170
    <Sat Jan 1 00:00:31 2000> UDHCPD[1277]: received REQUEST From MAC 98:83:89:25:63:d2 Requested IP:192.168.200.114
    <Sat Jan 1 00:00:31 2000> UDHCPD[1277]: Sending ACK to MAC 98:83:89:25:63:d2 Client IP:192.168.200.114
    <Sat Jan 1 00:00:31 2000> UDHCPD[1277]: received DISCOVER From MAC 00:50:08:05:3a:08
    <Thu Jan 24 11:46:17 2019> UDHCPD[1277]: Sending OFFER to MAC 00:50:08:05:3a:08 Client IP:192.168.200.198
    <Thu Jan 24 11:46:18 2019> UDHCPD[1277]: received REQUEST From MAC 00:50:08:05:3a:08 Requested IP:192.168.200.198
    <Thu Jan 24 11:46:18 2019> UDHCPD[1277]: Sending ACK to MAC 00:50:08:05:3a:08 Client IP:192.168.200.198
    <Thu Jan 24 11:46:30 2019> UDHCPD[1277]: Received a SIGTERM
    <Thu Jan 24 11:46:30 2019> UDHCPD[1975]: udhcpd (v1.12.1) started
    <Thu Jan 24 11:46:40 2019> kernel: Wireless: 2.4G Channel Scan:
    <Thu Jan 24 11:46:40 2019> kernel: Wireless: Ch BSSID SSID
    <Thu Jan 24 11:46:40 2019> kernel: Wireless: 1 0024C48DCA40 CVS4U
    <Thu Jan 24 11:46:40 2019> kernel: Wireless: 1 88366C22B23C jungang
    <Thu Jan 24 11:46:40 2019> kernel: Wireless: 1 909F33714CF8 Hospital_3
    <Thu Jan 24 11:46:40 2019> kernel: Wireless: 1 60D02C1AB978 Golden-Fi Gyeongju
    <Thu Jan 24 11:46:40 2019> kernel: Wireless: 1 24DEC6C43230
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 2 883C1C5475FD KT_GiGA_2G_75F9
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 2 085DDD243567 olleh_WiFi_3563
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 3 909F334E3524 Information
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 4 34FA9F25EC88 Golden-Fi Gyeongju
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 4 883C1CC1AAC5 KT_GiGA_2G_Wave2_AAC1
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 5 88366C585366 DO
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 6 883C1CBE367E KT_GiGA_2G_Wave2_367A
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 6 000B819F4AE4 janus_bb_gl200_9F4AE4
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 7 883C1C97D15E KT_GiGA_2G_Wave2_D15A
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 11 34FA9F2661D8 Golden-Fi Gyeongju
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 11 34FA9F25EBD8 Golden-Fi Gyeongju
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 13 02161F0336EE T wifi zone_secure
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: 13 00161F0336EE T wifi zone
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: Channel [1] chanNum[5] score[15]
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: Channel [2] chanNum[2] score[25]
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: Channel [3] chanNum[1] score[27]
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: Channel [4] chanNum[2] score[22]
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: Channel [5] chanNum[1] score[19]
    <Thu Jan 24 11:46:41 2019> kernel: Wireless: Channel [6] chanNum[2] score[13]
    <Thu Jan 24 11:46:42 2019> kernel: Wireless: Channel [7] chanNum[1] score[11]
    <Thu Jan 24 11:46:42 2019> kernel: Wireless: Channel [8] chanNum[0] score[10]
    <Thu Jan 24 11:46:42 2019> kernel: Wireless: Channel [9] chanNum[0] score[8]
    <Thu Jan 24 11:46:42 2019> kernel: Wireless: Channel [10] chanNum[0] score[9]
    <Thu Jan 24 11:46:42 2019> kernel: Wireless: Channel [11] chanNum[2] score[6]
    <Thu Jan 24 11:46:42 2019> kernel: Wireless: Channel [12] chanNum[0] score[12]
    <Thu Jan 24 11:46:42 2019> kernel: Wireless: Channel [13] chanNum[2] score[6]
    <Thu Jan 24 11:46:42 2019> kernel: Wireless: Channel select : 11
    <Thu Jan 24 11:46:49 2019> system: booting finish
    <Thu Jan 24 11:46:53 2019> aps: preparing
    <Thu Jan 24 11:46:55 2019> syslog: WlanInfo Trap will be sent at 11:29:28
    <Thu Jan 24 11:46:55 2019> syslog: Client Trap will be sent at 23:29:28
    <Thu Jan 24 11:46:56 2019> syslog: LOOPTASK Send GARP
    <Thu Jan 24 11:46:59 2019> aps: provision procedure starts
    <Thu Jan 24 11:47:00 2019> aps: to download PS info
    <Thu Jan 24 11:47:03 2019> aps: downloading PS info OK
    <Thu Jan 24 11:47:03 2019> aps: to parse PS info
    <Thu Jan 24 11:47:06 2019> aps: macaddr=1853e013407b
    <Thu Jan 24 11:47:06 2019> aps: apms_ip=180.182.38.52
    <Thu Jan 24 11:47:06 2019> aps: prov_ip=180.182.38.50
    <Thu Jan 24 11:47:06 2019> aps: config_url=http://180.182.38.50:8080/config_ap/7000/Hanyang_HYC-G800C_1.0.15CJ_CFG.txt
    <Thu Jan 24 11:47:06 2019> aps: cfgac=7000
    <Thu Jan 24 11:47:06 2019> aps: config_ver=Hanyang_HYC-G800C_1.0.15CJ_CFG
    <Thu Jan 24 11:47:06 2019> aps: firmware_url=http://180.182.38.50:8080/firmware_ap/7659/Hanyang_HYC-G800C_1.0.20CJ.bin
    <Thu Jan 24 11:47:06 2019> aps: fwac=7659
    <Thu Jan 24 11:47:06 2019> aps: firmware_ver=Hanyang_HYC-G800C_1.0.20CJ_20180424
    <Thu Jan 24 11:47:06 2019> aps: prov_interval=1
    <Thu Jan 24 11:47:07 2019> aps: prov_stime=00:00:00
    <Thu Jan 24 11:47:07 2019> aps: prov_etime=23:59:59
    <Thu Jan 24 11:47:07 2019> aps: retry_count=3
    <Thu Jan 24 11:47:07 2019> aps: retry_interval=10,20,30
    <Thu Jan 24 11:47:07 2019> aps:
    <Thu Jan 24 11:47:17 2019> aps: parsing PS info OK
    <Thu Jan 24 11:47:18 2019> aps: provision procedure ends
    <Thu Jan 24 11:47:21 2019> aps: next PS is reserved at 14:28:25
    댓글
  1. 11
    Nov 2014
    08:17

    음력변환

    Category[Docs]스프레드시트 Views17854
    Read More
  2. 19
    Jan 2018
    16:29

    스프레드시트의 내용이 수정될 경우 즉시 메일발송하는 스크립트 테스트 중

    Category[Docs]스프레드시트 Views7642
    Read More
  3. 10
    Mar 2023
    10:14

    스프레드시트의 값의 변화에 따라 지메일로 메일을 보내는 스크립트

    Category[Docs]스프레드시트 Views1661
    Read More
  4. 09
    Mar 2023
    09:59

    스프레드시트에서 수정, 삭제 버튼 만들기

    Category[Docs]스프레드시트 Views1821
    Read More
  5. 09
    Mar 2023
    09:51

    스프레드시트에서 삽입 버튼 만들기(chatGPT 에게 물어봄)

    Category[Docs]스프레드시트 Views1438
    Read More
  6. 09
    Mar 2023
    09:57

    스프레드시트에서 검색 버튼 만들기

    Category[Docs]스프레드시트 Views2162
    Read More
  7. 27
    Dec 2020
    10:56

    스프레드시트 함수

    Category[Docs]스프레드시트 Views4825
    Read More
  8. 26
    Dec 2020
    16:10

    스프레드시트 스크립트 소스

    Category[Docs]스프레드시트 Views4892
    Read More
  9. 25
    Jan 2018
    13:07

    스프레드시트 autohotkey html gmail 스마트폰 이용하여 핑로스 즉시 알림받기

    Category[Docs]스프레드시트 Views10578
    Read More
  10. 08
    Aug 2016
    00:03

    스프레드시트 api append & update php 셀 내용 수정

    Category[Docs]스프레드시트 Views5314
    Read More
  11. 24
    Jun 2016
    18:09

    스프레드 웹게시로 불러오기

    Category[Docs]스프레드시트 Views4725
    Read More
  12. 11
    Nov 2014
    08:22

    쇼킹한 웹 긁어오기

    Category[Docs]스프레드시트 Views3903
    Read More
  13. 31
    Aug 2018
    21:05

    구글캘린더 CSV 파일로 일괄 기록하기

    Category[Docs]스프레드시트 Views12322
    Read More
  14. 09
    Jul 2015
    07:58

    구글드라이브 API

    Category[Docs]스프레드시트 Views4545
    Read More
  15. 09
    Jan 2019
    09:24

    구글 앱스 스크립트(Google Apps Script) 외부에서 실행하기

    Category[Docs]스프레드시트 Views6807
    Read More
  16. 09
    Jan 2019
    09:25

    구글 앱스 스크립트(Google Apps Script) 외부에서 실행하기

    Category[Docs]스프레드시트 Views7050
    Read More
  17. 26
    Mar 2023
    08:12

    구글 스프레드시트에서 셀값이 특정일에서 현재일과 3일 이내의 범위에 들어오면 이메일을 발송하는 방법

    Category[Docs]스프레드시트 Views40491
    Read More
  18. 24
    Mar 2023
    17:36

    구글 스프레드시트에서 O열=입금완료 가 있는 행은 행 전체가 노란색으로 변하게 하기

    Category[Docs]스프레드시트 Views10050
    Read More
  19. 30
    Apr 2017
    10:17

    구글 스프레드시트를 이용한 지메일 예약발송 방법

    Category[Docs]스프레드시트 Views10790
    Read More
  20. 20
    Jul 2015
    23:07

    구글 스프레드시트(Google Spreadsheet)를 데이터베이스로 활용하기

    Category[Docs]스프레드시트 Views5099
    Read More
Board Pagination Prev 1 2 Next
/ 2

http://urin79.com

우린친구블로그

sketchbook5, 스케치북5

sketchbook5, 스케치북5

나눔글꼴 설치 안내


이 PC에는 나눔글꼴이 설치되어 있지 않습니다.

이 사이트를 나눔글꼴로 보기 위해서는
나눔글꼴을 설치해야 합니다.

설치 취소