[B! open xml] Ikhisaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

Ikhisa id:Ikhisa

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (8)

ã‚¿ã‚°ã®çµžã‚Šè¾¼ã¿ã‚’è§£é™¤

open xmlã«é–¢ã™ã‚‹Ikhisaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

Office Open XMLå½¢å¼ã«å¯¾å¿œã—ãŸPOIã®æ¦‚è¦ã¨ç’°å¢ƒæ§‹ç¯‰
ã¯ã˜ã‚ã« POIã¯Javaã‹ã‚‰Microsoftã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’æ“ä½œã™ã‚‹ãŸã‚ã®APIã§ã€2007å¹´6æœˆã‹ã‚‰Apache Software Foundationã®ãƒˆãƒƒãƒ—ãƒ¬ãƒ™ãƒ«ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«æ ¼ä¸Šã’ã•ã‚Œã¾ã—ãŸã€‚ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ã—ã¦æä¾›ã•ã‚Œã¦ã„ã‚‹ã®ã§èª°ã§ã‚‚ç„¡å„Ÿã§åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ãªãœåˆæœŸã®ãƒªãƒªãƒ¼ã‚¹å¾Œã€7å¹´ä»¥ä¸Šã‚‚çµŒéŽã—ã€å¤šãã®æƒ…å ±ãŒå˜åœ¨ã™ã‚‹POIã‚’ä»Šå›žã‚ã‚‰ãŸã‚ã¦å–ã‚Šä¸Šã’ã‚‹ã“ã¨ã«ã—ãŸã‹ã¨è¨€ã†ã¨ã€2009å¹´9æœˆãƒªãƒªãƒ¼ã‚¹ã®Version 3.5ã§Office Open XMLå½¢å¼ï¼ˆä»¥é™ã€OOXMLå½¢å¼ï¼‰ã¸ã®å¯¾å¿œã¨ã„ã†å¤§ããªå¤‰æ›´ãŒåŠ ã‚ã£ãŸã‹ã‚‰ã§ã™ã€‚ åˆ†ã‹ã‚Šã‚„ã™ãã„ã†ã¨2007å½¢å¼ã®Excelï¼ˆxlsxï¼‰ã‚„Wordï¼ˆdocxï¼‰ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚‚æ‰±ãˆã‚‹ã‚ˆã†ã«ãªã£ãŸã¨ã„ã†ã“ã¨ã§ã™ã€‚ æœ¬é€£è¼‰ã§ã¯ã€POIã®ä¸ã‹ã‚‰Excelã‚’æ“ä½œã™ã‚‹ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆï¼ˆHSSF/XSSFï¼‰ã«å¯¾è±¡ã‚’çµžã‚Šã€ä¸‹è¨˜ã®äºˆå®šã§ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚ æº–
Ikhisa 2011/09/21
POI

open xml

java
ãƒªãƒ³ã‚¯
æœ€æ–°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ãƒ•ã‚¡ã‚¤ãƒ«ãŒé–‹ã‘ãªã„å ´åˆãŒã‚ã‚Š
Ikhisa 2011/09/21
Java

office

open XML
ãƒªãƒ³ã‚¯
Open XML å½¢å¼ SDK 1.0 ã¸ã‚ˆã†ã“ã
ã“ã®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ ã‚»ãƒƒãƒˆã¯ã€Open XML SDK for Office ã®åŽ³å¯†ã«åž‹æŒ‡å®šã•ã‚ŒãŸã‚¯ãƒ©ã‚¹ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¨ã‚¬ã‚¤ãƒ€ãƒ³ã‚¹ã‚’æä¾›ã—ã¾ã™ã€‚ ã“ã® SDK ã¯ System.IO.Packaging API ã«åŸºã¥ã„ã¦æ§‹ç¯‰ã•ã‚Œã¦ãŠã‚Šã€Office Open XML ãƒ•ã‚¡ã‚¤ãƒ«å½¢å¼ã®ä»•æ§˜ã«æº–æ‹ ã—ã¦ã„ã‚‹ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’æ“ä½œã™ã‚‹ãŸã‚ã®åŽ³å¯†ã«åž‹æŒ‡å®šã•ã‚ŒãŸã‚¯ãƒ©ã‚¹ã‚’æä¾›ã—ã¾ã™ã€‚ Office Open XML ãƒ•ã‚¡ã‚¤ãƒ«å½¢å¼ä»•æ§˜ã¯ã€ã‚ªãƒ¼ãƒ—ãƒ³ã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒŠã‚·ãƒ§ãƒŠãƒ«ã€ECMA-376ã€ç¬¬ 5 ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã€ISO/IEC 29500 æ¨™æº–ã§ã™ã€‚ Open XML ãƒ•ã‚¡ã‚¤ãƒ«å½¢å¼ã¯ã‚ªãƒ¼ãƒ—ãƒ³ãªè¦æ ¼ã§ã€ZIP ã¨ XML ã¨ã„ã†ã‚ˆãçŸ¥ã‚‰ã‚Œã¦ã„ã‚‹ãƒ†ã‚¯ãƒŽãƒã‚¸ãŒãƒ™ãƒ¼ã‚¹ã«ãªã£ã¦ã„ã‚‹ã®ã§ã€é–‹ç™ºè€…ã«ã¨ã£ã¦ä¾¿åˆ©ã§ã™ã€‚ Open XML SDK ã‚’ä½¿ç”¨ã™ã‚‹ã¨ã€Open XML ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã¨ã€ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸å†…ã®åŸºã«ãªã‚‹ Open XML ã‚¹ã‚
Ikhisa 2011/09/21
open XML

.NET

office
ãƒªãƒ³ã‚¯
æœ€æ–°Excelãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã‚’Javaã§æ“ä½œã™ã‚‹ãŸã‚ã®åŸºç¤Ž
DOMã§Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‚ç…§ãƒ»æ›´æ–°ãƒ»å‰Šé™¤ã™ã‚‹ã«ã¯ï¼Ÿ ãã‚Œã§ã¯ã€Javaæ¨™æº–ã®DOMæ“ä½œAPIã‚’åˆ©ç”¨ã—ã¦ã€Œsample.xlsxã€ã«å«ã¾ã‚Œã‚‹sheet1.xmlã®å†…å®¹ã‚’è§£æžã—ã¾ã™ã€‚ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦è§£å‡ã—ãŸãƒ•ã‚©ãƒ«ãƒ€ã®ä¸ã‹ã‚‰ã€ãƒ†ã‚ã‚¹ãƒˆã‚¨ãƒ‡ã‚£ã‚¿ã§ã€ŒOXMLEditor.javaã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚’é–‹ã„ã¦ãã ã•ã„ã€‚OXMLEditor.javaã®å‡¦ç†ã®æµã‚Œã¯ã€æ¬¡ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ 27 oxml.unzip("sample.xlsx"); /* sample.xlsxã®è§£å‡ */ 28 document = oxml.read( "xl/worksheets/sheet1.xml"); /* sheet1.xmlã®èªã¿è¾¼ã¿ */ 29 30 oxml.showData(); /* Excelãƒ•ã‚¡ã‚¤ãƒ«ãƒ‡ãƒ¼ã‚¿è¡¨ç¤º */ 31 oxml.insertData(2, "æ–°è£½å“å2", 2, 500); /* 2
Ikhisa 2011/09/19
EXCEL

open XML

Java
ãƒªãƒ³ã‚¯
Office (2007) Open XML ãƒ•ã‚¡ã‚¤ãƒ«å½¢å¼ã®æ¦‚è¦
æ¦‚è¦: Office ã‚ªãƒ¼ãƒ—ãƒ³ XML å½¢å¼ã®åˆ©ç‚¹ã‚’èª¬æ˜Žã—ã¾ã™ã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ã€XML ãƒ†ã‚¯ãƒŽãƒã‚¸ã¨ ZIP ã®ãƒ†ã‚¯ãƒŽãƒã‚¸ã‚’ç”¨ã„ã¦ã€Office ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º ã‚·ã‚¹ãƒ†ãƒ ã®é–“ã§ãƒ‡ãƒ¼ã‚¿ã‚’äº¤æ›ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã¾ãŸã€ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«æ±Žç”¨çš„ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãã¾ã™ã€‚ãã—ã¦ã€ãƒ•ã‚¡ã‚¤ãƒ«ç ´æã®ãƒªã‚¹ã‚¯ãŒä½Žæ¸›ã—ã¾ã™ã€‚(26 å°åˆ·ãƒšãƒ¼ã‚¸) Frank Riceã€Microsoft Corporation 2006 å¹´ 5 æœˆ é©ç”¨å¯¾è±¡: 2007 Microsoft Office Suitesã€Microsoft Office Excel 2007ã€Microsoft Office PowerPoint 2007ã€Microsoft Office Word 2007 ç›®æ¬¡ Office ã‚ªãƒ¼ãƒ—ãƒ³ XML ãƒ•ã‚¡ã‚¤ãƒ«å½¢å¼ã®ç´¹ä»‹ æ–°ã—ã„ãƒ•ã‚¡ã‚¤ãƒ«å½¢å¼ã®ã‚·ãƒŠãƒªã‚ª æ–°ã—ã„ãƒ•ã‚¡ã‚¤ãƒ«å½¢å¼ã®åˆ©ç‚¹ Office ã‚ªãƒ¼
Ikhisa 2011/09/19
open XML
ãƒªãƒ³ã‚¯
XML360 - Open XML ã®é–‹ç™ºãƒ©ã‚¤ãƒ–ãƒ©ãƒª
ç¾æ™‚ç‚¹ã§ Open XML ã‚’æ‰±ã†ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’é–‹ç™ºã™ã‚‹éš›ã«åˆ©ç”¨ã§ãã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ System.IO.Packaging ã“ã®åå‰ç©ºé–“ã«å«ã¾ã‚Œã‚‹ã‚¯ãƒ©ã‚¹ç¾¤ã¯ .NET Framework 3.0 ã®ä¸€éƒ¨ã¨ã—ã¦æä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚ C:\Program Files\Reference Assem blies\Microsoft\Framework\v3.0\WindowsBase.dll ã‚’å‚ç…§è¨å®šã«è¿½åŠ ã—ã¦ä½¿ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚Office Open XML - Part 2: Open Packaging Conventions ã«ä»•æ§˜ãŒè¨˜è¿°ã•ã‚Œã¦ã„ã¾ã™ãŒã€ã“ã®ä»•æ§˜ã®å®Ÿè£…ã«ãªã‚Šã¾ã™ã€‚docx ãƒ•ã‚¡ã‚¤ãƒ«ã‚„ xlsx ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ ZIP ãƒ•ã‚¡ã‚¤ãƒ«ã¨ã—ã¦å±•é–‹ã—ã¦ã¿ã‚‹ã¨ [Content_Types].xml ãƒ•ã‚¡ã‚¤ãƒ«ã‚„ _rels ãƒ•ã‚©ãƒ«ãƒ€ãŒå…±é€šã—ã¦å˜åœ¨ã™ã‚‹ã“ã¨ãŒåˆ†ã‹ã‚‹ã¨æ€ã„ã¾
Ikhisa 2011/09/19
XML

office

open XML
ãƒªãƒ³ã‚¯
1