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

yukinarian0 id:yukinarian0

excelã«é–¢ã™ã‚‹yukinarian0ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

æœ€æ–°POIã§ãƒ”ãƒœãƒƒãƒˆãƒ†ãƒ¼ãƒ–ãƒ«ãƒ»ãƒ”ãƒœãƒƒãƒˆã‚°ãƒ©ãƒ•ã‚’è‡ªå‹•ä½œæˆ
CodeZineç·¨é›†éƒ¨ã§ã¯ã€ç¾å ´ã§æ´»èºã™ã‚‹ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚’ã‚¹ã‚¿ãƒ¼ã«ã™ã‚‹ãŸã‚ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒDevelopers Summitã€ã‚„ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿãã–ã¾ã‚’ãƒ–ãƒ¼ã‚¹ãƒˆã™ã‚‹ãŸã‚ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Boostã€ãªã©ã€ã•ã¾ã–ã¾ãªã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä¼ç”»ãƒ»é‹å–¶ã—ã¦ã„ã¾ã™ã€‚
yukinarian0 2010/06/02
excel
ãƒªãƒ³ã‚¯
Excelã®è¡Œã¯æ¸›ã‚‰ã›ã¾ã™ï¼ˆæ¸›ã£ãŸã‚ˆã†ã«è¦‹ã›ã‚‰ã‚Œã¾ã™ï¼‰:Excel(ã‚¨ã‚¯ã‚»ãƒ«)ã®ä½¿ã„æ–¹
â–¼æ“ä½œæ‰‹é †ï¼šãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã‚’ä¿å˜ã™ã‚‹ ï¼»F12ï¼½ã‚ãƒ¼ã‚’æŠ¼ã™ â†“ ï¼»åå‰ã‚’ä»˜ã‘ã¦ä¿å˜ï¼½ãƒ€ã‚¤ã‚¢ãƒã‚° âˆ’ï¼»ãƒ•ã‚¡ã‚¤ãƒ«ã®ç¨®é¡žï¼½æ¬„ã§ã€Œãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã€ã‚’é¸æŠž â†“ ï¼»åå‰ã‚’ä»˜ã‘ã¦ä¿å˜ï¼½ãƒ€ã‚¤ã‚¢ãƒã‚° âˆ’ï¼»ä¿å˜å…ˆï¼½æ¬„ã§ã€ŒXLSTARTã€ãƒ•ã‚©ãƒ«ãƒ€ã‚’é¸æŠž â†“ ï¼»åå‰ã‚’ä»˜ã‘ã¦ä¿å˜ï¼½ãƒ€ã‚¤ã‚¢ãƒã‚° âˆ’ï¼»ãƒ•ã‚¡ã‚¤ãƒ«åï¼½ã‚’ã€Œbookã€ã«ã—ã¦ï¼»ä¿å˜ï¼½ãƒœã‚¿ãƒ³ã‚’ã‚¯ãƒªãƒƒã‚¯ â†“ ï¼»F12ï¼½ã‚ãƒ¼ã‚’æŠ¼ã™ â†“ ï¼»åå‰ã‚’ä»˜ã‘ã¦ä¿å˜ï¼½ãƒ€ã‚¤ã‚¢ãƒã‚° âˆ’ï¼»ãƒ•ã‚¡ã‚¤ãƒ«ã®ç¨®é¡žï¼½æ¬„ãŒã€Œãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã€ ï¼»ä¿å˜å…ˆï¼½æ¬„ãŒã€ŒXLSTARTã€ ã¨ãªã£ã¦ã„ã‚‹ã“ã¨ã‚’ç¢ºèªã—ã¦ ï¼»ãƒ•ã‚¡ã‚¤ãƒ«åï¼½ã‚’ã€Œsheetã€ã«ã—ã¦ï¼»ä¿å˜ï¼½ãƒœã‚¿ãƒ³ã‚’ã‚¯ãƒªãƒƒã‚¯ ãƒã‚¤ãƒ³ãƒˆã¯ã€ ï¼»ãƒ•ã‚¡ã‚¤ãƒ«ã®ç¨®é¡žï¼½ã‚’ã€Œãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã€ã«ã™ã‚‹ã“ã¨ ï¼»ä¿å˜å…ˆï¼½ã‚’ã€ŒXLSTARTã€ã«ã™ã‚‹ã“ã¨ ï¼»ãƒ•ã‚¡ã‚¤ãƒ«åï¼½ã¯ã€Œbookã€ã§ä¸€æ—¦ä¿å˜å¾Œ ã‚‚ã†ä¸€åº¦ã€Œsheetã€ã§ã‚‚ä¿å˜ã™ã‚‹ã“ã¨ ã§ã™ã€‚ ã€Œbookã€ã¨ã„ã†ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆãŒæ–°è¦ã«ãƒ•ã‚¡ã‚¤ãƒ«ï¼ˆãƒ–ãƒƒ
yukinarian0 2009/05/11
dil

excel
ãƒªãƒ³ã‚¯
Excelãƒ•ã‚¡ã‚¤ãƒ«ä½œæˆ(PEAR::Spreadsheet_Excel_Writer) - PEARå…¥é–€
ã“ã“ã§ã¯PEAR::Spreadsheet_Excel_Writerã®ä½¿ã„æ–¹ã«ã¤ã„ã¦ç¢ºèªã—ã¦ã„ãã¾ã™ã€‚PEAR::Spreadsheet_Excel_Writerã¯PHPã‹ã‚‰Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œæˆã™ã‚‹æ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹ã‚‚ã®ã§ã™ã€‚ Spreadsheet_Excel_Writerãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®å°Žå…¥ å¿…è¦ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®èªã¿è¾¼ã¿ ãƒ¯ãƒ¼ã‚¯ãƒ–ãƒƒã‚¯ã®ä½œæˆã¨ä¿å˜ ãƒ¯ãƒ¼ã‚¯ãƒ–ãƒƒã‚¯ã‚’ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¸å‡ºåŠ› ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆã®è¿½åŠ (addWorksheet) ã‚»ãƒ«ã«ãƒ‡ãƒ¼ã‚¿ã‚’æ›¸ãè¾¼ã‚€(write) ã‚»ãƒ«ã«æ•°å€¤ã¨æ–‡å—åˆ—ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ›¸ãè¾¼ã‚€(writeNumber, writeString) ã‚»ãƒ«ã«ã‚³ãƒ¡ãƒ³ãƒˆã‚’æ›¸ãè¾¼ã‚€(writeNote) ã‚»ãƒ«ã«æ›¸å¼è¨å®šã®ç‚ºã®ç©ºã®ã‚»ãƒ«ã‚’æ›¸ãè¾¼ã‚€(writeBlank) ã‚»ãƒ«ã«æ•°å¼ã‚’æ›¸ãè¾¼ã‚€(writeFormula) ã‚»ãƒ«ã«ãƒªãƒ³ã‚¯ã‚’æ›¸ãè¾¼ã‚€(writeUrl)
yukinarian0 2008/09/30
programming

php

pear

excel
ãƒªãƒ³ã‚¯
æœ€æ–°Excelãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã‚’Javaã§æ“ä½œã™ã‚‹ãŸã‚ã®åŸºç¤Ž
ã¾ãšã¯ã€å›³2ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’ã“ã¡ã‚‰ã‚ˆã‚Šãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ãŠã„ã¦ãã ã•ã„ã€‚ â– ã‚µãƒ³ãƒ—ãƒ«ãƒ—ãƒã‚°ãƒ©ãƒ ã®æ³¨æ„äº‹é … æœ¬ç¨¿ã®ã‚µãƒ³ãƒ—ãƒ«ãƒ—ãƒã‚°ãƒ©ãƒ ã«ã¤ã„ã¦ã¯ã€ä»¥ä¸‹ã®æ³¨æ„äº‹é …ãŒã‚ã‚Šã¾ã™ã®ã§ã€æ°—ã‚’ä»˜ã‘ã¦ãã ã•ã„ã€‚ Javaå‹•ä½œç¢ºèªç’°å¢ƒã¯ã€JDK 6 Update 5ã§ã™JDK 6 Update 5ã§ã™ Office 2007ã§docxï¼xlsxï¼pptxã‚µãƒ³ãƒ—ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã®ç·¨é›†ã‚„ä¿å˜ã‚’è¡Œã†ã¨ã€å…ƒã®ã‚µãƒ³ãƒ—ãƒ«ã«ãªã„ã‚³ãƒ¼ãƒ‰ãŒæŒ¿å…¥ã•ã‚Œã¾ã™ ãƒ†ã‚ã‚¹ãƒˆã‚¨ãƒ‡ã‚£ã‚¿ã§ã‚µãƒ³ãƒ—ãƒ«ã®XMLãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç·¨é›†ã™ã‚‹å ´åˆã€æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’UTF-8ã«è¨å®šã—ã¦ãã ã•ã„ã€‚ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãŒæ£ã—ãè¨å®šã•ã‚Œãªã„ã¨ã€Office 2007ã§docxï¼xlsxï¼pptxãƒ•ã‚¡ã‚¤ãƒ«ãŒé–‹ã‘ãªã„å ´åˆãŒã‚ã‚Šã¾ã™æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’UTF-8ã«è¨å®šã—ã¦ãã ã•ã„ã€‚ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãŒæ£ã—ãè¨å®šã•ã‚Œãªã„ã¨ã€Office 2007ã§docxï¼xlsxï¼pptxãƒ•ã‚¡ã‚¤ãƒ«ãŒé–‹ã‘ãªã„å ´åˆãŒã‚ã‚Š
yukinarian0 2008/09/16
programming

java

excel

ril
ãƒªãƒ³ã‚¯
Excelãƒ‡ãƒ¼ã‚¿ã‚’ãƒ“ã‚¸ãƒ¥ã‚¢ãƒ©ã‚¤ã‚ºã—ã‚ˆã† - DesignWalker
yukinarian0 2008/04/10
programming

excel
ãƒªãƒ³ã‚¯
1