[B! excel] danhoxã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

danhox id:danhox

excelã«é–¢ã™ã‚‹danhoxã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

${{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}}

Home
# ã‚¿ãƒ–ã§è¤‡æ•°ã®CSVã‚’ä¸€å…ƒç®¡ç† ãƒ•ã‚¡ã‚¤ãƒ«ã®ãƒ‰ãƒ©ãƒƒã‚°ï¼†ãƒ‰ãƒãƒƒãƒ—ã«ã‚‚å¯¾å¿œã—ã€ è¤‡æ•°ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã¾ã¨ã‚ã¦é–‹ã‘ã¾ã™ã€‚ # æ–‡å—ã‚³ãƒ¼ãƒ‰ãƒ»æ”¹è¡Œã‚³ãƒ¼ãƒ‰ã®å¤‰æ›ã«å¯¾å¿œ ShiftJIS ã‚„ UTF-8 ã‚’ã¯ã˜ã‚ã¨ã—ãŸã€ æ§˜ã€…ãªã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã«å¯¾å¿œã€‚ æ”¹è¡Œã‚³ãƒ¼ãƒ‰ã®å¤‰æ›´ã‚‚ç°¡å˜ã«è¡Œãªãˆã¾ã™ã€‚ # åŒºåˆ‡ã‚Šæ–‡å—ã®æŒ‡å®šãŒå¯èƒ½ .csv ã¯ã‚‚ã¡ã‚ã‚“ã€ .tsv å½¢å¼ã®ãƒ•ã‚¡ã‚¤ãƒ«ã«ã‚‚å¯¾å¿œã€‚ ã€Œã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šã€ã‚„ã€Œã‚¿ãƒ–åŒºåˆ‡ã‚Šã€ã®ã»ã‹ã€ã€Œ|ï¼ˆãƒ‘ã‚¤ãƒ—ï¼‰ã€ã€Œâ˜…ã€ãªã©ä»»æ„ã®åŒºåˆ‡ã‚Šæ–‡å—ã‚’æŒ‡å®šã§ãã¾ã™ã€‚
danhox 2021/06/19
Windows

macOS

excel
ãƒªãƒ³ã‚¯
ã€ã‚¨ã‚¯ã‚»ãƒ«VBAã€‘ä¸€çž¬ã§çµåˆã‚»ãƒ«ã‚’è§£é™¤ã—ã¦å€¤ã‚’åŸ‹ã‚ã‚‹ãƒžã‚¯ãƒ
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ä½¿ã„ãŸã„è¡¨ãªã®ã«ã€çµåˆã‚»ãƒ«ã ã‚‰ã‘ã§ä½¿ã„ç‰©ã«ãªã‚‰ãªã„ã€‚ ãã‚“ãªã¨ãã«ã€VBAã§ä½œã£ãŸãƒžã‚¯ãƒã‚’èµ·å‹•ã™ã‚‹ã ã‘ã§ã€ çµåˆã‚»ãƒ«ã‚’è§£é™¤ã—ã¦ å…ƒã€…å…¥ã£ã¦ã„ãŸå€¤ã‚’ã€çµåˆã•ã‚Œã¦ã„ãŸã™ã¹ã¦ã®ã‚»ãƒ«ã«å…¥åŠ›ã™ã‚‹ ãƒžã‚¯ãƒã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’è²¼ã‚Šä»˜ã‘ã¦å®Ÿè¡Œã™ã‚‹ã ã‘ãªã®ã§ã€1åˆ†ã‚‚ã‹ã‹ã‚‰ãšã«ã€è¡¨ã‚’æ•´å½¢ã§ãã¾ã™ã€‚ ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ ä¸‹è¨˜ã‚’ã€æ¨™æº–ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã«è²¼ã‚Šä»˜ã‘ã¦å®Ÿè¡Œã—ã¦ãã ã•ã„ã€‚ Sub UnmergeCellsAndFillValues() Dim rng As Range For Each rng In ActiveSheet.UsedRange If rng.MergeCells Then With rng.MergeArea .UnMerge .Value = .Resize(1, 1).Value End With End If Next End Sub è§£èª¬ For Eachãƒ«ãƒ¼ãƒ— F
danhox 2020/06/19
VBA

excel
ãƒªãƒ³ã‚¯
Excelã§èª°ã§ã‚‚ç°¡å˜è¨€èªžå‡¦ç† (æ„Ÿæƒ…æŽ¨å®š, å›ºæœ‰è¡¨ç¾æŠ½å‡º, ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰æŠ½å‡º, æ–‡é¡žä¼¼åº¦æŽ¨å®š etc...) - Qiita
Excelã§èª°ã§ã‚‚ç°¡å˜è¨€èªžå‡¦ç† (æ„Ÿæƒ…æŽ¨å®š, å›ºæœ‰è¡¨ç¾æŠ½å‡º, ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰æŠ½å‡º, æ–‡é¡žä¼¼åº¦æŽ¨å®š etc...)Excel API VBAè‡ªç„¶è¨€èªžå‡¦ç†COTOHA 3è¡Œã¾ã¨ã‚ Excelé–¢æ•°ä¸€ç™ºã§é«˜åº¦ãªè¨€èªžå‡¦ç†ã‚’ä½¿ãˆã‚‹ã‚ˆã†ã«ã—ã¾ã—ãŸ æ„Ÿæƒ…æŽ¨å®šã€å›ºæœ‰è¡¨ç¾æŠ½å‡ºãªã©æ—¥æœ¬èªžã‚’åˆ†æžãƒ»æ•´ç†ã™ã‚‹ã®ã«ã„ã‚ã„ã‚ä½¿ãˆã¾ã™ Windows + Officeãƒ¦ãƒ¼ã‚¶ãªã‚‰ãƒžã‚¯ãƒãƒ•ã‚¡ã‚¤ãƒ«ã§èª°ã§ã‚‚ç°¡å˜ã«ä½¿ãˆã¾ã™ â€»Macã ã¨å¤šåˆ†å‹•ã‹ãªã„ã¨æ€ã„ã¾ã™ã€‚VBAã®HTTPãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’æœ‰åŠ¹ã«ã§ããªã„ãŸã‚ã€‚ã€‚ã€‚ 9/1è¿½è¨˜: ã‚³ãƒ¡ãƒ³ãƒˆé ‚ãã¾ã—ãŸãŒã€64bitç‰ˆOfficeã ã¨jsonParseãŒå‹•ã‹ãªã„ã‚ˆã†ãªã®ã§ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã—ã¦ã¿ã¾ã—ãŸã€‚å‹•ä½œç¢ºèªã§ãã¦ã„ãªã„ã®ã§è‡ªå·±è²¬ä»»ã§ãŠé¡˜ã„ã—ã¾ã™ https://github.com/korinzuz2/excel cotoha/blob/master/COTOHAå…¬é–‹ç”¨64bit Excelå¯¾å¿œç‰ˆ.xls
danhox 2019/08/06
API

excel

å½¢æ…‹ç´ è§£æž
ãƒªãƒ³ã‚¯
ã‚¤ãƒžãƒ‰ã‚ã®Excelã‚¹ã‚¯ã‚·ãƒ§ã®æ’®ã‚Šæ–¹
25. ulon-colon ConsumerPublisher WebSocket Connection (start-producer) (produce msg) (make-consumer â€œws://xxxâ€) (consume consumer #(println %)) ç•°ãªã‚‹ãƒ—ãƒã‚»ã‚¹é–“ã§ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸è»¢é€ã™ã‚‹ä»•çµ„ã¿ http://github.com/kawasima/ulon-colon/
danhox 2016/12/05
Selenium

ã‚¹ã‚¯ãƒªãƒ¼ãƒ³ã‚·ãƒ§ãƒƒãƒˆ

excel

ãƒ†ã‚¹ãƒˆ
ãƒªãƒ³ã‚¯
1