org.apache.isis.extensions.excel.applib.ExcelService Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of isis-extensions-excel-applib Show documentation
The newest version!
/*
 *  Licensed to the Apache Software Foundation (ASF) under one
 *  or more contributor license agreements.  See the NOTICE file
 *  distributed with this work for additional information
 *  regarding copyright ownership.  The ASF licenses this file
 *  to you under the Apache License, Version 2.0 (the
 *  "License"); you may not use this file except in compliance
 *  with the License.  You may obtain a copy of the License at
 *
 *        http://www.apache.org/licenses/LICENSE-2.0
 *
 *  Unless required by applicable law or agreed to in writing,
 *  software distributed under the License is distributed on an
 *  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 *  KIND, either express or implied.  See the License for the
 *  specific language governing permissions and limitations
 *  under the License.
 */
package org.apache.isis.extensions.excel.applib;

import java.io.InputStream;
import java.util.List;

import org.apache.isis.applib.exceptions.RecoverableException;
import org.apache.isis.applib.value.Blob;
import org.apache.isis.extensions.excel.applib.service.ExcelServiceDefault;

/**
 * @since 2.0 {@index}
 */
public interface ExcelService {

    String XSLX_MIME_TYPE = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";

    /**
     * Creates a Blob holding a spreadsheet of the domain objects.
     *
     * 
     *     There are no specific restrictions on the domain objects; they can be either persistable entities or
     *     view models.  Do be aware though that if imported back using {@link #fromExcel(Blob, Class, String)},
     *     then new instances are always created.  It is generally better therefore to work with view models than to
     *     work with entities.  This also makes it easier to maintain backward compatibility in the future if the
     *     persistence model changes; using view models represents a stable API for import/export.
     * 
     *
     * @param sheetName - must be 31 chars or less
     */
     Blob toExcel(List domainObjects, Class cls, String sheetName, String fileName)
            throws ExcelServiceDefault.Exception;

     Blob toExcel(List domainObjects, Class cls, String sheetName, String fileName, InputStream in)
            throws ExcelServiceDefault.Exception;

     Blob toExcel(WorksheetContent worksheetContent, String fileName) throws ExcelServiceDefault.Exception;

     Blob toExcel(WorksheetContent worksheetContent, String fileName, InputStream in)
            throws ExcelServiceDefault.Exception;

    Blob toExcel(List worksheetContents, String fileName) throws ExcelServiceDefault.Exception;

    Blob toExcel(List worksheetContents, String fileName, InputStream in)
            throws ExcelServiceDefault.Exception;

     Blob toExcelPivot(List domainObjects, Class cls, String fileName) throws ExcelServiceDefault.Exception;

     Blob toExcelPivot(List domainObjects, Class cls, String sheetName, String fileName)
            throws ExcelServiceDefault.Exception;

     Blob toExcelPivot(WorksheetContent worksheetContent, String fileName) throws ExcelServiceDefault.Exception;

    Blob toExcelPivot(List worksheetContents, String fileName) throws ExcelServiceDefault.Exception;

    /**
     * Returns a list of objects for each line in the spreadsheet, of the specified type.
     *
     * 
     *     If the class is a view model then the objects will be properly instantiated, with the correct
     *     view model memento); otherwise the objects will be simple transient objects.
     * 
     */
     List fromExcel(Blob excelBlob, Class cls, String sheetName) throws ExcelServiceDefault.Exception;

     List fromExcel(Blob excelBlob, Class cls, String sheetName, Mode mode)
            throws ExcelServiceDefault.Exception;

     List fromExcel(Blob excelBlob, WorksheetSpec worksheetSpec) throws ExcelServiceDefault.Exception;

    List> fromExcel(Blob excelBlob, List worksheetSpecs) throws ExcelServiceDefault.Exception;

    List> fromExcel(Blob excelBlob, WorksheetSpec.Matcher matcher) throws ExcelServiceDefault.Exception;

    List> fromExcel(Blob excelBlob, WorksheetSpec.Matcher matcher, WorksheetSpec.Sequencer sequencer)
            throws ExcelServiceDefault.Exception;

    public static class Exception extends RecoverableException {

        private static final long serialVersionUID = 1L;

        public Exception(final String msg, final Throwable ex) {
            super(msg, ex);
        }

        public Exception(final Throwable ex) {
            super(ex);
        }
    }

}