{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["개요","Header","Bind","Link Check","SMS(단문)","LMS, MMS","KAKAO","REPORT","REPORT_이전"],"read":"whole","date_system":"1900"}

{"sheet":"개요","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"merged":[[1,1,42,11]]}
[]
[null,"* 모든 메시지의 구성은 헤더(Header)와 몸체(Body)로 구성된다.\n* 메시지 데이터 유형\n    - 각필드의 값은 Network Byte Order(Big - Endian)를 따른다.\n    - I  : 16bit 정수형(int)\n   - nC : nByte의 문자열이며 남는 길이만큼 NUL(0X00)로 채워서 보낸다.\n   - 문자는 앞에서부터 채우는 것을 원칙으로 한다.  "]

{"sheet":"Header","index":1,"n_rows":15,"n_cols":11,"rows_kept":15,"merged":[[0,4,0,5],[1,0,10,0],[1,4,1,5],[2,1,9,1],[2,2,9,2],[2,3,9,3],[2,6,9,6],[10,4,10,5]]}
["PACKET TYPE","FIELD","TYPE","LENGTH","FIELD VALUE",null,"COMMENT",null,"Body Type","Total Length","COMMENT"]
["HEADER","Version","5C",5,"ITN10",{"$nulls":3},"BIND",41]
[null,"Command","1C",1,"BIND",1,null,null,"BIND_ACK",2]
[{"$nulls":4},"BIND_ACK",2,null,null,"LINK_CHECK",3]
[{"$nulls":4},"DELIVER",3,null,null,"LINK_CHECK_ACK",3]
[{"$nulls":4},"DELIVER_ACK",4,null,null,"DELIVER(단문)",239]
[{"$nulls":4},"REPORT",5,null,null,"DELIVER_ACK(단문)",21]
[{"$nulls":4},"REPORT_ACK",6,null,null,"DELIVER(장문)",2129]
[{"$nulls":4},"LINK_CHECK",7,null,null,"DELIVER_ACK(장문)",21]
[{"$nulls":4},"LINK_CHECK_ACK",8,null,null,"DELIVER(MMS)",2130,"파일개수 만큼 추가 바이트 발생"]
[null,"BODY LENGTH","I",4,"Body의 길이",{"$nulls":3},"DELIVER_ACK(MMS)",21]
[{"$nulls":8},"DELIVER(알림톡, 친구톡)",2233]
[{"$nulls":8},"DELIVER_ACK(알림톡, 친구톡)",21]
[{"$nulls":8},"REPORT",58]
[{"$nulls":8},"REPORT_ACK",1]

{"sheet":"Bind","index":2,"n_rows":11,"n_cols":11,"rows_kept":11,"merged":[[0,4,0,5],[0,8,0,10],[1,0,4,0],[1,4,1,5],[2,4,2,5],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,6,4,6],[7,4,7,5],[8,4,8,5]]}
["PACKET TYPE","FIELD","TYPE","LENGTH","FIELD VALUE",null,"COMMENT",null,"BIND_ACK 결과코드값"]
["BIND","ID","20C",20,"인증요청 ID",{"$nulls":3},"코드이름","값","내용"]
[null,"PWD","20C",20,"인증요청 암호",{"$nulls":3},"OK","00","성공"]
[null,"ENCRYPTION","1C",1,"미사용",0,"현재 0만 사용",null,"SYSFAIL","10","시스템 장애 또는 시스템 점검중"]
[{"$nulls":4},"사용",1,null,null,"AUTH_FAIL","20","인증실패(아이디 및 비번이 일치하지 않음)"]
[{"$nulls":8},"AUTH_DENIED","30","사용정지 및 사용권한 없음"]
[{"$nulls":8},"BIND_IP_FAIL","40","접속 허용된 IP 아님"]
["PACKET TYPE","FIELD","TYPE","LENGTH","FIELD VALUE",null,"COMMENT",null,"NOT_BOUND","50","바인드 되지 않음"]
["BIND_ACK","Result Code","2C",2,"코드표 참조",{"$nulls":3},"DUPLICATE BIND","60","중복된 바인드 요청"]
[{"$nulls":8},"PROTOCOL ERROR","70","프로토콜 규격 에러"]
[{"$nulls":8},"UNKNOWN","99","UNKNOWN"]

{"sheet":"Link Check","index":3,"n_rows":6,"n_cols":7,"rows_kept":6,"merged":[[0,4,0,5],[1,4,1,5],[4,4,4,5],[5,4,5,5]]}
["PACKET TYPE","FIELD","TYPE","LENGTH","FIELD VALUE",null,"COMMENT"]
["LINK_CHECK","RESULT","3C",3,100]
[]
[]
["PACKET TYPE","FIELD","TYPE","LENGTH","FIELD VALUE",null,"COMMENT"]
["LINK_CHECK_ACK","RESULT","3C",3,100]

{"sheet":"SMS(단문)","index":4,"n_rows":14,"n_cols":11,"rows_kept":14,"merged":[[0,4,0,5],[0,8,0,10],[1,0,8,0],[1,4,1,5],[2,4,2,5],[3,4,3,5],[5,4,5,5],[6,4,6,5],[7,1,8,1],[7,2,8,2],[11,4,11,5],[12,0,13,0],[12,4,12,5],[13,4,13,5]]}
["PACKET TYPE","FIELD","TYPE","LENGTH","FIELD VALUE",null,"COMMENT",null,"DELIVER_ACK 결과코드값"]
["DELIVER","MSG_ID","20C",20,"고유 메시지 일련번호",{"$nulls":3},"코드이름","값","내용"]
[null,"SENDER","15C",15,"회신번호",{"$nulls":3},"OK",0,"성공"]
[null,"RECEIVER","15C",15,"수신번호",{"$nulls":3},"SYSFAIL",1,"시스템 장애 또는 시스템 점검중"]
[null,"RESERVE_TIME","14C",14,{"$nulls":4},"PROTOCOL ERROR",7,"프로토콜 규격 에러"]
[null,"REQUEST_TIME","14C",14,"요청일시",{"$nulls":3},"TIMEOUT",9,"SESSION TIMEOUT"]
[null,"MESSAGE","160C",160,"전송할 메시지"]
[null,"MSG TYPE","1C",1,"SMS","S"]
[{"$nulls":4},"URL",null,"사용 안함"]
[{"$nulls":3},{"$f":"SUM(D2:D9)","v":239}]
[]
["PACKET TYPE","FIELD","TYPE","LENGTH","FIELD VALUE",null,"COMMENT"]
["DELIVER_ACK","MSG_ID","20C",20,"고유 메시지 일련번호"]
[null,"RESULT","1C",1,"코드표 참조"]

{"sheet":"LMS, MMS","index":5,"n_rows":28,"n_cols":11,"rows_kept":28,"merged":[[0,4,0,5],[0,8,0,10],[1,0,13,0],[1,4,1,5],[2,4,2,5],[3,4,3,5],[6,4,6,5],[7,4,7,5],[8,1,9,1],[8,2,9,2],[8,3,9,3],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[15,0,23,6],[25,4,25,5],[26,0,27,0],[26,4,26,5],[27,4,27,5]]}
["PACKET TYPE","FIELD","TYPE","LENGTH","FIELD VALUE",null,"COMMENT",null,"DELIVER_ACK 결과코드값"]
["DELIVER","MSG_ID","20C",20,"고유 메시지 일련번호",{"$nulls":3},"코드이름","값","내용"]
[null,"SENDER","15C",15,"회신번호",{"$nulls":3},"OK",0,"성공"]
[null,"RECEIVER","15C",15,"수신번호",{"$nulls":3},"SYSFAIL",1,"시스템 장애 또는 시스템 점검중"]
[null,"RESERVE_TIME","14C",14]
[null,"REQUEST_TIME","14C",14]
[null,"SUBJECT","40C",40,"전송제목",{"$nulls":3},"PROTOCOL ERROR",7,"프로토콜 규격 에러"]
[null,"MESSAGE","2000C",2000,"전송할 메시지",{"$nulls":3},"TIMEOUT",9,"SESSION TIMEOUT"]
[null,"MSG TYPE","1C",1,"LMS","L"]
[{"$nulls":4},"MMS","M"]
[null,"FILE COUNT","1C",1,3,null,"파일 수량(현재는 3개까지 지원)"]
[null,"FILE NAME","40C",40,"test.jpg",null,"파일명(jpg만 허용)"]
[null,"FILE SIZE","8C",8,null,null,"파일용량"]
[null,"FILE CONTENT","nC",{"$nulls":3},"파일내용"]
{"$rows_empty":11}
["PACKET TYPE","FIELD","TYPE","LENGTH","FIELD VALUE",null,"COMMENT"]
["DELIVER_ACK","MSG_ID","20C",20,"고유 메시지 일련번호"]
[null,"RESULT","1C",1,"코드표 참조"]

{"sheet":"KAKAO","index":6,"n_rows":29,"n_cols":11,"rows_kept":29,"merged":[[0,4,0,5],[0,8,0,10],[1,0,14,0],[1,4,1,5],[2,4,2,5],[3,4,3,5],[6,4,6,5],[7,4,7,5],[8,1,9,1],[8,2,9,2],[8,3,9,3],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[16,0,24,6],[26,4,26,5],[27,0,28,0],[27,4,27,5],[28,4,28,5]]}
["PACKET TYPE","FIELD","TYPE","LENGTH","FIELD VALUE",null,"COMMENT",null,"DELIVER_ACK 결과코드값"]
["DELIVER","MSG_ID","20C",20,"고유 메시지 일련번호",{"$nulls":3},"코드이름","값","내용"]
[null,"SENDER","15C",15,"회신번호",{"$nulls":3},"OK",0,"성공"]
[null,"RECEIVER","15C",15,"수신번호",{"$nulls":3},"SYSFAIL",1,"시스템 장애 또는 시스템 점검중"]
[null,"RESERVE_TIME","14C",14]
[null,"REQUEST_TIME","14C",14]
[null,"SUBJECT","40C",40,"전송제목",{"$nulls":3},"PROTOCOL ERROR",7,"프로토콜 규격 에러"]
[null,"MESSAGE","2000C",2000,"전송할 메시지",{"$nulls":3},"TIMEOUT",9,"SESSION TIMEOUT"]
[null,"MSG TYPE","1C",1,"알림톡","A"]
[{"$nulls":4},"친구톡","F"]
[null,"SENDER_KEY","40C",40]
[null,"TEMPLATE_CODE","64 C",64,3,null,"파일 수량(현재는 3개까지 지원)"]
[null,"FILE NAME","40C",40,"test.json",null,"파일명(json만 허용)"]
[null,"FILE SIZE","8C",8,null,null,"파일용량"]
[null,"FILE CONTENT","nC",{"$nulls":3},"파일내용"]
{"$rows_empty":11}
["PACKET TYPE","FIELD","TYPE","LENGTH","FIELD VALUE",null,"COMMENT"]
["DELIVER_ACK","MSG_ID","20C",20,"고유 메시지 일련번호"]
[null,"RESULT","1C",1,"코드표 참조"]

{"sheet":"REPORT","index":7,"n_rows":10,"n_cols":7,"rows_kept":10,"merged":[[0,4,0,5],[1,0,5,0],[4,4,4,5],[5,4,5,5],[8,4,8,5],[9,4,9,5]]}
["PACKET TYPE","FIELD","TYPE","LENGTH","FIELD VALUE",null,"COMMENT"]
["REPORT","MSG_ID","20C",20,null,null,"요청 메시지 일련 번호"]
[null,"AGENT_CODE","2C",2,null,null,"발송사코드"]
[null,"SEND TIME","14C",14,null,null,"전송시간(예:20141112152350)"]
[null,"TELECOM","3C",3,"KT, LGT, SKT",null,"이동 통신사 정보"]
[null,"RESULT","5C",5,"별첨"]
[]
[]
["PACKET TYPE","FIELD","TYPE","LENGTH","FIELD VALUE",null,"COMMENT"]
["REPORT_ACK","RESULT","1C",1,0,null,"정상 결과 수신을 한경우 임의 1C값 응답"]

{"sheet":"REPORT_이전","index":8,"n_rows":10,"n_cols":7,"rows_kept":10,"merged":[[0,4,0,5],[1,0,5,0],[4,4,4,5],[5,4,5,5],[8,4,8,5],[9,4,9,5]]}
["PACKET TYPE","FIELD","TYPE","LENGTH","FIELD VALUE",null,"COMMENT"]
["REPORT","MSG_ID","20C",20,null,null,"요청 메시지 일련 번호"]
[null,"RECEIVER","15C",15,null,null,"수신번호"]
[null,"SEND TIME","14C",14,null,null,"전송시간(예:20141112152350)"]
[null,"TELECOM","5C",5,"KT, LGT, SKT",null,"이동 통신사 정보"]
[null,"RESULT","4C",4,"별첨"]
[]
[]
["PACKET TYPE","FIELD","TYPE","LENGTH","FIELD VALUE",null,"COMMENT"]
["REPORT_ACK","RESULT","1C",1,0,null,"정상 결과 수신을 한경우 임의 1C값 응답"]