001    /*
002     * Copyright (c) 2009 The openGion Project.
003     *
004     * Licensed under the Apache License, Version 2.0 (the "License");
005     * you may not use this file except in compliance with the License.
006     * You may obtain a copy of the License at
007     *
008     *     http://www.apache.org/licenses/LICENSE-2.0
009     *
010     * Unless required by applicable law or agreed to in writing, software
011     * distributed under the License is distributed on an "AS IS" BASIS,
012     * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND,
013     * either express or implied. See the License for the specific language
014     * governing permissions and limitations under the License.
015     */
016    package org.opengion.plugin.io;
017    
018    import java.io.BufferedReader;
019    import java.io.IOException;
020    import java.io.InputStream;
021    import java.util.ArrayList;
022    import java.util.List;
023    import java.util.zip.ZipEntry;
024    import java.util.zip.ZipFile;
025    
026    import javax.xml.parsers.DocumentBuilder;
027    import javax.xml.parsers.DocumentBuilderFactory;
028    import javax.xml.parsers.ParserConfigurationException;
029    
030    import org.opengion.fukurou.util.StringUtil;
031    import org.opengion.fukurou.util.Closer;                        // 5.5.2.6 (2012/05/25)
032    import org.opengion.hayabusa.common.HybsSystem;
033    import org.opengion.hayabusa.common.HybsSystemException;
034    import org.opengion.hayabusa.db.DBTableModelUtil;
035    import org.w3c.dom.Document;
036    import org.w3c.dom.Element;
037    import org.w3c.dom.NodeList;
038    import org.xml.sax.SAXException;
039    
040    /**
041     * XML繝代?繧ｵ縺ｫ繧医ｋ縲＾penOffice.org Calc縺ｮ陦ｨ險育ｮ励ラ繧ｭ繝･繝｡繝ｳ繝医ヵ繧｡繧､繝ｫ繧定ｪｭ縺ｿ蜿悶ｋ螳溯｣?け繝ｩ繧ｹ縺ｧ縺吶?
042     *
043     * 竭?き繝ｩ繝?錐縺梧欠螳壹＆繧後※縺?ｋ蝣ｴ蜷?
044     *  #NAME縺ｧ蟋九∪繧玖｡後ｒ讀懃ｴ｢縺励?縺昴?陦後?縺昴ｌ縺槭ｌ縺ｮ蛟､繧偵き繝ｩ繝?錐縺ｨ縺励※蜃ｦ逅?＠縺ｾ縺吶?
045     *  #NAME縺ｧ蟋九∪繧玖｡後ｈ繧贋ｻ･蜑阪?陦後↓縺､縺?※縺ｯ縲∝?縺ｦ辟｡隕悶＆繧後∪縺吶?
046     *  縺ｾ縺溘?#NAME繧医ｊ蜑阪?繧ｫ繝ｩ繝?所縺ｳ縲?NAME縺ｮ陦後?蛟､縺君ULL(繧ｫ繝ｩ繝?錐縺瑚ｨｭ螳壹＆繧後※縺?↑縺?繧ｫ繝ｩ繝?ｂ
047     *  辟｡隕悶＠縺ｾ縺吶?
048     *  隱ｭ縺ｿ鬟帙?縺輔ｌ縺溘き繝ｩ繝??縺ｫ蜈･蜉帙＆繧後◆蛟､縺ｯ蜿悶ｊ霎ｼ縺ｾ繧後∪縺帙ｓ縲?
049     *  縺ｾ縺溘?#NAME陦御ｻ･髯阪?#縺ｧ蟋九∪繧玖｡後?縲√さ繝｡繝ｳ繝郁｡後→縺ｿ縺ｪ縺輔ｌ蜃ｦ逅?＆繧後∪縺帙ｓ縲?
050     *
051     * 竭｡繧ｫ繝ｩ繝?錐縺梧欠螳壹＆繧後※縺?ｋ蝣ｴ蜷?
052     *  謖?ｮ壹＆繧後◆繧ｫ繝ｩ繝?錐縺ｫ蝓ｺ縺･縺阪?蛟､繧貞叙繧願ｾｼ縺ｿ縺ｾ縺吶?
053     *  繧ｫ繝ｩ繝?錐縺ｮ鬆?分縺ｨ縲√す繝ｼ繝医↓險倩ｿｰ縺輔ｌ縺ｦ縺?ｋ蛟､縺ｮ鬆?分縺ｯ荳??縺励※縺?ｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?
054     *  謖?ｮ壹＆繧後◆繧ｫ繝ｩ繝?焚繧定ｶ?∴繧句?縺ｮ蛟､縺ｫ縺､縺?※縺ｯ蜈ｨ縺ｦ辟｡隕悶＆繧後∪縺吶?
055     *  #縺ｧ蟋九∪繧玖｡後?縲√さ繝｡繝ｳ繝郁｡後→縺ｿ縺ｪ縺輔ｌ蜃ｦ逅?＆繧後∪縺帙ｓ縲?
056     *
057     * 縺ｾ縺溘?縺?★繧後?蝣ｴ蜷医ｂ蜈ｨ縺上ョ繝ｼ繧ｿ縺悟ｭ伜惠縺励※縺?↑縺?｡後?隱ｭ縺ｿ鬟帙?縺輔ｌ縺ｾ縺吶?
058     *
059     * @og.group 繝輔ぃ繧､繝ｫ蜈･蜉?
060     *
061     * @version 4.0
062     * @author Hiroki Nakamura
063     * @since JDK5.0,
064     */
065    public class TableReader_Calc extends TableReader_Default {
066            // * 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶? {@value} */
067            private static final String VERSION = "5.5.7.2 (2012/10/09)";
068    
069            private String          sheetName               = null;
070            private String          sheetNos                = null;         // 5.5.7.2 (2012/10/09)
071            private String          filename                = null;
072            private int                     numberOfRows    = 0;
073            private int                     firstClmIdx             = 0;
074            private int[]           valueClmIdx             = null;
075    
076            /**
077             * DBTableModel 縺九ｉ 蜷?ｽ｢蠑上?繝??繧ｿ繧剃ｽ懈?縺励※,BufferedReader 繧医ｊ隱ｭ縺ｿ蜿悶ｊ縺ｾ縺吶?
078             * 繧ｳ繝｡繝ｳ繝?遨ｺ陦後ｒ髯､縺阪?譛??縺ｮ陦後?縲??逶ｮ蜷阪′蠢?ｦ√〒縺吶?
079             * (菴?＠縲√き繝ｩ繝?錐繧呈欠螳壹☆繧九％縺ｨ縺ｧ縲??逶ｮ蜷阪ｒ逵∫払縺吶ｋ縺薙→縺後〒縺阪∪縺?
080             * 縺昴ｌ莉･髯阪?縲√さ繝｡繝ｳ繝?遨ｺ陦後ｒ髯､縺阪?繝??繧ｿ縺ｨ縺励※隱ｭ縺ｿ霎ｼ繧薙〒縺?″縺ｾ縺吶?
081             * 縺薙?繝｡繧ｽ繝?ラ縺ｯ縲，alc 隱ｭ縺ｿ霎ｼ縺ｿ譎ゅ↓菴ｿ逕ｨ縺励∪縺吶?
082             *
083             * @og.rev 4.3.5.0 (2009/02/01) toArray 縺吶ｋ縺ｨ縺阪↓縲√し繧､繧ｺ縺ｮ蛻晄悄蛟､謖?ｮ壹ｒ霑ｽ蜉?
084             * @og.rev 5.5.7.2 (2012/10/09) sheetNos 霑ｽ蜉?↓繧医ｋ隍?焚繧ｷ繝ｼ繝医?繝槭?繧ｸ隱ｭ縺ｿ蜿悶ｊ繧ｵ繝昴?繝?
085             *
086             * @see #isExcel()
087             */
088            @Override
089            public void readDBTable() {
090    
091                    ZipFile zipFile = null;
092                    boolean errFlag = false;        // 5.0.0.1 (2009/08/15) finally 繝悶Ο繝?け縺ｮ throw 繧帝∩縺代ｋ縲?
093                    try {
094                            // OpenOffice.org ods繝輔ぃ繧､繝ｫ繧帝幕縺?
095                            zipFile = new ZipFile( filename );
096    
097                            ZipEntry entry = zipFile.getEntry( "content.xml" );
098                            if ( null == entry ) {
099                                    String errMsg = "ODS繝輔ぃ繧､繝ｫ荳ｭ縺ｫ繝輔ぃ繧､繝ｫcontent.xml縺悟ｭ伜惠縺励∪縺帙ｓ縲?;
100                                    throw new HybsSystemException( errMsg );
101                            }
102    
103                            // content.xml繧偵ヱ繝ｼ繧ｹ縺励?陦後?蛻怜腰菴阪?繧ｪ繝悶ず繧ｧ繧ｯ繝医↓蛻?ｧ｣縺励∪縺吶?
104                            DomOdsParser odsParser = new DomOdsParser();
105    //                      odsParser.doParse( zipFile.getInputStream( entry ), sheetName );
106                            odsParser.doParse( zipFile.getInputStream( entry ), sheetName , sheetNos );             // 5.5.7.2 (2012/10/09) sheetNos 蟇ｾ蠢?
107                            List<RowInfo> rowInfoList = odsParser.getRowInfoList();
108    
109                            // 4.3.5.0 (2009/02/01) toArray 縺吶ｋ縺ｨ縺阪↓縲√し繧､繧ｺ縺ｮ蛻晄悄蛟､謖?ｮ壹ｒ霑ｽ蜉?
110    //                      makeDBTableModel( rowInfoList.toArray( new RowInfo[0] ) );
111                            makeDBTableModel( rowInfoList.toArray( new RowInfo[rowInfoList.size()] ) );
112                    }
113                    catch ( IOException ex ) {
114                            String errMsg = "繝輔ぃ繧､繝ｫ隱ｭ霎ｼ縺ｿ繧ｨ繝ｩ繝ｼ[" + filename + "]";
115                            throw new HybsSystemException( errMsg, ex );
116                    }
117                    finally {
118                            // 5.5.2.6 (2012/05/25) fukurou.util.Closer#zipClose( ZipFile ) 繧貞茜逕ｨ縺吶ｋ繧医≧縺ｫ菫ｮ豁｣縲?
119                            errFlag = ! Closer.zipClose( zipFile );         // OK 縺ｮ蝣ｴ蜷医?true 縺ｪ縺ｮ縺ｧ縲∝渚霆｢縺励※縺翫￥縲?
120    //                      if ( null != zipFile ) {
121    //                              try {
122    //                                      zipFile.close();
123    //                              }
124    //                              catch ( IOException ex ) {
125    //                                      errFlag = true;
126    //                              }
127    //                      }
128                    }
129    
130                    if( errFlag ) {
131                            String errMsg = "ODS繝輔ぃ繧､繝ｫ縺ｮ繧ｯ繝ｭ繝ｼ繧ｺ荳ｭ縺ｫ繧ｨ繝ｩ繝ｼ縺檎匱逕溘＠縺ｾ縺励◆[" + filename + "]";
132                            throw new HybsSystemException ( errMsg );
133                    }
134    
135    //              finally {
136    //                      if ( null != zipFile )
137    //                              try {
138    //                                      zipFile.close();
139    //                              }
140    //                              catch ( IOException ex ) {
141    //                                      String errMsg = "ODS繝輔ぃ繧､繝ｫ縺ｮ繧ｯ繝ｭ繝ｼ繧ｺ荳ｭ縺ｫ繧ｨ繝ｩ繝ｼ縺檎匱逕溘＠縺ｾ縺励◆[" + filename + "]";
142    //                                      throw new HybsSystemException ( errMsg, ex );
143    //                              }
144    //              }
145            }
146    
147            /**
148             * DBTableModel 縺九ｉ 蜷?ｽ｢蠑上?繝??繧ｿ繧剃ｽ懈?縺励※,BufferedReader 繧医ｊ隱ｭ縺ｿ蜿悶ｊ縺ｾ縺吶?
149             * 縺薙?繝｡繧ｽ繝?ラ縺ｯ縲√％縺ｮ螳溯｣?け繝ｩ繧ｹ縺ｧ縺ｯ菴ｿ逕ｨ縺ｧ縺阪∪縺帙ｓ縲?
150             *
151             * @param reader 蜷?ｽ｢蠑上?繝??繧ｿ(菴ｿ逕ｨ縺励※縺?∪縺帙ｓ)
152             */
153            @Override
154            public void readDBTable( final BufferedReader reader ) {
155                    String errMsg = "縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?;
156                    throw new UnsupportedOperationException( errMsg );
157            }
158    
159            /**
160             * DBTableModel縺ｮ繝??繧ｿ縺ｨ縺励※Calc繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ霎ｼ繧?→縺阪?繧ｷ繝ｼ繝亥錐繧定ｨｭ螳壹＠縺ｾ縺吶?
161             * 縺薙ｌ縺ｫ繧医ｊ縲∬､?焚縺ｮ蠖｢蠑上?逡ｰ縺ｪ繧九ョ繝ｼ繧ｿ繧帝?谺｡隱ｭ縺ｿ霎ｼ繧?％縺ｨ繧??繧ｷ繝ｼ繝医ｒ謖?ｮ壹＠縺ｦ
162             * 隱ｭ縺ｿ蜿悶ｋ縺薙→縺悟庄閭ｽ縺ｫ縺ｪ繧翫∪縺吶?
163             * sheetNos 縺ｨ sheetName 縺悟酔譎ゅ↓謖?ｮ壹＆繧後◆蝣ｴ蜷医?縲《heetNos 縺悟━蜈医＆繧後∪縺吶?繧ｨ繝ｩ繝ｼ縺ｫ縺ｯ縺ｪ繧峨↑縺??縺ｧ縺疲ｳｨ諢上￥縺?＆縺??
164             * 縺ｮ縺ｧ縺疲ｳｨ諢上￥縺?＆縺??
165             *
166             * @param sheetName 繧ｷ繝ｼ繝亥錐
167             */
168            @Override
169            public void setSheetName( final String sheetName ) {
170                    this.sheetName = sheetName;
171            }
172    
173            /**
174             * Calc繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ霎ｼ繧?→縺阪?繧ｷ繝ｼ繝育分蜿ｷ繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:0)縲?
175             *
176             * Calc隱ｭ縺ｿ霎ｼ縺ｿ譎ゅ↓隍?焚繧ｷ繝ｼ繝医ｒ繝槭?繧ｸ縺励※蜿悶ｊ霎ｼ縺ｿ縺ｾ縺吶?
177             * 繧ｷ繝ｼ繝育分蜿ｷ縺ｯ縲? 縺九ｉ蟋九∪繧区焚蟄励〒陦ｨ縺励∪縺吶?
178             * 繝倥ャ繝??縺ｯ縲∵怙蛻昴?繧ｷ繝ｼ繝医?繧ｫ繝ｩ繝?ｽ咲ｽｮ縺ｫ蜷医ｏ縺帙∪縺吶??医?繝?ム繝ｼ繧ｿ繧､繝医Ν縺ｮ閾ｪ蜍戊ｪ崎ｭ倥?縺ゅｊ縺ｾ縺帙ｓ縲ゑｼ?
179             * 繧医▲縺ｦ縲∵欠螳壹☆繧九す繝ｼ繝医?縲√☆縺ｹ縺ｦ蜷御ｸ?Ξ繧､繧｢繧ｦ繝医〒縺ｪ縺?→蜿悶ｊ霎ｼ縺ｿ譎ゅ↓繧ｫ繝ｩ繝??縺壹ｌ縺檎匱逕溘＠縺ｾ縺吶?
180             * 
181             * 繧ｷ繝ｼ繝育分蜿ｷ縺ｮ謖?ｮ壹?縲√き繝ｳ繝槫玄蛻?ｊ縺ｧ縲∬､?焚謖?ｮ壹〒縺阪∪縺吶?縺ｾ縺溘?N-M 縺ｮ讒倥↓繝上う繝輔Φ縺ｧ郢九￡繧九％縺ｨ縺ｧ縲?
182             * N 逡ｪ縺九ｉ縲｀ 逡ｪ縺ｮ繧ｷ繝ｼ繝育ｯ?峇繧剃ｸ?峡謖?ｮ壼庄閭ｽ縺ｧ縺吶?縺ｾ縺溘?"*" 縺ｫ繧医ｋ縲∝?繧ｷ繝ｼ繝域欠螳壹′蜿ｯ閭ｽ縺ｧ縺吶?
183             * 縺薙ｌ繧峨?邨?∩蜷医ｏ縺帙ｂ蜿ｯ閭ｽ縺ｧ縺吶???0,1,3,5-8,10-* ??
184             * 縺溘□縺励?"*" 縺ｫ髢｢縺励※縺ｯ萓句､也噪縺ｫ縲∽ｸ?枚蟄励□縺代〒縲√☆縺ｹ縺ｦ縺ｮ繧ｷ繝ｼ繝医ｒ陦ｨ縺吶°縲¨-* 繧呈怙蠕後↓謖?ｮ壹☆繧九°縺ｮ
185             * 縺ｩ縺｡繧峨°縺ｧ縺吶?騾比ｸｭ縺ｫ縺ｯ縲?*" 縺ｯ縲∫樟繧後∪縺帙ｓ縲?
186             * 繧ｷ繝ｼ繝育分蜿ｷ縺ｯ縲?㍾隍?1,1,2,2)縲??霆｢(3,2,1) 縺ｧ縺ｮ謖?ｮ壹′蜿ｯ閭ｽ縺ｧ縺吶?縺薙ｌ縺ｯ縲√◎縺ｮ謖?ｮ夐?縺ｧ縲∬ｪｭ縺ｿ霎ｼ縺ｾ繧後∪縺吶?
187             * sheetNos 縺ｨ sheetName 縺悟酔譎ゅ↓謖?ｮ壹＆繧後◆蝣ｴ蜷医?縲《heetNos 縺悟━蜈医＆繧後∪縺吶?繧ｨ繝ｩ繝ｼ縺ｫ縺ｯ縺ｪ繧峨↑縺??縺ｧ縺疲ｳｨ諢上￥縺?＆縺??
188             * 縺薙?繝｡繧ｽ繝?ラ縺ｯ縲（sExcel() == true 縺ｮ蝣ｴ蜷医?縺ｿ蛻ｩ逕ｨ縺輔ｌ縺ｾ縺吶?
189             * 
190             * 蛻晄悄蛟､縺ｯ縲??育ｬｬ荳?す繝ｼ繝茨ｼ?縺ｧ縺吶?
191             *
192             * 窶ｻ 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?
193             *
194             * @og.rev 5.5.7.2 (2012/10/09) 譁ｰ隕剰ｿｽ蜉?
195             *
196             * @param   sheetNos Calc繝輔ぃ繧､繝ｫ縺ｮ繧ｷ繝ｼ繝育分蜿ｷ??縺九ｉ蟋九∪繧具ｼ?
197             * @see         #setSheetName( String ) 
198             */
199            @Override
200            public void setSheetNos( final String sheetNos ) {
201                    this.sheetNos = sheetNos;
202            }
203    
204            /**
205             * 縺薙?繧ｯ繝ｩ繧ｹ縺後?EXCEL蟇ｾ蠢懈ｩ溯?繧呈戟縺｣縺ｦ縺?ｋ縺九←縺?°繧定ｿ斐＠縺ｾ縺吶?
206             *
207             * EXCEL蟇ｾ蠢懈ｩ溯?縺ｨ縺ｯ縲√す繝ｼ繝亥錐縺ｮ繧ｻ繝?ヨ縲∬ｪｭ縺ｿ霎ｼ縺ｿ蜈?ヵ繧｡繧､繝ｫ縺ｮ File繧ｪ繝悶ず繧ｧ繧ｯ繝亥叙蠕励↑縺ｩ縺ｮ縲∫音谿頑ｩ溯?縺ｧ縺吶?
208             * 譛ｬ譚･縺ｯ縲√う繝ｳ繧ｿ繝ｼ繝輔ぉ繝ｼ繧ｹ繧貞?縺代ｋ縺ｹ縺阪→閠?∴縺ｾ縺吶′縲》aglib 繧ｯ繝ｩ繧ｹ遲峨? 髢｢菫ゅ′縺ゅｊ縲∝撫縺?粋繧上○縺ｫ繧医ｋ譚｡莉ｶ蛻?ｲ舌〒蟇ｾ蠢懊＠縺ｾ縺吶?
209             *
210             * @return      EXCEL蟇ｾ蠢懈ｩ溯?繧呈戟縺｣縺ｦ縺?ｋ縺九←縺?°(蟶ｸ縺ｫtrue)
211             */
212            @Override
213            public boolean isExcel() {
214                    return true;
215            }
216    
217            /**
218             * 隱ｭ縺ｿ蜿悶ｊ蜈?ヵ繧｡繧､繝ｫ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺吶?(DIR + Filename) 縺薙ｌ縺ｯ縲＾penOffice.org
219             * Calc霑ｽ蜉?ｩ溯?縺ｨ縺励※螳溯｣?＆繧後※縺?∪縺吶?
220             *
221             * @param filename 隱ｭ縺ｿ蜿悶ｊ蜈?ヵ繧｡繧､繝ｫ蜷?
222             */
223            @Override
224            public void setFilename( final String filename ) {
225                    this.filename = filename;
226                    if ( filename == null ) {
227                            String errMsg = "繝輔ぃ繧､繝ｫ蜷阪′謖?ｮ壹＆繧後※縺?∪縺帙ｓ縲?;
228                            throw new HybsSystemException( errMsg );
229                    }
230            }
231    
232            /**
233             * ODS繝輔ぃ繧､繝ｫ繧偵ヱ繝ｼ繧ｹ縺励◆邨先棡縺九ｉDBTableModel繧堤函謌舌＠縺ｾ縺吶?
234             *
235             * @og.rev 5.1.6.0 (2010/05/01) skipRowCount縺ｮ霑ｽ蜉?
236             *
237             * @param rowInfoList 陦後が繝悶ず繧ｧ繧ｯ繝医?驟榊?
238             */
239            private void makeDBTableModel( final RowInfo[] rowInfoList ) {
240                    // 繧ｫ繝ｩ繝?錐縺梧欠螳壹＆繧後※縺?ｋ蝣ｴ蜷医?縲∝━蜈医☆繧九?
241                    if( columns != null && columns.length() > 0 ) {
242                            makeHeaderFromClms();
243                    }
244    
245    //              for( RowInfo rowInfo : rowInfoList ) {
246                    int skip = getSkipRowCount();                                           // 5.1.6.0 (2010/05/01)
247                    for( int row=skip; row<rowInfoList.length; row++ ) {
248                            RowInfo rowInfo = rowInfoList[row];                             // 5.1.6.0 (2010/05/01)
249                            if( valueClmIdx == null ) {
250                                    makeHeader( rowInfo );
251                            }
252                            else {
253                                    makeBody( rowInfo );
254                            }
255                    }
256    
257                    // 譛?ｾ後∪縺ｧ縲?NAME 縺瑚ｦ九▽縺九ｉ辟｡縺九▲縺溷?蜷?
258                    if ( valueClmIdx == null ) {
259                            String errMsg = "譛?ｾ後∪縺ｧ縲?NAME 縺瑚ｦ九▽縺九ｊ縺ｾ縺帙ｓ縺ｧ縺励◆縲? + HybsSystem.CR + "繝輔ぃ繧､繝ｫ縺檎ｩｺ縺九?繧ゅ＠縺上?謳榊す縺励※縺?ｋ蜿ｯ閭ｽ諤ｧ縺後≠繧翫∪縺吶?" + HybsSystem.CR;
260                            throw new HybsSystemException( errMsg );
261                    }
262            }
263    
264            /**
265             * 謖?ｮ壹＆繧後◆繧ｫ繝ｩ繝?ｸ?ｦｧ縺九ｉ繝倥ャ繝??諠??繧堤函謌舌＠縺ｾ縺吶?
266             *
267             * @og.rev 5.1.6.0 (2010/05/01) useNumber 縺ｮ霑ｽ蜉?
268             */
269            private void makeHeaderFromClms() {
270                    table = DBTableModelUtil.newDBTable();
271                    String[] names = StringUtil.csv2Array( columns );
272                    table.init( names.length );
273                    setTableDBColumn( names ) ;
274                    valueClmIdx = new int[names.length];
275                    int adrs = (isUseNumber()) ? 1:0 ;      // useNumber =true 縺ｮ蝣ｴ蜷医?縲?ｼ台ｻｶ逶ｮ(No)縺ｯ隱ｭ縺ｿ鬟帙?縺吶?
276                    for( int i=0; i<names.length; i++ ) {
277    //                      valueClmIdx[i] = i;
278                            valueClmIdx[i] = adrs++;
279                    }
280            }
281    
282            /**
283             * 繝倥ャ繝??諠??繧定ｪｭ縺ｿ蜿悶ｊ縲．BTableModel縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ譁ｰ隕上↓菴懈?縺励∪縺吶?
284             * 窶ｻ 莉悶?TableReader縺ｨ逡ｰ縺ｪ繧翫?#NAME 縺瑚ｦ九▽縺九ｋ縺ｾ縺ｧ縲∬ｪｭ縺ｿ鬟帙?縺吶?
285             *
286             * @og.rev 4.3.5.0 (2009/02/01) toArray 縺吶ｋ縺ｨ縺阪↓縲√し繧､繧ｺ縺ｮ蛻晄悄蛟､謖?ｮ壹ｒ霑ｽ蜉?
287             *
288             * @param rowInfo 陦後が繝悶ず繧ｧ繧ｯ繝?
289             */
290            private void makeHeader( final RowInfo rowInfo ) {
291    //              int rowRepeat = rowInfo.rowRepeat;
292                    CellInfo[] cellInfos = rowInfo.cellInfos;
293    
294                    int cellLen = cellInfos.length;
295                    int runPos = 0;
296                    ArrayList<String> nameList = null;
297                    ArrayList<Integer> posList = null;
298                    for ( int idx = 0; idx < cellLen; idx++ ) {
299                            // 繝??繝悶Ν縺ｮ繝倥ャ繝?#NAME)縺瑚ｦ九▽縺九ｋ蜑阪?陦後?蛻励?蜈ｨ縺ｦ辟｡隕悶＆繧後ｋ
300                            CellInfo cellInfo = cellInfos[idx];
301                            String text = cellInfo.text.trim();
302    
303                            for ( int cellRep = 0; cellRep < cellInfo.colRepeat; cellRep++ ) {
304                                    // 遨ｺ逋ｽ縺ｮ繝倥ャ繝??辟｡隕?縺昴?蛻励↓繝??繧ｿ縺悟?縺｣縺ｦ縺?※繧りｪｭ縺ｾ縺ｪ縺?
305                                    if ( text.length() != 0 ) {
306                                            if ( firstClmIdx == 0 && text.equalsIgnoreCase( "#NAME" ) ) {
307                                                    nameList = new ArrayList<String>();
308                                                    posList = new ArrayList<Integer>();
309                                                    table = DBTableModelUtil.newDBTable();
310                                                    firstClmIdx = idx;
311                                            }
312                                            else if ( nameList != null ) {
313                                                    nameList.add( text );
314                                                    posList.add( runPos );
315                                            }
316                                    }
317                                    runPos++;
318                            }
319                    }
320    
321    //              if ( posList != null && posList.size() > 0 ) {
322                    if ( posList != null && ! posList.isEmpty() ) {
323                            table = DBTableModelUtil.newDBTable();
324    //                      String[] names = nameList.toArray( new String[0] );
325    //                      table.init( names.length );
326                            // 4.3.5.0 (2009/02/01) 繧ｵ繧､繧ｺ縺ｮ蛻晄悄蛟､謖?ｮ?
327                            int size = nameList.size();
328                            String[] names = nameList.toArray( new String[size] );
329                            table.init( size );
330                            setTableDBColumn( names );
331    
332                            valueClmIdx = new int[posList.size()];
333                            for( int i = 0; i<posList.size(); i++ ) {
334                                    valueClmIdx[i] = posList.get( i ).intValue();
335                            }
336                    }
337            }
338    
339            /**
340             * 陦後?蛻?繧ｻ繝ｫ)蜊倅ｽ阪?諠??繧定ｪｭ縺ｿ蜿悶ｊ縲．BTableModel縺ｫ蛟､繧偵そ繝?ヨ縺励∪縺?
341             *
342             * @og.rev 5.2.1.0 (2010/10/01) setTableColumnValues 繝｡繧ｽ繝?ラ繧堤ｵ檎罰縺励※縲√ユ繝ｼ繝悶Ν縺ｫ繝??繧ｿ繧偵そ繝?ヨ縺吶ｋ縲?
343             *
344             * @param rowInfo 陦後が繝悶ず繧ｧ繧ｯ繝?
345             */
346            private void makeBody( final RowInfo rowInfo ) {
347                    int rowRepeat = rowInfo.rowRepeat;
348                    CellInfo[] cellInfos = rowInfo.cellInfos;
349                    int cellLen = cellInfos.length;
350                    boolean isExistData = false;
351    
352                    List<String> colData = new ArrayList<String>();
353                    for ( int cellIdx = 0; cellIdx < cellLen; cellIdx++ ) {
354                            CellInfo cellInfo = cellInfos[cellIdx];
355                            for ( int cellRep = 0; cellRep < cellInfo.colRepeat; cellRep++ ) {
356                                    colData.add( cellInfo.text );
357                                    if( cellInfo.text.length() > 0 ) {
358                                            isExistData = true;
359                                    }
360                            }
361                    }
362    
363                    if( isExistData ) {
364                            // 蛻昴ａ縺ｮ蛻?#NAME縺瑚ｨ倩ｿｰ縺輔ｌ縺ｦ縺?◆蛻?縺ｮ蛟､縺?縺ｧ蟋九∪縺｣縺ｦ縺?ｋ蝣ｴ蜷医?縲√さ繝｡繝ｳ繝郁｡後→縺ｿ縺ｪ縺吶?
365                            String firstVal = colData.get( firstClmIdx );
366                            if( firstVal.length() > 0 && firstVal.startsWith( "#" ) ) {
367                                    return;
368                            }
369                            else {
370                                    String[] vals = new String[valueClmIdx.length];
371                                    for( int col = 0; col < valueClmIdx.length; col++ ) {
372                                            vals[col] = colData.get( valueClmIdx[col] );
373                                    }
374    
375                                    // 驥崎､?｡後?郢ｰ繧願ｿ斐＠蜃ｦ逅?
376                                    for ( int rowIdx = 0; rowIdx < rowRepeat; rowIdx++ ) {
377                                            // 繝??繝悶Ν繝｢繝?Ν縺ｫ繝??繧ｿ繧偵そ繝?ヨ
378                                            if ( numberOfRows < getMaxRowCount() ) {
379                                                    setTableColumnValues( vals );           // 5.2.1.0 (2010/10/01)
380    //                                              table.addColumnValues( vals );
381                                                    numberOfRows++;
382                                            }
383                                            else {
384                                                    table.setOverflow( true );
385                                            }
386                                    }
387                            }
388                    }
389                    // 蜈ｨ縺上ョ繝ｼ繧ｿ縺悟ｭ伜惠縺励↑縺?｡後?隱ｭ縺ｿ鬟帙?縺?
390                    else {
391                            return;
392                    }
393            }
394    
395            /**
396             * ODS繝輔ぃ繧､繝ｫ縺ｫ蜷ｫ縺ｾ繧後ｋcontent.xml繧奪OM繝代?繧ｵ繝ｼ縺ｧ繝代?繧ｹ縺励?陦後?蛻怜腰菴阪↓
397             * 繧ｪ繝悶ず繧ｧ繧ｯ繝医↓螟画鋤縺励∪縺吶?
398             *
399             */
400            private static class DomOdsParser{
401    
402                    // OpenOffice.org Calc tag Names
403    //              private static final String OFFICE_DOCUMENT_CONTEBT_ELEM = "office:document-content";
404    //              private static final String OFFICE_SPREADSHEET_ELEM = "office:spreadsheet";
405                    private static final String TABLE_TABLE_ELEM = "table:table";
406    //              private static final String TABLE_TABLE_COLUMN_ELEM = "table:table-column";
407                    private static final String TABLE_TABLE_ROW_ELEM = "table:table-row";
408                    private static final String TABLE_TABLE_CELL_ELEM = "table:table-cell";
409                    private static final String TEXT_P_ELEM = "text:p";
410    
411                    // Sheet tag attributes
412                    private static final String TABLE_NAME_ATTR = "table:name";
413    //              private static final String OFFICE_VALUE_YPE_ATTR = "office:value-type";
414                    private static final String TABLE_NUMBER_ROWS_REPEATED_ATTR = "table:number-rows-repeated";
415                    private static final String TABLE_NUMBER_COLUMNS_REPEATED_ATTR = "table:number-columns-repeated";
416    //              private static final String TABLE_NUMBER_ROWS_SPANNED_ATTR = "table:number-rows-spanned";
417    //              private static final String TABLE_NUMBER_COLUMNS_SPANNED_ATTR = "table:number-columns-spanned";
418    
419    //              ArrayList<RowInfo> rowInfoList = new ArrayList<RowInfo>();
420                    List<RowInfo> rowInfoList = new ArrayList<RowInfo>();
421                    /**
422                     * Dom繝代?繧ｵ縺ｧXML繧偵ヱ繝ｼ繧ｹ縺吶ｋ
423                     *
424                     * @og.rev 5.5.7.2 (2012/10/09) sheetNos 霑ｽ蜉?↓繧医ｋ隍?焚繧ｷ繝ｼ繝医?繝槭?繧ｸ隱ｭ縺ｿ蜿悶ｊ繧ｵ繝昴?繝?
425                     *
426                     * @param inputStream InputStream
427                     * @param sheetName String
428                     * @param sheetNos  String
429                     */
430    //              public void doParse( final InputStream inputStream, final String sheetName ) {
431                    public void doParse( final InputStream inputStream, final String sheetName, final String sheetNos ) {
432                            try {
433                                    // 繝峨く繝･繝｡繝ｳ繝医ン繝ｫ繝??繝輔ぃ繧ｯ繝医Μ繧堤函謌?
434                                    DocumentBuilderFactory dbFactory = DocumentBuilderFactory.newInstance();
435                                    dbFactory.setNamespaceAware( true );
436    
437                                    // 繝峨く繝･繝｡繝ｳ繝医ン繝ｫ繝??繧堤函謌?
438                                    DocumentBuilder dBuilder = dbFactory.newDocumentBuilder();
439                                    // 繝代?繧ｹ繧貞ｮ溯｡後＠縺ｦDocument繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ蜿門ｾ?
440                                    Document doc = dBuilder.parse( inputStream );
441    //                              processBook( doc, sheetName );
442                                    processBook( doc, sheetName, sheetNos );                        // 5.5.7.2 (2012/10/09) sheetNos 霑ｽ蜉?
443                            }
444                            catch ( ParserConfigurationException ex ) {
445                                    throw new HybsSystemException( ex );
446                            }
447                            catch ( SAXException ex ) {
448                                    String errMsg = "ODS繝輔ぃ繧､繝ｫ荳ｭ縺ｫ蜷ｫ縺ｾ繧後ｋcontent.xml縺傾ML蠖｢蠑上〒縺ｯ縺ゅｊ縺ｾ縺帙ｓ縲?;
449                                    throw new HybsSystemException( errMsg, ex );
450                            }
451                            catch ( IOException ex ) {
452                                    throw new HybsSystemException( ex );
453                            }
454                    }
455    
456                    /**
457                     * 陦後が繝悶ず繧ｧ繧ｯ繝医?繝ｪ繧ｹ繝医ｒ霑斐＠縺ｾ縺吶?
458                     *
459                     * @return List<RowInfo>
460                     */
461                    public List<RowInfo> getRowInfoList() {
462                            return rowInfoList;
463                    }
464    
465                    /**
466                     * ODS繝輔ぃ繧､繝ｫ蜈ｨ菴薙?繝代?繧ｹ繧定｡後＞縲∝?逅?ｯｾ雎｡縺ｨ縺ｪ繧九す繝ｼ繝医ｒ讀懃ｴ｢縺励∪縺吶?
467                     *
468                     * @og.rev 5.5.7.2 (2012/10/09) sheetNos 霑ｽ蜉?↓繧医ｋ隍?焚繧ｷ繝ｼ繝医?繝槭?繧ｸ隱ｭ縺ｿ蜿悶ｊ繧ｵ繝昴?繝?
469                     *
470                     * @param doc Document
471                     * @param sheetName String
472                     * @param sheetNos  String
473                     */
474    //              private void processBook( final Document doc, final String sheetName ) {
475                    private void processBook( final Document doc, final String sheetName, final String sheetNos ) {
476                            // table:table繧呈爾縺?
477                            NodeList nodetList = doc.getElementsByTagName( TABLE_TABLE_ELEM );
478                            int listLen = nodetList.getLength();
479    
480    //                      Element sheet = null;
481                            Element[] sheets = null ;                       // 5.5.7.2 (2012/10/09)
482    
483                            // 5.5.7.2 (2012/10/09) 隍?焚繧ｷ繝ｼ繝医?繝槭?繧ｸ隱ｭ縺ｿ蜿悶ｊ縲?sheetNos 縺ｮ謖?ｮ壹′蜆ｪ蜈医＆繧後ｋ縲?
484                            if( sheetNos != null && sheetNos.length() > 0 ) {
485                                    String[] sheetList = StringUtil.csv2ArrayExt( sheetNos , listLen-1 );   // 譛?､ｧ繧ｷ繝ｼ繝育分蜿ｷ縺ｯ縲√す繝ｼ繝域焚-1
486                                    sheets = new Element[sheetList.length];
487                                    for( int i=0; i<sheetList.length; i++ ) {
488                                            sheets[i] = (Element)nodetList.item( Integer.parseInt( sheetList[i] ) );
489                                    }
490                            }
491                            else if( sheetName != null && sheetName.length() > 0 ) {
492                                    Element sheet = null;
493                                    for ( int idx = 0; idx < listLen; idx++ ) {
494                                            Element st = (Element)nodetList.item( idx );
495                                            if ( sheetName.equals( st.getAttribute( TABLE_NAME_ATTR ) ) ) {
496                                                    sheet = st;
497                                                    break;
498                                            }
499                                    }
500                                    if( sheet == null ) {
501                                            String errMsg = "蟇ｾ蠢懊☆繧九す繝ｼ繝医′蟄伜惠縺励∪縺帙ｓ縲?sheetName=[" + sheetName + "]" ;
502                                            throw new HybsSystemException( errMsg );
503                                    }
504                                    sheets = new Element[] { sheet };
505                            }
506                            else {
507                                    Element sheet = (Element)nodetList.item(0);
508                                    sheets = new Element[] { sheet };
509                            }
510    
511    //                      // 繧ｷ繝ｼ繝域爾縺暦ｼ壹す繝ｼ繝亥錐縺後≠繧後?縲√◎縺ｮ縺ｾ縺ｾ菴ｿ逕ｨ縲√↑縺代ｌ縺ｰ縲∵怙蛻昴?繧ｷ繝ｼ繝医ｒ蟇ｾ雎｡縺ｨ縺励∪縺吶?
512    //                      for ( int idx = 0; idx < listLen; idx++ ) {
513    //                              Element st = (Element)nodetList.item( idx );
514    //                              if ( ( sheetName == null || sheetName.length() == 0 ) || sheetName.equals( st.getAttribute( TABLE_NAME_ATTR ) ) ) {
515    //                                      sheet = st;
516    //                                      break;
517    //                              }
518    //                      }
519                            // 謖?ｮ壹?繧ｷ繝ｼ繝医′縺ｪ縺代ｌ縺ｰ縲√お繝ｩ繝ｼ
520    //                      if ( sheet == null ) {
521                            if ( sheets == null ) {
522                                    String errMsg = "蟇ｾ蠢懊☆繧九す繝ｼ繝医′蟄伜惠縺励∪縺帙ｓ縲?sheetNos=[" + sheetNos + "] or sheetName=[" + sheetName + "]";
523                                    throw new HybsSystemException( errMsg );
524                            }
525                            else {
526    //                              processSheet( sheet );
527                                    // 5.5.7.2 (2012/10/09) 隍?焚繧ｷ繝ｼ繝医?繝槭?繧ｸ隱ｭ縺ｿ蜿悶ｊ縲?
528                                    for( int i=0; i<sheets.length; i++ ) {
529                                            processSheet( sheets[i] );
530                                    }
531                            }
532                    }
533    
534                    /**
535                     * ODS繝輔ぃ繧､繝ｫ縺ｮ繧ｷ繝ｼ繝亥腰菴阪?繝代?繧ｹ繧定｡後＞縲∬｡悟腰菴阪?繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ逕滓?縺励∪縺吶?
536                     *
537                     * @param sheet Element
538                     */
539                    private void processSheet( final Element sheet ) {
540                            NodeList rows = sheet.getElementsByTagName( TABLE_TABLE_ROW_ELEM );
541                            int listLen = rows.getLength();
542                            int rowRepeat;
543                            for ( int idx = 0; idx < listLen; idx++ ) {
544                                    Element row = (Element)rows.item( idx );
545                                    // 陦後?蜀?ｮｹ縺悟?縺丞酔縺伜?蜷医?table:number-rows-repeated繧ｿ繧ｰ縺ｫ繧医ｊ逵∫払縺輔ｌ繧九?
546                                    String repeatStr = row.getAttribute( TABLE_NUMBER_ROWS_REPEATED_ATTR );
547                                    if ( repeatStr == null || repeatStr.length() == 0 ) {
548                                            rowRepeat = 1;
549                                    }
550                                    else {
551                                            rowRepeat = Integer.parseInt( repeatStr, 10 );
552                                    }
553    
554                                    processRow( row, rowRepeat );
555                            }
556                    }
557    
558                    /**
559                     * ODS繝輔ぃ繧､繝ｫ縺ｮ陦悟腰菴阪?繝代?繧ｹ繧定｡後＞縲√き繝ｩ繝?腰菴阪?繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ逕滓?縺励∪縺吶?
560                     *
561                     * @og.rev 4.3.5.0 (2009/02/01) toArray 縺吶ｋ縺ｨ縺阪↓縲√し繧､繧ｺ縺ｮ蛻晄悄蛟､謖?ｮ壹ｒ霑ｽ蜉?
562                     * @og.rev 5.1.8.0 (2010/07/01) 繧ｻ繝ｫ蜀?〒譖ｸ蠑剰ｨｭ螳壹＆繧後※縺?ｋ蝣ｴ蜷医↓縲√ユ繧ｭ繧ｹ繝医ョ繝ｼ繧ｿ縺悟叙蠕励＆繧後↑縺?ヰ繧ｰ繧剃ｿｮ豁｣
563                     *
564                     * @param row Element
565                     * @param rowRepeat int
566                     */
567                    private void processRow( final Element row, final int rowRepeat ) {
568                            NodeList cells = row.getElementsByTagName( TABLE_TABLE_CELL_ELEM );
569                            int listLen = cells.getLength();
570                            int colRepeat;
571                            String cellText;
572                            ArrayList<CellInfo> cellInfoList = new ArrayList<CellInfo>();
573                            for ( int idx = 0; idx < listLen; idx++ ) {
574                                    Element cell = (Element)cells.item( idx );
575                                    // 繧ｫ繝ｩ繝??蜀?ｮｹ縺悟?縺丞酔縺伜?蜷医?table:number-columns-repeated繧ｿ繧ｰ縺ｫ繧医ｊ逵∫払縺輔ｌ繧九?
576                                    String repeatStr = cell.getAttribute( TABLE_NUMBER_COLUMNS_REPEATED_ATTR );
577                                    if ( repeatStr == null || repeatStr.length() == 0 ) {
578                                            colRepeat = 1;
579                                    }
580                                    else {
581                                            colRepeat = Integer.parseInt( repeatStr, 10 );
582                                    }
583    
584                                    // text:p
585                                    NodeList texts = cell.getElementsByTagName( TEXT_P_ELEM );
586                                    if ( texts.getLength() == 0 ) {
587                                            cellText = "";
588                                    }
589                                    else {
590                                            // 5.1.8.0 (2010/07/01) 繧ｻ繝ｫ蜀?〒譖ｸ蠑剰ｨｭ螳壹＆繧後※縺?ｋ蝣ｴ蜷医↓縲√ユ繧ｭ繧ｹ繝医ョ繝ｼ繧ｿ縺悟叙蠕励＆繧後↑縺?ヰ繧ｰ繧剃ｿｮ豁｣
591    //                                      StringBuilder sb = new StringBuilder();
592    //                                      NodeList textElems = texts.item( 0 ).getChildNodes();
593    //                                      int textElemLen = textElems.getLength();
594    //                                      for ( int idxt = 0; idxt < textElemLen; idxt++ ) {
595    //                                              Node textElem = textElems.item( idxt );
596    //                                              if ( textElem.getNodeType() == Node.TEXT_NODE ) {
597    //                                                      sb.append( textElem.getNodeValue() );
598    //                                              }
599    //                                      }
600    //                                      cellText = sb.toString();
601                                            cellText = texts.item( 0 ).getTextContent();
602                                    }
603                                    cellInfoList.add( new CellInfo( colRepeat, cellText ) );
604                            }
605    
606    //                      if ( cellInfoList.size() > 0 ) {
607                            if ( ! cellInfoList.isEmpty() ) {
608    //                              rowInfoList.add( new RowInfo( rowRepeat, cellInfoList.toArray( new CellInfo[0] ) ) );
609                                    // 4.3.5.0 (2009/02/01) toArray 縺吶ｋ縺ｨ縺阪↓縲√し繧､繧ｺ縺ｮ蛻晄悄蛟､謖?ｮ壹ｒ霑ｽ蜉?
610                                    rowInfoList.add( new RowInfo( rowRepeat, cellInfoList.toArray( new CellInfo[cellInfoList.size()] ) ) );
611                            }
612                    }
613            }
614    
615            /**
616             * ODS繝輔ぃ繧､繝ｫ縺ｮ陦梧ュ蝣ｱ繧定｡ｨ縺呎ｧ矩?菴?
617             */
618            private static final class RowInfo {
619                    public final int rowRepeat;
620                    public final CellInfo[] cellInfos;
621    
622                    RowInfo( final int rep, final CellInfo[] cell ) {
623                            rowRepeat = rep;
624                            cellInfos = cell;
625                    }
626            }
627    
628            /**
629             * ODS繝輔ぃ繧､繝ｫ縺ｮ繧ｫ繝ｩ繝?ュ蝣ｱ繧定｡ｨ縺呎ｧ矩?菴?
630             */
631            private static final class CellInfo {
632                    public final int colRepeat;
633                    public final String text;
634    
635                    CellInfo( final int rep, final String tx ) {
636                            colRepeat = rep;
637                            text = tx;
638                    }
639            }
640    }