[B! JSON] cozyathtnã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

cozyathtn id:cozyathtn

JSONã«é–¢ã™ã‚‹cozyathtnã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (9)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Excelã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’JSONå½¢å¼ã«å¤‰æ›ã™ã‚‹ãƒžã‚¯ãƒ | You Look Too Cool
[{ "ID": "1", "åå‰": "éˆ´æœ¨", "å¾—ç‚¹": "91" }, { "ID": "2", "åå‰": "ç”°ä¸", "å¾—ç‚¹": "86" }, { "ID": "3", "åå‰": "å±±æœ¬", "å¾—ç‚¹": "87" }, { "ID": "4", "åå‰": "é«˜æ©‹", "å¾—ç‚¹": "78" }] å®Ÿéš›ã¯ã€Œ[{â€œIDâ€:â€1â€³,â€åå‰â€:â€éˆ´æœ¨â€,â€å¾—ç‚¹â€:â€91â€³},{â€œIDâ€:â€2â€³,â€åå‰â€:â€ç”°ä¸â€,â€å¾—ç‚¹â€:â€86â€³},{â€œIDâ€:â€3â€³,â€åå‰â€:â€å±±æœ¬â€,â€å¾—ç‚¹â€:â€87â€³},{â€œIDâ€:â€4â€³,â€åå‰â€:â€é«˜æ©‹â€,â€å¾—ç‚¹â€:â€78â€³}]ã€ã®ã‚ˆã†ã«æ”¹è¡Œã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ Sub è¡¨ã‚’JSONå½¢å¼ã«() arrs = Cells(1, 1).CurrentRegion '1ã‹ã‚‰è¡Œæ•°ã¾ã§ã€1ã‹ã‚‰åˆ—æ•°ã¾ã§ len_row = UBound(arrs, 1) 'è¡Œæ•° len
cozyathtn 2016/06/06
Excel

JSON
ãƒªãƒ³ã‚¯
JSON Online Validator and Formatter - JSON Lint
To format and validate your JSON, just copy + paste it below: About the JSONLint EditorJSONLint is a validator and reformatter for JSON, a lightweight data-interchange format. Copy and paste, directly type, or input a URL in the editor above and let JSONLint tidy and validate your messy JSON code. What Is JSON?JSON (pronounced as Jason), stands for "JavaScript Object Notation," is a human-readable
cozyathtn 2016/04/05
JSON

5
ãƒªãƒ³ã‚¯
https://www.ietf.org/rfc/rfc4627
cozyathtn 2016/03/25
JSON

RFC
ãƒªãƒ³ã‚¯
RFC4627 (JSONã®ä»•æ§˜) ã‚’æµã—èªã¿ã—ã¦ã¿ã‚‹ - ã‚¹ã‚¿ã‚¸ã‚ªãƒ»ã‚¢ãƒ«ã‚«ãƒŠæŠ€è¡“ãƒ–ãƒã‚°
ã¯ã„ã©ã†ã‚‚ï½žã€‚ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®å‰ç”°ã ã‚ˆã€‚ ä»Šæ—¥ã¯ã€æ°—åˆ†è»¢æ›ã«å£èªžèª¿ãƒ¢ãƒ¼ãƒ‰ã§ç¶´ã£ã¦ã¿ã‚‹ãã€‚ ã“ã“æœ€è¿‘ã®ä»•äº‹ã¯ã€ã»ã¨ã‚“ã©ã®æ¡ˆä»¶ã§å½“ãŸã‚Šå‰ã®ã‚ˆã†ã«JSONã‚’ä½¿ã£ã¦ã„ã‚‹ã‚“ã ã‘ã©ã€ ãŠãƒã‚«ãªã›ã„ã‹ã—ã‚‰ã€ã€Œãã†ã„ãˆã°ã€JSONã®ä»•æ§˜ã£ã¦ã©ã‚“ãªã ã£ãŸã‹ã—ã‚‰ï¼Ÿã€ãªã‚“ã¦é¢¨ã« ã™ãã«å¿˜ã‚Œã¦ã—ã¾ã†ã®ã‚ˆã€‚ ã ã‹ã‚‰ã€ãƒ¡ãƒ¢ã¨å¾©ç¿’ã‚‚å…¼ãã¦JSONã®ä»•æ§˜ã‚’RFCã§å†ç¢ºèªã—ã¦ã¿ã‚‹ã‚ã€‚ JSONã®ä»•æ§˜ã¯IETF (Internet Engineering Task Force) ã®ã‚µã‚¤ãƒˆã§ RFC (Request for Comments) ã¨ã—ã¦å…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã‹ã‚‰ã€å›°ã£ãŸã¨ãã¯ å··ã®Webã‚µã‚¤ãƒˆã§èª¿ã¹ã‚‹ã‚ˆã‚Šã‚‚ã€RFCã‚’ç¢ºèªã™ã‚‹ã¨é–“é•ã„ãªã„ã®ã€‚ äºŒæ¬¡æƒ…å ±ã‚ˆã‚Šä¸€æ¬¡æƒ…å ±ã‚’èª¿ã¹ã‚‹ã¨ã„ã†ã“ã¨ã¯ã¨ã¦ã‚‚å¤§äº‹ãªã“ã¨ãªã®ã‚ˆã€‚ ã¨ã„ã†ã‚ã‘ã§ã€æ—©é€ŸJSONã®RFCã‚’ãƒ¦ãƒ«ã„æ„Ÿã˜ã§è¦‹ã¦ã¿ã‚‹ã‚ãã€‚ RFC4627 JSONã®ä»•æ§˜ã¯RFC4627ã¨ã—ã¦å…¬
cozyathtn 2016/03/25
JSON

RFC
ãƒªãƒ³ã‚¯
JSON æ§‹æ–‡
JSONã®æ§‹æ–‡ã¯ã€JavaScriptæ§‹æ–‡ã®ã‚µãƒ–ã‚»ãƒƒãƒˆã§ã™ JSONæ§‹æ–‡è¦å‰‡ JSONã®æ§‹æ–‡ã¯ã€JavaScriptã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆè¨˜è¿°æ§‹æ–‡ã®ã‚µãƒ–ã‚»ãƒƒãƒˆã§ã™ï¼š ãƒ‡ãƒ¼ã‚¿ã¯ã€åå‰/å€¤ã®ãƒšã‚¢ã§ã™ ãƒ‡ãƒ¼ã‚¿ã¯ã€ã‚«ãƒ³ãƒžã§åŒºåˆ‡ã‚Šã¾ã™ æ³¢æ‹¬å¼§ã®ä¸ã¯ã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’è¡¨ã—ã¾ã™ è§’æ‹¬å¼§ã®ä¸ã¯ã€é…åˆ—ã‚’è¡¨ã—ã¾ã™ JSONãƒ‡ãƒ¼ã‚¿ - åå‰ã¨å€¤ JSONãƒ‡ãƒ¼ã‚¿ã¯ã€åå‰/å€¤ã®ãƒšã‚¢ã¨ã—ã¦è¨˜è¿°ã—ã¾ã™ã€‚ åå‰/å€¤ã®ãƒšã‚¢ã¯ã€äºŒé‡å¼•ç”¨ç¬¦ã§æ‹¬ã£ãŸãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰åã®å¾Œã«ã‚³ãƒãƒ³ãŒç¶šãã€ãã®æ¬¡ã«å€¤ãŒæ¥ã‚‹å½¢å¼ã§æ§‹æˆã•ã‚Œã¾ã™ï¼š JSONã®å€¤ JSONã®å€¤ã¯æ¬¡ã®å½¢å¼ã‚’å–ã‚‹ã“ã¨ãŒã§ãã¾ã™ï¼š æ•°å€¤(æ•´æ•°ã¾ãŸã¯æµ®å‹•å°æ•°ç‚¹) æ–‡å—åˆ—(äºŒé‡å¼•ç”¨ç¬¦ã§æ‹¬ã‚‹) ãƒ–ãƒ¼ãƒ«å€¤(true ã¾ãŸã¯ false) é…åˆ—(è§’æ‹¬å¼§ã§æ‹¬ã‚‹) ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆ(æ³¢æ‹¬å¼§ã§æ‹¬ã‚‹) null JSONã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆ JSONã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¯ã€æ³¢æ‹¬å¼§ã®ä¸ã«è¨˜è¿°ã—ã¾ã™ã€‚ JavaScriptã¨åŒæ§˜ã«ã€è¤‡æ•°
cozyathtn 2016/03/09
JSON
ãƒªãƒ³ã‚¯
JSON ã®ç´¹ä»‹
JSON (JavaScript Object Notation)ã¯ã€è»½é‡ã®ãƒ‡ãƒ¼ã‚¿äº¤æ›ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã§ã™ã€‚äººé–“ã«ã¨ã£ã¦èªã¿æ›¸ããŒå®¹æ˜“ã§ã€ãƒžã‚·ãƒ³ã«ã¨ã£ã¦ã‚‚ç°¡å˜ã«ãƒ‘ãƒ¼ã‚¹ã‚„ç”Ÿæˆã‚’è¡Œãªãˆã‚‹å½¢å¼ã§ã™ã€‚ JavaScriptãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªž ï¼ˆECMA-262æ¨™æº–ç¬¬3ç‰ˆ 1999å¹´12æœˆï¼‰ã®ä¸€éƒ¨ã‚’ãƒ™ãƒ¼ã‚¹ã«ä½œã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ JSONã¯å®Œå…¨ã«è¨€èªžã‹ã‚‰ç‹¬ç«‹ã—ãŸãƒ†ã‚ã‚¹ãƒˆå½¢å¼ã§ã™ãŒã€Cã€C++ã€C#ã€Javaã€JavaScriptã€Perlã€Pythonã€ãã®ä»–å¤šãã®Cãƒ•ã‚¡ãƒŸãƒªãƒ¼ã®è¨€èªžã‚’ä½¿ç”¨ã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒžã«ã¨ã£ã¦ã¯ã€é¦´æŸ“ã¿æ·±ã„è¦ç´„ãŒä½¿ã‚ã‚Œã¦ã„ã¾ã™ã€‚ã“ã‚Œã‚‰ã®æ€§è³ªãŒã€ JSONã‚’ç†æƒ³çš„ãªãƒ‡ãƒ¼ã‚¿äº¤æ›è¨€èªžã«ã—ã¦ã„ã¾ã™ã€‚ JSONã¯2ã¤ã®æ§‹é€ ã‚’åŸºã«ã—ã¦ã„ã¾ã™ã€‚ åå‰/å€¤ã®ãƒšã‚¢ã®é›†ã¾ã‚Šã€‚æ§˜ã€…ãªè¨€èªžã§ã€ã“ã‚Œã¯ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã€ãƒ¬ã‚³ãƒ¼ãƒ‰ã€æ§‹é€ ä½“ã€ãƒ‡ã‚£ã‚¯ã‚·ãƒ§ãƒŠãƒªã€ãƒãƒƒã‚·ãƒ¥ãƒ†ãƒ¼ãƒ–ãƒ«ã€ã‚ãƒ¼ã®ã‚ã‚‹ãƒªã‚¹ãƒˆã€é€£æƒ³é…åˆ—ã¨ã—ã¦å®Ÿç¾ã•ã‚Œã¦ã„ã¾ã™ã€‚
cozyathtn 2016/03/09
JSON
ãƒªãƒ³ã‚¯
ç¬¬6å›žãƒ»JSONãƒ•ã‚¡ã‚¤ãƒ«ï½œCSVã€XMLã€JSONâ€¦ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã®å¤‰é·ã«ã¤ã„ã¦è€ƒãˆã‚‹ - GiXo Ltd.
ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆè§£èª¬ã®ç¬¬å››å¼¾(æœ€å¾Œ)ã¯JSONãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã§ã™ å‰å›ž(ç¬¬5å›ž)ã¯ã€å„ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã‚’èª¬æ˜Žã—ã¦ã„ãç¬¬ä¸‰å¼¾ã¨ã—ã¦XMLãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã—ãŸã€‚ä»Šå›žã¯ç¬¬å››å¼¾ã¨ã—ã¦JSONãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚JSONã¯ç¬¬4å›ž(ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆèª¬æ˜Žç¬¬äºŒå¼¾)ã§èª¬æ˜Žã—ãŸCSVãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã¨åŒæ§˜ã«RFCã«ã‚ˆã£ã¦ä»•æ§˜ãŒå…¬é–‹ã•ã‚Œã¦ãŠã‚ŠRFC4627ã¨ã—ã¦ãƒŠãƒ³ãƒãƒªãƒ³ã‚°ã•ã‚Œã¦ã„ã¾ã™ã€‚ã‚¯ãƒ¬ã‚¸ãƒƒãƒˆãŒ2006å¹´7æœˆãªã®ã§ã¾ã 10æ‰ã«æº€ãŸãªã„è‹¥ã„ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã¨è¨€ãˆã¾ã™ã€‚JSONã¯æ£å¼åã‚’JavaScript Object Notation(ç›´è¨³ã™ã‚‹ã¨JavaScriptã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®è¡¨è¨˜æ³•)ã¨ã„ã„ã¾ã™ãŒã€ç¾åœ¨ã¯JavaScriptã«é™ã‚‰ãšå¤šãã®ãƒ—ãƒã‚°ãƒ©ãƒ ã‹ã‚‰åˆ©ç”¨ã•ã‚Œã¦ãŠã‚Šãã®ç¯„å›²ã‚„ç”¨é€”ã¯æ€¥é€Ÿã«æ‹¡å¤§ã—ç¶šã‘ã¦ã„ã¾ã™ã€‚ãã®å¤šãã¯æ—¢å˜ã®XMLãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã®ç”¨é€”ã‚’ç½®ãæ›ãˆã‚‹å½¢ã§é€²ã‚“ã§ã„ã‚‹ã®ã§ã™ãŒã€å®Ÿéš›ç§è‡ªèº«ã‚‚éŽåŽ»ã«XM
cozyathtn 2016/03/04
JSON
ãƒªãƒ³ã‚¯
bacaãªæ—¥è¨˜ - JSONãƒ•ã‚¡ã‚¤ãƒ«ä½œæˆãƒ„ãƒ¼ãƒ«Excelã§ä½œã£ã¦ã¿ãŸã‚ˆ
The Life Log of bacaæœ€è¿‘ä»•äº‹ã§JavaScriptã‚’èªã‚“ã ã‚Šæ›¸ã„ãŸã‚Šã—ã¦ã„ã‚‹ã®ã§ã™ãŒï¼ŒJSONãƒ•ã‚¡ã‚¤ãƒ«ã«ãƒ‡ãƒ¼ã‚¿ã‚’å¤§é‡ã«æ›¸ãå¿…è¦ãŒã‚ã£ã¦ï¼Œå…ƒãƒ‡ãƒ¼ã‚¿ãŒExcelã§æ¥ã‚‹ã®ã§ãƒžã‚¯ãƒã§ä½œã‚Œã‚‹ã‚ˆã†ã«ã—ã¾ã—ãŸï¼Ž åˆ¥ã«ã“ã‚“ãªã®1æ™‚é–“ç¨‹åº¦ã§ä½œã‚Œã‚‹ã¨æ€ã†ã®ã§ã™ã‘ã©ï¼Œã“ã‚“ãªã“ã¨ã§åŒã˜ã‚ˆã†ã«æ™‚é–“ã‚’æµªè²»ã™ã‚‹å¿…è¦ã¯ãªã„ã¨æ€ã†ã®ã§ï¼Œå…¬é–‹ã—ã¦ãŠãã¾ã™ï¼Ž JSON_File_Maker ä½¿ã„æ–¹ã¯ãã‚“ãªã«è¿·ã†ã“ã¨ã¯ãªã„ã¨æ€ã„ã¾ã™ï¼Žãƒ•ã‚¡ã‚¤ãƒ«é–‹ã„ã¦é ‚ã‘ã‚Œã°ã‚³ãƒ¡ãƒ³ãƒˆãŒæ›¸ã„ã¦ã‚ã‚Šã¾ã™ã®ã§ãã¡ã‚‰ã‚’å‚ç…§ã—ã¦ãã ã•ã„ï¼Ž # ã¡ã‚‡ã£ã¨ãƒ—ãƒã‚°ãƒ©ãƒ ã¨ã—ã¦ã‚¤ã‚±ã¦ãªã„ã¨ã“ã‚ãŒã‚ã‚‹ã‚“ã ã‘ã©ï¼Œã¾ãã‚³ã‚¹ãƒˆã‹ã‘ã‚‹å ´æ‰€ã˜ã‚ƒãªã„ã£ã—ã‚‡ï¼Žï¼Žï¼Žã¨ã„ã†ã“ã¨ã§ï¼ˆè¨€ã„è¨³ ã¨ã“ã‚ã§ï¼ŒJSONãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¯ãƒã‚¹ãƒ‰ãƒ¡ã‚¤ãƒ³ç’°å¢ƒã§ä½¿ãŠã†ã¨æ€ã£ãŸã‚‰ï¼Œå…ƒã€…ä½¿ãˆã‚‹ã‚ˆã†ãªä»•æ§˜ã«ãªã£ã¦ã„ãªã„ã¨åˆã‚ã¦çŸ¥ã‚Šã¾ã—ãŸï¼Ž JSONPã¨ã‹è¨€ã†ã‚‚ã®ãŒã‚ã‚‹ã‚ˆã†ã§ã™ãŒï¼Œã“ã‚Œã«ã¤ã„ã¦ã¯
cozyathtn 2016/02/05
JSON

Excel

VBA
ãƒªãƒ³ã‚¯
You Look Too Cool Â» VBAã§Excelã®è¡¨ã‚’JSONå½¢å¼ã«å¤‰æ›ã™ã‚‹
Sub è¡¨ã‚’JSONå½¢å¼ã«ã™ã‚‹() Dim arr(1000) Dim gyo, retsu, gyosu, cnt As Long Dim lin, temp As String arr(0) = â€œ[" gyo = 2 Do retsu = 1 lin = "" Do temp = Chr(34) & Cells(1, retsu) & Chr(34) & ":" & Chr(34) & Cells(gyo, retsu) & Chr(34) lin = lin & "," & temp retsu = retsu + 1 Loop Until Cells(gyo, retsu) = "" lin = Mid(lin, 2) arr(gyo - 1) = "{" & lin & "}," gyo = gyo + 1 Loop Until Cells(g
cozyathtn 2016/02/05
JSON

VBA

vba

Excel
ãƒªãƒ³ã‚¯
1