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

modal_soul id:modal_soul

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

${{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 REST API for Office 365ã€æ£å¼ãƒªãƒªãƒ¼ã‚¹ã€‚ä¿å˜ã•ã‚ŒãŸExcelã®ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆã«APIã§ã‚¢ã‚¯ã‚»ã‚¹å¯èƒ½
ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã€ã€ŒExcel REST API for Office 365ã€æ£å¼ãƒªãƒªãƒ¼ã‚¹ã€‚ä¿å˜ã•ã‚ŒãŸExcelã®ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆã«APIã§ã‚¢ã‚¯ã‚»ã‚¹å¯èƒ½ å¤šãã®ä¼æ¥ã§æ´»ç”¨ã•ã‚Œã¦ã„ã‚‹Excelã€‚å–¶æ¥éƒ¨é–€ãŒå„å–¶æ¥æ‹…å½“ã®é€²æ—çŠ¶æ³ã‹ã‚‰å£²ä¸Šã’ã‚’äºˆæ¸¬ã™ã‚‹Excelã‚·ãƒ¼ãƒˆã‚’ä½œæˆã—ã¦ã„ãŸã‚Šã€çµŒç†éƒ¨é–€ãŒçµŒè²»ã®é…è³¦ã‚’Excelã®ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆã§ç®¡ç†ã—ã¦ã‚‹ã€ãªã©ã¨ã„ã†ä¾‹ã‚‚å°‘ãªããªã„ã§ã—ã‚‡ã†ã€‚ ä¸€èˆ¬çš„ã«ã“ã†ã—ãŸExcelã§ä½œã‚Šè¾¼ã¾ã‚ŒãŸç¤¾å†…ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æ—¢å˜ã®æ¥å‹™ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«çµ„ã¿è¾¼ã‚€ãŸã‚ã«ã¯ã€ã„ã¡ã©Excelã§ä½œã‚Šè¾¼ã¾ã‚ŒãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’è§£æžã—ã€ã‚ã‚‰ãŸã‚ã¦ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã§çµ„ã¿ç«‹ã¦ç›´ã™å¿…è¦ãŒã‚ã‚Šã¾ã—ãŸã€‚ ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆãŒæ£å¼ã«ãƒªãƒªãƒ¼ã‚¹ã—ãŸã€ŒExcel REST API for Office 365ã€ã‚’ç”¨ã„ã‚‹ã¨ã€OneDriveï¼ˆè£œè¶³ï¼šä½¿ãˆã‚‹ã®ã¯OneDrive for Businessï¼‰ã«ä¿å˜ã—ãŸExce
modal_soul 2016/08/05
Fusion Tablesã‹ã¨æ€ã£ãŸ

Office

api

excel
ãƒªãƒ³ã‚¯
Excelãªãƒ†ã‚¹ãƒˆä»•æ§˜æ›¸ã‚’Markdown/GitHub/CircleCIã«ç§»è¡Œã—ãŸè©± - ãƒˆãƒ¬ã‚¿é–‹ç™ºè€…ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€QAã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®äº•ä¸Šæµä¸€ã§ã™ã€‚å¥½ããªé£²ã¿ç‰©ã¯ä¸€ç•ªæ¾ã‚Šã¨éŸƒé¼ãã°èŒ¶ã§ã™ã€‚ åˆå›žã‹ã‚‰ãƒ‹ãƒƒãƒãªãƒã‚¿ã§ã¯ã‚ã‚Šã¾ã™ãŒã€æ˜¨å¹´å…¥ç¤¾ã—ãŸç›´å¾Œã«è¡Œã£ãŸã€ iPad ã‚¢ãƒ—ãƒªã®ãƒ†ã‚¹ãƒˆä»•æ§˜æ›¸ã®ç®¡ç†æ–¹æ³•ã‚’è¦‹ç›´ã—ãŸã¨ãã®è©±ã‚’ç´¹ä»‹ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ è¦‹ç›´ã—ã®ãã£ã‹ã‘ ãƒˆãƒ¬ã‚¿ã¯é£²é£Ÿåº—å‘ã‘ã®äºˆç´„/é¡§å®¢å°å¸³ã‚¢ãƒ—ãƒªã§ã™ã€‚ã ã‚Œã§ã‚‚ã‹ã‚“ãŸã‚“ã«ä½¿ã„ã“ãªã›ã‚‹ã‚·ãƒ³ãƒ—ãƒ«ã•ã‚’è¿½æ±‚ã—ã¦ã¯ã„ã¾ã™ãŒã€è£½å“ã®é€²åŒ–ã«ä¼´ã£ã¦ãã®ãƒ†ã‚¹ãƒˆã‚±ãƒ¼ã‚¹æ•°ã¯ã™ã§ã«æ•°åƒã¨ã„ã†å˜ä½ã«ã¾ã§è†¨ã‚Œã‚ãŒã£ã¦ã„ã¾ã™ã€‚ è£½å“ã®å“è³ªã‚’å®‰å®šã•ã›ã‚‹ãŸã‚ã«ã¯ã€ãƒ†ã‚¹ãƒˆã®å†…å®¹è‡ªä½“ã‚’ãƒ–ãƒ©ãƒƒã‚·ãƒ¥ã‚¢ãƒƒãƒ—ã™ã‚‹ã“ã¨ãŒé‡è¦ãªã®ã¯è¨€ã†ã¾ã§ã‚‚ã‚ã‚Šã¾ã›ã‚“ã€‚ãŸã ã€å®‰å®šã—ãŸè£½å“ã‚’æ°¸ç¶šçš„ã«æä¾›ã—ã¦ã„ããŸã‚ã«ã¯ã€ãã‚Œã«åŠ ãˆã¦ã€è†¨å¤§ãªãƒ†ã‚¹ãƒˆã‚±ãƒ¼ã‚¹ã‚’åŠ¹çŽ‡ã‚ˆããƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã—ç¶šã‘ã‚‹ãŸã‚ã®ãƒ—ãƒã‚»ã‚¹ä½œã‚Šã‚‚æ¬ ã‹ã›ã¾ã›ã‚“ã€‚ å…¥ç¤¾ã®ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§ãƒˆãƒ¬ã‚¿ã®ãƒ†ã‚¹ãƒˆè¨è¨ˆã‚’æ‹…å½“ã™ã‚‹ã“ã¨ã«ãªã£ãŸã®ã§ã€ãƒ†ã‚¹ãƒˆã‚±ãƒ¼ã‚¹ã®ç®¡ç†æ–¹æ³•ã«ã¤ã„ã¦ã‚‚ã„ã¡
modal_soul 2016/07/19
ci

ãƒ†ã‚¹ãƒˆ

excel

markdown
ãƒªãƒ³ã‚¯
Excelã®ãƒ€ãƒ¡ãªã‚°ãƒ©ãƒ•ã§ã‚¦ã‚½ã‚’ã¤ãæ³•ï½œColorless Green Ideas
Excel ã®ã‚°ãƒ©ãƒ•ã§äº‹å®Ÿã‚’èª‡å¼µã—ãŸã„å ´åˆã€3Dã‚°ãƒ©ãƒ•ã‚’ä½¿ã†ã¨ä¾¿åˆ©ã ã€‚ã¨ã„ã†ã‚ã‘ã§ã€æ™®é€šã®æ£’ã‚°ãƒ©ãƒ•ã§ãªãã€3Dæ£’ã‚°ãƒ©ãƒ•ã‚’ä½œã‚‹ã€‚ åˆæ ¼è€…æ•°ã®æŽ¨ç§»ã‚’3Dæ£’ã‚°ãƒ©ãƒ•ã«ã—ãŸã‚‚ã® [1] ã‚°ãƒ©ãƒ•ã‚’æãè¦–ç‚¹ã‚’å¤‰ãˆã‚‹ ã“ã®æ®µéšŽã ã¨ã€ã¾ã ã€Œåœ§å€’çš„ãªã€æ„Ÿã˜ã¯ã—ãªã„ã€‚ã ãŒã€ã‚°ãƒ©ãƒ•ã‚’æãè¦–ç‚¹ã‚’å¤‰ãˆã‚Œã°ã€ã€Œåœ§å€’çš„ãªåˆæ ¼åŠ›ã€ã‚’è¦‹ã›ã¤ã‘ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ã‚°ãƒ©ãƒ•ã‚’æãè¦–ç‚¹ã‚’å¤‰ãˆã‚‹ã«ã¯ã€ã‚°ãƒ©ãƒ•ä¸Šã§å³ã‚¯ãƒªãƒƒã‚¯ã‚’ã—ã¦ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‚’å‡ºã—ã€ã€Œ3-D å›žè»¢â€¦ã€ã‚’é¸ã¶ã€‚ ã€Œ3-Då›žè»¢â€¦ã€ã¨ã„ã†ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‹ã‚‰ã‚°ãƒ©ãƒ•ã‚’æãè¦–ç‚¹ã‚’å¤‰ãˆã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ ãã†ã™ã‚‹ã¨ã€æ¬¡ã®ã‚ˆã†ãªç”»é¢ãŒå‡ºã¦ãã‚‹ã€‚ã“ã®ç”»é¢ã®æ•°å€¤ã‚’ã„ã˜ã‚‹ã“ã¨ã§ã€ã‚°ãƒ©ãƒ•ã®æã‹ã‚Œæ–¹ãŒå¤‰ã‚ã‚‹ã€‚ æ•°å€¤ã‚’å¤‰ãˆã‚‹ã“ã¨ã§ã€ã‚°ãƒ©ãƒ•ã‚’æãè¦–ç‚¹ã‚’å¤‰ãˆã€åˆ¥ã®å°è±¡ã‚’ä¸Žãˆã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ ã¾ãšã¯ã€ã€Œè»¸ã®ç›´äº¤ã€ã¨ã„ã†ãƒã‚§ãƒƒã‚¯ã‚’å¤–ã™ã€‚ãã†ã™ã‚‹ã¨ã€æ¬¡ã®ã‚ˆã†ãªå½¢ã®ã‚°ãƒ©ãƒ•ã«ãªã‚‹ã€‚ ã€Œè»¸ã®ç›´äº¤ã€ã¨ã„ã†ãƒã‚§ãƒƒã‚¯ã‚’å¤–ã—ãŸã‚ã¨ã®3Dæ£’
modal_soul 2016/03/28
TVç•ªçµ„ã§è©³è§£ã•ã‚Œã‚‹ã‚°ãƒ©ãƒ•ã¨æ¯”ã¹ã‚‹ã¨ã€åœ§å€’çš„èª å®Ÿã•ãƒƒ

Excel

ãƒªãƒ†ãƒ©ã‚·ãƒ¼
ãƒªãƒ³ã‚¯
How to insert a row between two rows in an existing excel with HSSF (Apache POI)
Somehow I manage to create new rows between two rows in an existing excel file. The probl em is, some of the formatting were not include along the shifting of the rows. One of this, is the row that are hide are not relatively go along during the shift. What I mean is(ex.), rows from 20 to 30 is hidden, but when a create new rows the formating still there. The hidden rows must also move during the i
modal_soul 2015/10/26
Apache POI

excel
ãƒªãƒ³ã‚¯
ãƒ—ãƒã‚°ãƒ©ãƒžãŒè€ƒãˆã‚‹åŠ‡çš„ã«åŠ¹çŽ‡ãŒä¸ŠãŒã‚‹Excelã‚·ãƒ¼ãƒˆã®ä½œã‚Šæ–¹
ãã“ãã“ã®è¤‡é›‘ãªè¨ˆç®—ã‚’ã™ã‚‹ã®ã«Excelã¯ã‚‚ã®ã™ã”ãä¾¿åˆ©ã§ã™ã€‚ä½•ã‹ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã‚’ä½¿ã£ã¦æ›¸ã„ãŸã‚‰1æ™‚é–“ãã‚‰ã„ã‹ã‹ã‚‹ã‚ˆã†ãªè¨ˆç®—ãŒã€ã‚‚ã®ã®æ•°åˆ†ã§ã‚·ãƒ¼ãƒˆä¸Šã«ã§ãã‚ãŒã‚Šã¾ã™ã€‚ ã“ã®ç´ æ™´ã‚‰ã—ã„Excelã‚’ã€ã‚ˆã‚Šä½¿ã„ã‚„ã™ãã™ã‚‹ãƒ¯ã‚¶ã‚’ã€ãƒ—ãƒã‚°ãƒ©ãƒžçš„ãªè¦–ç‚¹ã‹ã‚‰æ›¸ããŸã„ã¨æ€ã„ã¾ã™ã€‚ æ‹¡å¼µæ€§ã®ãªã„ã‚·ãƒ¼ãƒˆ ãã†ã„ã†ã‚ã‘ã§ã€Excelã¯ç´ æ™´ã‚‰ã—ã„ã‚“ã§ã™ãŒã€ä½¿ã†äººã«ã‚ˆã£ã¦ã¯ãªã‚“ã¨ã‚‚ã€Œæ‹¡å¼µæ€§ã®ãªã„ã‚·ãƒ¼ãƒˆã€ãŒã§ãã‚ãŒã‚Šã¾ã™ã€‚ åƒ•ã¯ãƒ—ãƒã‚°ãƒ©ãƒžãªã®ã§ã€ã“ã†ã„ã†ç´ æ™´ã‚‰ã—ã„ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã„ã¯ã˜ã‚ã‚‹ã¨ã€ã©ã†ã—ã¦ã‚‚æ‹¡å¼µæ€§ã¨ã‹ä¿å®ˆæ€§ã¿ãŸã„ãªã‚‚ã®ãŒæ°—ã«ãªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ãƒ—ãƒã‚°ãƒ©ãƒžã¯åŒã˜ã“ã¨ã‚’ç¹°ã‚Šè¿”ã™ã®ãŒè‹¦æ‰‹ã§ã™ã€‚ã‚·ãƒ¼ãƒˆã«ãƒ‡ãƒ¼ã‚¿ã‚’å…¥åŠ›ã—ã¦ã‹ã‚‰å®Œæˆå½¢ãŒã§ãã‚ãŒã‚‹ã¾ã§ã«äººæ‰‹ã‚’ä½¿ã†ã“ã¨ã‚’é¿ã‘ã¦ã€å…¨éƒ¨ã‚’è‡ªå‹•åŒ–ã—ãŸããªã‚Šã¾ã™ã€‚ æ¬¡ã®ã‚ˆã†ãªã“ã¨ã‚’ã—ã¦ã„ãŸã‚‰ã€Excelã‚’æ£ã—ãä½¿ãˆã¦ã„ãªã„ã‚ˆã†ãªæ°—ãŒã—ã¾ã™ã€‚ é€”ä¸ã§é›»å“ã‚’ä½¿ã£ã¦è¨ˆç®—ã—ã¦ã‚»ãƒ«ã‚’åŸ‹ã‚ã¦ã„
modal_soul 2013/09/12
excel

ãƒ‘ã‚¿ãƒ¼ãƒ³
ãƒªãƒ³ã‚¯
1