gvSIG data provider for MS-Excel

<assembly>

    <id>gvsig-plugin-package</id>

    <formats>

        <format>zip</format>

    </formats>

    <baseDirectory>${project.artifactId}</baseDirectory>

    <includeBaseDirectory>true</includeBaseDirectory>

    <files>

        <file>

            <source>target/${project.artifactId}-${project.version}.jar</source>

            <outputDirectory>lib</outputDirectory>

        </file>

        <file>

            <source>target/package.info</source>

        </file>

    </files>

    <fileSets>

        <fileSet>

            <directory>src/main/resources-plugin</directory>

            <outputDirectory>.</outputDirectory>

        </fileSet>

    </fileSets>

    <dependencySets>

        <dependencySet>

            <useProjectArtifact>false</useProjectArtifact>

            <useTransitiveDependencies>false</useTransitiveDependencies>

            <outputDirectory>lib</outputDirectory>

            <includes>

                <include>org.jopendocument:jOpenDocument</include>

                <include>com.github.miachm.sods:SODS</include>

                <include>org.gvsig:org.gvsig.ods.lib.api</include>

                <include>org.gvsig:org.gvsig.ods.lib.impl</include>

                <include>org.gvsig:org.gvsig.ods.provider</include>           

                <include>org.gvsig:org.gvsig.ods.swing.api</include>

                <include>org.gvsig:org.gvsig.ods.swing.impl</include>   

            </includes>

        </dependencySet>

    </dependencySets>

</assembly>

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.ods;

import org.gvsig.andami.plugins.Extension;

/**

 *

 * @author jjdelcerro

 */

public class ODSExtension extends Extension {

    @Override

    public void initialize() {

    }

    @Override

    public void postInitialize() {

    }

    @Override

    public void execute(String action) {

    }

    @Override

    public boolean isEnabled() {

        return true;

    }

    @Override

    public boolean isVisible() {

        return true;

    }

}

<?xml version="1.0" encoding="ISO-8859-1"?>

<plugin-config>

  <libraries library-dir="lib/"/>

  <depends plugin-name="org.gvsig.app.mainplugin"/>

  <depends plugin-name="org.gvsig.pdf.app.mainplugin"/>

  <resourceBundle name="text"/>

  <extensions>

     <extension class-name="org.gvsig.andami.LibraryExtension" active="false"/>

  </extensions>

</plugin-config>

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

    <modelVersion>4.0.0</modelVersion>

    <artifactId>org.gvsig.ods.app.mainplugin</artifactId>

    <packaging>jar</packaging>

    <name>${project.artifactId}</name>

    <description>ODS file format support</description>

    <parent>

        <groupId>org.gvsig</groupId>

        <artifactId>org.gvsig.ods.app</artifactId>

        <version>1.0.173</version>

    </parent>

    <dependencies>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.tools.lib</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.andami</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.ods.provider</artifactId>

            <scope>compile</scope>

        </dependency>

                <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.ods.swing.api</artifactId>

            <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.ods.swing.impl</artifactId>

            <scope>runtime</scope>

        </dependency>

                <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.ods.lib.impl</artifactId>

            <scope>runtime</scope>

        </dependency>

                <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.ods.lib.api</artifactId>

            <scope>runtime</scope>

        </dependency>

        <dependency>

          <groupId>org.jopendocument</groupId>

          <artifactId>jOpenDocument</artifactId>

          <scope>runtime</scope>

        </dependency>

        <dependency>

            <groupId>com.github.miachm.sods</groupId>

            <artifactId>SODS</artifactId>

          <scope>runtime</scope>

        </dependency>

    </dependencies>

    <properties>

        <!-- Package info property values -->

        <!-- Default values in org.gvsig.desktop -->

        <gvsig.package.info.name>Formats: ODS file format support</gvsig.package.info.name>

        <gvsig.package.info.state>testing</gvsig.package.info.state>

        <gvsig.package.info.official>true</gvsig.package.info.official>

        <gvsig.package.info.dependencies>required: org.gvsig.app.mainplugin -ge 2.1.0-A</gvsig.package.info.dependencies>

        <gvsig.package.info.categories>Formats,Vector</gvsig.package.info.categories>

        <gvsig.package.info.poolURL>https://devel.gvsig.org/download/projects/gvsig-jexcel/pool/</gvsig.package.info.poolURL>

    </properties>

</project>

#Tue Jun 11 10:25:21 CEST 2024

buildNumber=180

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

  <modelVersion>4.0.0</modelVersion>

  <artifactId>org.gvsig.ods.app</artifactId>

  <packaging>pom</packaging>

  <name>${project.artifactId}</name>

  <parent>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.ods</artifactId>

      <version>1.0.173</version>

  </parent>

  <modules>

    <module>${project.artifactId}.mainplugin</module>

  </modules>

</project>

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

    <modelVersion>4.0.0</modelVersion>

    <artifactId>org.gvsig.ods</artifactId>

    <packaging>pom</packaging>

    <name>${project.artifactId}</name>

    <version>1.0.173</version>

    <description>ODS support fort DAL and gvSIG</description>

    <parent>

        <groupId>org.gvsig</groupId>

        <artifactId>org.gvsig.desktop</artifactId>

        <version>2.0.448</version>

    </parent>

    <url>https://devel.gvsig.org/redmine/projects/gvsig-jexcel/org.gvsig.ods</url>

    <scm>

        <connection>scm:svn:https://devel.gvsig.org/svn/gvsig-jexcel/org.gvsig.ods/tags/org.gvsig.ods-1.0.173</connection>

        <developerConnection>scm:svn:https://devel.gvsig.org/svn/gvsig-jexcel/org.gvsig.ods/tags/org.gvsig.ods-1.0.173</developerConnection>

        <url>https://devel.gvsig.org/redmine/projects/gvsig-jexcel/repository/show/org.gvsig.ods/tags/org.gvsig.ods-1.0.173</url>

    </scm>

    <repositories>

        <repository>

            <id>gvsig-public-http-repository</id>

            <name>gvSIG maven public HTTP repository</name>

            <url>http://devel.gvsig.org/m2repo/j2se</url>

            <releases>

                <enabled>true</enabled>

                <updatePolicy>daily</updatePolicy>

                <checksumPolicy>warn</checksumPolicy>

            </releases>

            <snapshots>

                <enabled>true</enabled>

                <updatePolicy>daily</updatePolicy>

                <checksumPolicy>warn</checksumPolicy>

            </snapshots>

        </repository>

    </repositories>

    <build>

        <plugins>

            <plugin>

                <groupId>org.apache.maven.plugins</groupId>

                <artifactId>maven-release-plugin</artifactId>

                <configuration>

                    <tagBase>https://devel.gvsig.org/svn/gvsig-jexcel/org.gvsig.ods/tags</tagBase>

                </configuration>

            </plugin>

        </plugins>

    </build>

    <properties>

            <org.gvsig.pdf.version>1.0.153</org.gvsig.pdf.version>

    </properties>    

    <dependencyManagement>

        <dependencies>

            <dependency>

                <groupId>org.gvsig</groupId>

                <artifactId>org.gvsig.ods.lib.api</artifactId>

                <version>1.0.173</version>

            </dependency>

            <dependency>

                <groupId>org.gvsig</groupId>

                <artifactId>org.gvsig.ods.lib.impl</artifactId>

                <version>1.0.173</version>

            </dependency>

            <dependency>

                <groupId>org.gvsig</groupId>

                <artifactId>org.gvsig.ods.swing.api</artifactId>

                <version>1.0.173</version>

            </dependency>

            <dependency>

                <groupId>org.gvsig</groupId>

                <artifactId>org.gvsig.ods.swing.impl</artifactId>

                <version>1.0.173</version>

            </dependency>

            <dependency>

                <groupId>org.gvsig</groupId>

                <artifactId>org.gvsig.ods.provider</artifactId>

                <version>1.0.173</version>

            </dependency>

            <dependency>

                <groupId>org.gvsig</groupId>

                <artifactId>org.gvsig.ods.app.mainplugin</artifactId>

                <version>1.0.173</version>

            </dependency>

            <dependency>

                <groupId>com.github.miachm.sods</groupId>

                <artifactId>SODS</artifactId>

                <version>1.0.1</version>

            </dependency>

            <dependency>

                <groupId>org.gvsig</groupId>

                <artifactId>org.gvsig.pdf</artifactId>

                <version>${org.gvsig.pdf.version}</version>

                <type>pom</type>

                <scope>import</scope>

            </dependency>

        </dependencies>

    </dependencyManagement>

    <modules>

        <module>${project.artifactId}.app</module>

        <module>${project.artifactId}.provider</module>

        <module>${project.artifactId}.swing</module>

        <module>${project.artifactId}.lib</module>

      </modules>

</project>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

  <modelVersion>4.0.0</modelVersion>

  <parent>

    <groupId>org.gvsig</groupId>

    <artifactId>org.gvsig.ods</artifactId>

    <version>1.0.173</version>

  </parent>

  <artifactId>org.gvsig.ods.lib</artifactId>

  <packaging>pom</packaging>

  <name>${project.artifactId}</name>

  <modules>

  	<module>org.gvsig.ods.lib.api</module>

  	<module>org.gvsig.ods.lib.impl</module>

  </modules>

</project>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

    <modelVersion>4.0.0</modelVersion>

    <parent>

        <groupId>org.gvsig</groupId>

        <artifactId>org.gvsig.ods.lib</artifactId>

        <version>1.0.173</version>

    </parent>

    <artifactId>org.gvsig.ods.lib.impl</artifactId>

    <name>${project.artifactId}</name>

    <dependencies>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.ods.lib.api</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.tools.lib</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal.api</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>commons-codec</groupId>

            <artifactId>commons-codec</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.pdf.lib.api</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.jopendocument</groupId>

            <artifactId>jOpenDocument</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>com.github.miachm.sods</groupId>

            <artifactId>SODS</artifactId>

            <scope>compile</scope>

        </dependency>

    </dependencies>

</project>

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.ods.lib.impl;

import org.gvsig.fmap.dal.DALLibrary;

import org.gvsig.ods.lib.api.ODSLibrary;

import org.gvsig.ods.lib.api.ODSLocator;

import org.gvsig.tools.ToolsLibrary;

import org.gvsig.tools.library.AbstractLibrary;

import org.gvsig.tools.library.LibraryException;

public class ODSImplLibrary extends AbstractLibrary {

    @Override

    public void doRegistration() {

        super.doRegistration();

        registerAsImplementationOf(ODSLibrary.class);

        this.require(ToolsLibrary.class);

        this.require(DALLibrary.class);

    }

    @Override

    protected void doInitialize() throws LibraryException {

        ODSLocator.registerDefaultODSManager(DefaultODSManager.class);

    }

    @Override

    protected void doPostInitialize() throws LibraryException {

        ODSProfile.selfRegister();

    }

}

package org.gvsig.ods.lib.impl;

import java.io.Closeable;

import java.io.File;

import java.util.List;

import java.util.Locale;

import org.gvsig.ods.lib.api.ODSDocument.Sheet;

/**

 *

 * @author jjdelcerro

 */

public interface Spread extends Closeable {

    public void open(File ODSFile, Locale locale);

    public File getFile();

    public Sheet getSheet(int sheetIndex);

    public List<String> getSheetNames();

}

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.ods.lib.impl;

import java.io.File;

import org.gvsig.ods.lib.api.ODSDocument;

import org.gvsig.ods.lib.api.ODSManager;

public class DefaultODSManager implements ODSManager {

    @Override

    public ODSDocument createODSDocument(byte[] document) {

        DefaultODSDocument doc = new DefaultODSDocument();

        doc.setSource(document);

        return doc;

    }

//    public ODSDocument createODSDocument(String document) {

//        DefaultODSDocument doc = new DefaultODSDocument();

//        doc.setDocument(document);

//        return doc;

//    }

    @Override

    public ODSDocument createODSDocument(File document) {

        DefaultODSDocument doc = new DefaultODSDocument();

        doc.setSource(document);

        return doc;

    }

    @Override

    public ODSDocument createODSDocument() {

        DefaultODSDocument doc = new DefaultODSDocument();

        return doc;

    }

}

/*

 * To change this license header, choose License Headers in Project Properties.

 * To change this template file, choose Tools | Templates

 * and open the template in the editor.

 */

package org.gvsig.ods.lib.impl;

import java.io.File;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.feature.AbstractDataProfile;

import org.gvsig.ods.lib.api.ODSDocument;

import org.gvsig.ods.lib.api.ODSLocator;

import org.gvsig.ods.lib.api.ODSManager;

import org.gvsig.tools.dataTypes.CoercionException;

import org.gvsig.tools.dataTypes.DataType;

import org.gvsig.tools.dataTypes.DataTypes;

import org.gvsig.tools.dynobject.Tags;

public class ODSProfile extends AbstractDataProfile {

    public ODSProfile() {

        super("ODS", File.class);

    }

    @Override

    public Object createData(Object ods, Tags tags) {

        ODSManager manager = ODSLocator.getODSManager();

        ODSDocument odsdoc = manager.createODSDocument();

        odsdoc.setSource(ods);

        return odsdoc;

    }

    @Override

    public Object coerce(DataType dataType, Object data, Tags tags) throws CoercionException {

        ODSDocument document;

        try {

            switch (dataType.getType()) {

                case DataTypes.BYTEARRAY:

                    document = ODSLocator.getODSManager().createODSDocument();

                    document.setSource(data);

                    return document.toByteArray();

                case DataTypes.FILE:

                    if (data instanceof File) {

                        return data;

                    }

                case DataTypes.STRING:

                    document = ODSLocator.getODSManager().createODSDocument();

                    document.setSource(data);

                    return document.toHexString();

                default:

                    break;

            }

        } catch (Exception ex) {

            throw new CoercionException("Can't convert ODS to " + dataType.getName(), ex);

        }

        throw new CoercionException("Can't convert ODS to " + dataType.getName());

    }

    public static void selfRegister() {

        DataManager dataManager = DALLocator.getDataManager();

        dataManager.registerDataProfile(new ODSProfile());

    }

}

package org.gvsig.ods.lib.impl;

import com.github.miachm.SODS.spreadsheet.SpreadSheet;

import java.io.File;

import java.io.FileInputStream;

import java.io.IOException;

import java.util.ArrayList;

import java.util.Collections;

import java.util.List;

import java.util.Locale;

import java.util.Objects;

import org.apache.commons.lang3.StringUtils;

import com.github.miachm.SODS.spreadsheet.Range;

import java.awt.Rectangle;

import java.io.FileNotFoundException;

import java.io.InputStream;

import org.apache.commons.io.IOUtils;

import org.gvsig.ods.lib.api.ODSDocument.Sheet;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

/**

 *

 * @author jjdelcerro

 */

public class SpreadSODS implements Spread {

    private static final Logger LOGGER = LoggerFactory.getLogger(SpreadSODS.class);

    @Override

    public File getFile() {

        throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.

    }

    private static class SODSSheet implements Sheet {

        private int sheetIndex;

        private com.github.miachm.SODS.spreadsheet.Sheet ODSSheet;

        private Range usedRange = null;

        public SODSSheet(InputStream odsis, int sheetIndex, Locale locale) throws IOException {

            try {

                SpreadSheet spread = new SpreadSheet(odsis, locale);

                this.ODSSheet = spread.getSheet(sheetIndex);

            } finally {

                odsis.reset();

            }

            this.sheetIndex = sheetIndex;

        }

        @Override

        public int getColumnCount() {

//            return this.ODSSheet.getMaxColumns();

            return this.getUsedData().getNumColumns();

        }

        @Override

        public Rectangle getUsedRange() {

            Range x = this.getUsedData();

            return new Rectangle(x.getColumn(), x.getRow(), x.getNumColumns(), x.getNumRows());

        }

        @Override

        public List<String> getColumnNames(boolean isFirstLineHedaer) {

            int columns = this.getColumnCount();

            List<String> columnNames = new ArrayList<>(columns);

            String abc = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";

            if (columns > abc.length()) {

                for (int i = 0; i < columns; i++) {

                    columnNames.add("C" + i);

                }

            } else {

                for (int i = 0; i < columns; i++) {

                    columnNames.add(abc.substring(i, i + 1));

                }

            }

            if (isFirstLineHedaer) {

                for (int col = 0; col < columns; col++) {

                    Object value = this.getValueAt(col, 0);

                    String s = Objects.toString(value);

                    if (!StringUtils.isBlank(s)) {

                        columnNames.set(col, s);

                    }

                }

            }

            return columnNames;

        }

        private Range getUsedData() {

            if (this.usedRange == null) {

                Range data = this.ODSSheet.getDataRange();

                int minCol = -1, minRow = -1, maxCol = -1, maxRow = -1;

                final int colCount = data.getNumColumns();

                final int rowCount = data.getNumRows();

                for (int row = 0; row < rowCount; row++) {

                    for (int col = 0; col < colCount; col++) {

                        Object value = data.getCell(row, col).getValue();

                        if (value != null) {

                            if (minCol < 0 || col < minCol) {

                                minCol = col;

                            }

                            if (minRow < 0 || row < minRow) {

                                minRow = row;

                            }

                            if (maxCol < 0 || col > maxCol) {

                                maxCol = col;

                            }

                            if (maxRow < 0 || row > maxRow) {

                                maxRow = row;

                            }

                        }

                    }

                }

                this.usedRange = this.ODSSheet.getRange(minRow, minCol, maxRow - minRow+1, maxCol - minCol+1);

            }

            return this.usedRange;

        }

        @Override

        public String getName() {

            return this.ODSSheet.getName();

        }

        @Override

        public int getRowCount() {

//            return this.ODSSheet.getMaxRows();

            return this.getUsedData().getNumRows();

        }

        @Override

        public int getSheetIndex() {

            return this.sheetIndex;

        }

        @Override

        public Object getValueAt(int col, int row) {

//            return this.ODSSheet.getRange(col, row).getValue();

            Range data = this.getUsedData();

            Object value = data.getCell(row, col).getValue();

            if( row<5 && col<10  ) {

                LOGGER.info("getValueAt: row "+row+", col "+col+", value "+value);

            }

            return value;

        }

        @Override

        public void close() {

            this.ODSSheet = null;

            this.sheetIndex = -1;

            this.usedRange = null;

        }   

    }

    private InputStream source;

    private Locale locale;

    public SpreadSODS() {

    }

    @Override

    public void open(File source, Locale locale) {

        FileInputStream is;

        try {

            is = new FileInputStream(source);

            this.open(is, locale);

        } catch (FileNotFoundException ex) {

            throw new RuntimeException("Can' open ODS file '"+Objects.toString(source)+"'.", ex);

        }

    }

    public void open(InputStream source, Locale locale) {

        this.source = source;

        this.locale = locale;

        this.source.mark(Integer.MAX_VALUE);

    }

    @Override

    public void close() throws IOException {

        IOUtils.closeQuietly(this.source);

        this.source = null;

        this.locale = null;

    }

    @Override

    public Sheet getSheet(int sheetIndex) {

        try {

            if (source == null || sheetIndex < 0) {

                return null;

            }

            return new SODSSheet(source, sheetIndex, locale);

        } catch (IOException ex) {

            return null;

        }

    }

    @Override

    public List<String> getSheetNames() {

        try {

            SpreadSheet spread = new SpreadSheet(source);

            List<String> r = new ArrayList<>();

            for (int n = 0; n < spread.getNumSheets(); n++) {

                r.add(spread.getSheet(n).getName());

            }

            return r;

        } catch (IOException ex) {

            return Collections.emptyList();

        }

    }

}

package org.gvsig.ods.lib.impl;

import java.awt.Graphics2D;

import java.io.ByteArrayInputStream;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.IOException;

import java.io.InputStream;

import java.net.URL;

import java.util.List;

import java.util.Locale;

import org.gvsig.pdf.lib.api.PDFDocument;

import org.slf4j.LoggerFactory;

import org.apache.commons.codec.binary.Hex;

import org.apache.commons.codec.DecoderException;

import org.apache.commons.codec.binary.Base64;

import org.apache.commons.io.IOUtils;

import org.gvsig.ods.lib.api.ODSDocument;

import org.gvsig.pdf.lib.api.PDFLocator;

import org.gvsig.pdf.lib.api.PDFManager;

import org.gvsig.pdf.lib.api.PDFWriter;

import org.jopendocument.model.OpenDocument;

import org.jopendocument.renderer.ODTRenderer;

import org.slf4j.Logger;

/**

 *

 * @author osc

 */

public class DefaultODSDocument implements ODSDocument {

    private static final Logger LOGGER = LoggerFactory.getLogger(DefaultODSDocument.class);

    private Object source;

    private Locale locale;

    private Spread spread;

    public DefaultODSDocument() {

    }

    @Override

    public void setSource(File source) {

        this.setSource((Object)source);

    }

    @Override

    public void setSource(Object source) {

        this.source = source;

    }

    @Override

    public void setLocale(Locale locale) {

        this.locale = locale;

    }

    @Override

    public void close() {

        this.source = null;

        this.locale = null;

        IOUtils.closeQuietly(this.spread);

        this.spread = null;

    }

    public File getFile() {

        if( this.source instanceof File) {

            return (File) this.source;

        }

        return null;

    }

    private Spread getSpread() {

        if( this.spread==null ) {

            if( this.getFile()!=null ) {

                try {

                    this.spread = new SpreadJOpenDocument();

                    this.spread.open(this.getFile(), this.locale);

                } catch (Exception ex) {

                    IOUtils.closeQuietly(this.spread);

                    this.spread = null;

                    throw new RuntimeException("Can't load spread.", ex);

                }

            } else {

                SpreadSODS theSpread = new SpreadSODS();

                InputStream is = null;

                try {

                    is = this.getInputStream();

                    theSpread.open(is, this.locale);

                } catch (Exception ex) {

                    IOUtils.closeQuietly(is);

                    IOUtils.closeQuietly(theSpread);

                    throw new RuntimeException("Can't load spread.", ex);

                }

                this.spread = theSpread;

            }

        }

        return this.spread;

    }

    @Override

    public InputStream getInputStream() throws IOException {

        InputStream is = null;

        if (source == null) {

            return null;

        } else if (source instanceof File) {

            File fileSource = (File) source;

            try {

                is = new FileInputStream(fileSource);

            } catch (IOException ex) {

                LOGGER.warn("Not been able to convert file to input stream", ex);

                throw new IOException(ex);

            }

        } else if (source instanceof URL) {

            URL urlSource = (URL) source;

            try {

                is = urlSource.openStream();

            } catch (IOException ex) {

                LOGGER.warn("Not been able to open URL stream", ex);

                throw new IOException(ex);

            }

        } else if (source instanceof String) {

            String strSource = (String) source;

            File f = new File(strSource);

            if (f.exists()) {

                try {

                    is = new FileInputStream(f);

                } catch (FileNotFoundException ex) {

                    LOGGER.warn("Not been able to load existing file", ex);

                    throw new IOException(ex);

                }

            } else {

                try {

                    URL url = new URL(strSource);

                    is = url.openStream();

                    is.available(); // Force exception if is null

                } catch (Exception ex) {

                    try {

                        byte[] data = Hex.decodeHex(strSource.toCharArray());

                        is = new ByteArrayInputStream(data);

                    } catch (DecoderException ex2) {

                        try {

                            byte[] data = Base64.decodeBase64(strSource);

                            is = new ByteArrayInputStream(data);

                        } catch (Exception ex3) {

                            throw new IOException(ex3);

                        }

                    }

                }

            }

        } else if (source instanceof byte[]) {

            byte[] byteSource = (byte[]) source;

            is = new ByteArrayInputStream(byteSource);

        }

        return is;

    }

    @Override

    public byte[] toByteArray() {

        if (this.source != null) {

            InputStream is= null;

            try {

                is = this.getInputStream();

                byte[] bytes = new byte[is.available()];

                is.read(bytes);

                return bytes;

            } catch (IOException ex) {

                LOGGER.warn("Not been able to convert to byte array", ex);

            } finally {

                IOUtils.closeQuietly(is);

            }

        }

        return null;

    }

    private String bytearray_hex(byte[] data) {

        StringBuilder builder = new StringBuilder();

        for (byte abyte : data) {

            int v = abyte & 0xff;

            builder.append(String.format("%02x", v));

        }

        return builder.toString();

    }

    @Override

    public String toHexString() {

        byte[] data = this.toByteArray();

        return bytearray_hex(data);

    }

    @Override

    public PDFDocument createPDF(int pageSize) {

        PDFManager pdfManager = PDFLocator.getPDFManager();

        OpenDocument doc = new OpenDocument();

        doc.loadFrom(this.getFile());

        PDFWriter writer = pdfManager.createPDFWriter();

        writer.open(pageSize);

        Graphics2D g = writer.getGraphics2D();

        // Configure the renderer

        ODTRenderer renderer = new ODTRenderer(doc);

        renderer.setIgnoreMargins(true);

        renderer.setPaintMaxResolution(true);

        // Scale the renderer to fit width

        renderer.setResizeFactor(renderer.getPrintWidth() / writer.getWidth());

        // Render

        renderer.paintComponent(g);

        writer.close();

        return writer.toDocument();

    }

    @Override

    public Sheet getSheet(int sheetIndex) {

        if( this.getSpread() == null || sheetIndex<0 ) {

            return null;

        }

        return this.getSpread().getSheet(sheetIndex);

    }

    @Override

    public List<String> getSheetNames() {

        if( this.getSpread() == null ) {

            return null;

        }

        return this.getSpread().getSheetNames();

    }

}

package org.gvsig.ods.lib.impl;

import java.awt.Rectangle;

import java.io.File;

import java.io.IOException;

import java.util.ArrayList;

import java.util.Collections;

import java.util.List;

import java.util.Locale;

import java.util.Objects;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.ods.lib.api.ODSDocument.Sheet;

import org.jopendocument.dom.ODPackage;

import org.jopendocument.dom.spreadsheet.SpreadSheet;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

/**

 *

 * @author jjdelcerro

 */

public class SpreadJOpenDocument implements Spread {

    private static final Logger LOGGER = LoggerFactory.getLogger(SpreadJOpenDocument.class);

    private class JOpenDocumentSheet implements Sheet {

        private int sheetIndex;

        private org.jopendocument.dom.spreadsheet.Sheet ODSSheet;

        private Rectangle usedRange = null;

        public JOpenDocumentSheet(File ODSFile, int sheetIndex) throws IOException {

            SpreadSheet workbook = ODPackage.createFromFile(ODSFile).getSpreadSheet();

            this.ODSSheet = workbook.getSheet(sheetIndex);

            this.sheetIndex = sheetIndex;

        }

        @Override

        public Rectangle getUsedRange() {

            if( this.usedRange == null ) {

                Spread spread = new SpreadSODS();

                spread.open(ODSFile, locale);

                Sheet sheet = spread.getSheet(this.sheetIndex);

                this.usedRange = sheet.getUsedRange();

            }

            return this.usedRange;

        }

        @Override

        public int getColumnCount() {

//            return this.ODSSheet.getColumnCount();

            if( this.usedRange==null ) {

                this.usedRange = this.getUsedRange();

            }

            return this.usedRange.width;

        }

        @Override

        public List<String> getColumnNames(boolean isFirstLineHedaer) {

            int columns = this.getColumnCount();

            List<String> columnNames = new ArrayList<>(columns);

            String abc = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";

            if (columns > abc.length()) {

                for (int i = 0; i < columns; i++) {

                    columnNames.add( "C" + i);

                }

            } else {

                for (int i = 0; i < columns; i++) {

                    columnNames.add(abc.substring(i, i + 1));

                }

            }

            if (isFirstLineHedaer) {

                for (int col = 0; col < columns; col++) {

                    Object value = this.getValueAt(col, 0);

                    String s = Objects.toString(value);

                    if (!StringUtils.isBlank(s)) {

                        columnNames.set(col, s);

                    }

                }

            }

            return columnNames;

        }

        @Override

        public String getName() {

            return this.ODSSheet.getName();

        }

        @Override

        public int getRowCount() {

//            return this.ODSSheet.getRowCount();

            if( this.usedRange==null ) {

                this.usedRange = this.getUsedRange();

            }

            return this.usedRange.height;

        }

        @Override

        public int getSheetIndex() {

            return this.sheetIndex;

        }

        @Override

        public Object getValueAt(int col, int row) {

            return this.ODSSheet.getValueAt(col, row);

        }

        @Override

        public void close() {

            this.ODSSheet = null;

            this.sheetIndex = -1;

            this.usedRange = null;

        }        

    }

    private File ODSFile;

    private Locale locale;

    public SpreadJOpenDocument() {

    }

    @Override

    public void open(File ODSFile, Locale locale) {

        this.ODSFile = ODSFile;

        this.locale = locale;

    }

    @Override

    public File getFile() {

        return this.ODSFile;

    }

    @Override

    public Sheet getSheet(int sheetIndex) {

        try {

            if( ODSFile == null || sheetIndex<0 ) {

                return null;

            }

            return new JOpenDocumentSheet(ODSFile, sheetIndex);

        } catch (IOException ex) {

            return null;

        }

    }

    @Override

    public List<String> getSheetNames() {

        try {

            SpreadSheet workbook = ODPackage.createFromFile(ODSFile).getSpreadSheet();

            List<String> r = new ArrayList<>();

            for( int n=0; n<workbook.getSheetCount(); n++ ) {

                r.add(workbook.getSheet(n).getName());

            }

            return r;

        } catch (IOException ex) {

            return Collections.emptyList();

        }

    }

    @Override

    public void close() {

        this.ODSFile = null;

        this.locale = null;

    }

}

org.gvsig.ods.lib.impl.ODSImplLibrary

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.ods.lib.api;

import org.gvsig.tools.locator.AbstractLocator;

import org.gvsig.tools.locator.Locator;

import org.gvsig.tools.locator.LocatorException;

@SuppressWarnings("rawtypes")

public class ODSLocator extends AbstractLocator {

	private static final String LOCATOR_NAME = "ODSLocator";

	public static final String ODS_MANAGER_NAME =

			"ODSManager";

	private static final String ODS_MANAGER_DESCRIPTION =

			"ODS Manager of gvSIG";

	private static final ODSLocator INSTANCE = new ODSLocator();

	private ODSLocator() {

	}

	/**

	 * Return the singleton instance.

	 * 

	 * @return the singleton instance

	 */

	public static ODSLocator getInstance() {

		return INSTANCE;

	}

        @Override

	public String getLocatorName() {

		return LOCATOR_NAME;

	}

	/**

	 * Return a reference to ODSManager.

	 * 

	 * @return a reference to ODSManager

	 * @throws LocatorException

	 *             if there is no access to the class or the class cannot be

	 *             instantiated

	 * @see Locator#get(String)

	 */

	public static ODSManager getODSManager()

			throws LocatorException {

		return (ODSManager) getInstance().get(ODS_MANAGER_NAME);

	}

	public static ODSManager getManager()

			throws LocatorException {

		return getODSManager();

	}

	/**

	 * Registers the Class implementing the ODSManager interface.

	 * 

	 * @param clazz

	 *            implementing the ODSManager interface

	 */

	public static void registerODSManager(Class clazz) {

		getInstance().register(ODS_MANAGER_NAME,

				ODS_MANAGER_DESCRIPTION, clazz);

	}

	public static void registerDefaultODSManager(Class clazz) {

		getInstance().registerDefault(ODS_MANAGER_NAME,

				ODS_MANAGER_DESCRIPTION, clazz);

	}

}

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.ods.lib.api;

import org.gvsig.tools.ToolsLibrary;

import org.gvsig.tools.library.AbstractLibrary;

import org.gvsig.tools.library.LibraryException;

import org.gvsig.tools.locator.ReferenceNotRegisteredException;

/**

 *

 * @author jjdelcerro

 */

public class ODSLibrary extends AbstractLibrary {

    @Override

    public void doRegistration() {

        super.doRegistration();

        registerAsAPI(ODSLibrary.class);

        this.require(ToolsLibrary.class);

    }

    @Override

    protected void doInitialize() throws LibraryException {

    }

    @Override

    protected void doPostInitialize() throws LibraryException {

            if(! ODSLocator.getInstance().exists(ODSLocator.ODS_MANAGER_NAME)) {

            throw new ReferenceNotRegisteredException(

                ODSLocator.ODS_MANAGER_NAME,

                ODSLocator.getInstance());

        }

    }

}

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.ods.lib.api;

import java.io.File;

/**

 *

 * @author jjdelcerro

 */

public interface ODSManager {

    public ODSDocument createODSDocument(byte[] document);

//    public ODSDocument createODSDocument(String document);

    public ODSDocument createODSDocument(File document);

    public ODSDocument createODSDocument();