/*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
*
* Copyright 2008 jOpenDocument, by ILM Informatique. All rights reserved.
*
* The contents of this file are subject to the terms of the GNU
* General Public License Version 3 only ("GPL").
* You may not use this file except in compliance with the License.
* You can obtain a copy of the License at http://www.gnu.org/licenses/gpl-3.0.html
* See the License for the specific language governing permissions and limitations under the License.
*
* When distributing the software, include this License Header Notice in each file.
*
*/
package org.jopendocument.dom.spreadsheet;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.NoSuchElementException;
import org.jdom.Document;
import org.jdom.Element;
import org.jopendocument.dom.ODDocument;
import org.jopendocument.dom.ODPackage;
import org.jopendocument.dom.XMLVersion;
/**
* A calc document.
*
* @author Sylvain
*/
public class SpreadSheet implements ODDocument {
private final ODPackage originalFile;
private final Map<Element, Sheet> sheets;
private SpreadSheet(final Document doc, final Document styles, final ODPackage orig) {
if (orig != null) {
// ATTN OK because this is our private instance (see createFromFile())
this.originalFile = orig;
} else {
this.originalFile = new ODPackage();
}
this.originalFile.putFile("content.xml", doc);
if (styles != null)
this.originalFile.putFile("styles.xml", styles);
// map Sheet by XML elements so has not to depend on ordering or name
this.sheets = new HashMap<>();
}
final Document getContent() {
return this.getPackage().getContent().getDocument();
}
@Override
public final XMLVersion getVersion() {
return this.getPackage().getVersion();
}
private Element getBody() {
final Element body = this.getContent().getRootElement().getChild("body", this.getVersion().getOFFICE());
if (this.getVersion().equals(XMLVersion.OOo))
return body;
else
return body.getChild("spreadsheet", this.getVersion().getOFFICE());
}
// query directly the DOM, that way don't need to listen to it (eg for name, size or order
// change)
@SuppressWarnings("unchecked")
private final List<Element> getTables() {
return this.getBody().getChildren("table", this.getVersion().getTABLE());
}
public int getSheetCount() { // NO_UCD
return this.getTables().size();
}
public Sheet getSheet(int i) { // NO_UCD
return this.getSheet(getTables().get(i));
}
public Sheet getSheet(String name) { // NO_UCD
return this.getSheet(name, false);
}
/**
* Return the first sheet with the passed name.
*
* @param name the name of a sheet.
* @param mustExist what to do when no match is found : <code>true</code> to throw an exception,
* <code>false</code> to return null.
* @return the first matching sheet, <code>null</code> if <code>mustExist</code> is
* <code>false</code> and no match is found.
* @throws NoSuchElementException if <code>mustExist</code> is <code>true</code> and no match is
* found.
*/
public Sheet getSheet(String name, final boolean mustExist) throws NoSuchElementException {
for (final Element table : getTables()) {
if (name.equals(Table.getName(table)))
return getSheet(table);
}
if (mustExist)
throw new NoSuchElementException("no such sheet: " + name);
else
return null;
}
private final Sheet getSheet(Element table) {
Sheet res = this.sheets.get(table);
if (res == null) {
res = new Sheet(this, table);
this.sheets.put(table, res);
}
return res;
}
void invalidate(Element element) {
this.sheets.remove(element);
}
// *** Files
@Override
public final ODPackage getPackage() {
return this.originalFile;
}
}