Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance. Project price only 1 $
You can buy this project and download/modify it how often you want.
/**
* 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.metamodel.excel;
import java.io.Closeable;
import java.io.File;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;
import java.util.concurrent.ConcurrentHashMap;
import org.apache.metamodel.data.DataSet;
import org.apache.metamodel.data.RowPublisherDataSet;
import org.apache.metamodel.data.Style;
import org.apache.metamodel.query.SelectItem;
import org.apache.metamodel.schema.Column;
import org.apache.metamodel.schema.ColumnType;
import org.apache.metamodel.schema.MutableColumn;
import org.apache.metamodel.schema.MutableSchema;
import org.apache.metamodel.schema.MutableTable;
import org.apache.metamodel.schema.Schema;
import org.apache.metamodel.schema.Table;
import org.apache.metamodel.util.AlphabeticSequence;
import org.apache.metamodel.util.FileHelper;
import org.apache.metamodel.util.FileResource;
import org.apache.metamodel.util.Resource;
import org.apache.poi.openxml4j.opc.OPCPackage;
import org.apache.poi.xssf.eventusermodel.XSSFReader;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.xml.sax.InputSource;
import org.xml.sax.XMLReader;
/**
* {@link SpreadsheetReaderDelegate} implementation for the "new" XLSX format.
* This implementation is very efficient as it uses SAX XML parsing which does
* not bloat memory usage in the same way that POI's user model does.
*/
final class XlsxSpreadsheetReaderDelegate implements SpreadsheetReaderDelegate {
private static final Logger logger = LoggerFactory.getLogger(XlsxSpreadsheetReaderDelegate.class);
private final Resource _resource;
private final ExcelConfiguration _configuration;
private final Map _tableNamesToInternalIds;
public XlsxSpreadsheetReaderDelegate(Resource resource, ExcelConfiguration configuration) {
_resource = resource;
_configuration = configuration;
_tableNamesToInternalIds = new ConcurrentHashMap();
}
@Override
public DataSet executeQuery(Table table, Column[] columns, int maxRows) throws Exception {
final OPCPackage pkg = openOPCPackage();
final XSSFReader xssfReader = new XSSFReader(pkg);
final String relationshipId = _tableNamesToInternalIds.get(table.getName());
if (relationshipId == null) {
throw new IllegalStateException("No internal relationshipId found for table: " + table);
}
return buildDataSet(columns, maxRows, relationshipId, xssfReader, pkg);
}
private OPCPackage openOPCPackage() throws Exception {
if (_resource instanceof FileResource) {
final File file = ((FileResource) _resource).getFile();
return OPCPackage.open(file);
}
return OPCPackage.open(_resource.read());
}
@Override
public Schema createSchema(String schemaName) throws Exception {
final MutableSchema schema = new MutableSchema(schemaName);
final OPCPackage pkg = openOPCPackage();
try {
final XSSFReader xssfReader = new XSSFReader(pkg);
final XlsxWorkbookToTablesHandler workbookToTables = new XlsxWorkbookToTablesHandler(schema,
_tableNamesToInternalIds);
buildTables(xssfReader, workbookToTables);
for (Entry entry : _tableNamesToInternalIds.entrySet()) {
final String tableName = entry.getKey();
final String relationshipId = entry.getValue();
final MutableTable table = (MutableTable) schema.getTableByName(tableName);
buildColumns(table, relationshipId, xssfReader);
}
} finally {
pkg.revert();
}
return schema;
}
@Override
public void notifyTablesModified() {
final XlsxWorkbookToTablesHandler workbookToTables = new XlsxWorkbookToTablesHandler(null,
_tableNamesToInternalIds);
try {
final OPCPackage pkg = openOPCPackage();
try {
final XSSFReader xssfReader = new XSSFReader(pkg);
buildTables(xssfReader, workbookToTables);
} finally {
pkg.revert();
}
} catch (Exception e) {
throw new IllegalStateException(e);
}
}
private DataSet buildDataSet(final Column[] columns, int maxRows, final String relationshipId,
final XSSFReader xssfReader, final OPCPackage pkg) throws Exception {
List selectItems = new ArrayList(columns.length);
for (Column column : columns) {
selectItems.add(new SelectItem(column));
}
final XlsxRowPublisherAction publishAction = new XlsxRowPublisherAction(_configuration, columns,
relationshipId, xssfReader);
return new RowPublisherDataSet(selectItems.toArray(new SelectItem[selectItems.size()]), maxRows, publishAction,
new Closeable() {
@Override
public void close() throws IOException {
pkg.revert();
}
});
}
private void buildColumns(final MutableTable table, final String relationshipId, final XSSFReader xssfReader)
throws Exception {
final InputStream sheetData = xssfReader.getSheet(relationshipId);
final XlsxRowCallback rowCallback = new XlsxRowCallback() {
@Override
public boolean row(int rowNumber, List values, List
