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.
/*
* JasperReports - Free Java Reporting Library.
* Copyright (C) 2001 - 2016 TIBCO Software Inc. All rights reserved.
* http://www.jaspersoft.com
*
* Unless you have purchased a commercial license agreement from Jaspersoft,
* the following license terms apply:
*
* This program is part of JasperReports.
*
* JasperReports is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* JasperReports 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 Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public License
* along with JasperReports. If not, see .
*/
package net.sf.jasperreports.engine.query;
import java.util.Map;
import net.sf.jasperreports.annotations.properties.Property;
import net.sf.jasperreports.annotations.properties.PropertyScope;
import net.sf.jasperreports.engine.JRDataset;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JRPropertiesUtil;
import net.sf.jasperreports.engine.JRValueParameter;
import net.sf.jasperreports.engine.JasperReportsContext;
import net.sf.jasperreports.properties.PropertyConstants;
/**
* Query executer factory for Excel file type.
*
* The factory creates {@link net.sf.jasperreports.engine.query.ExcelQueryExecuter ExcelQueryExecuter}
* query executers.
*
* @author sanda zaharia ([email protected])
*/
public class ExcelQueryExecuterFactory extends AbstractXlsQueryExecuterFactory
{
/**
* Built-in parameter/property holding the value of the Excel format to be used when parsing the Excel data.
*/
@Property(
category = PropertyConstants.CATEGORY_DATA_SOURCE,
scopes = {PropertyScope.CONTEXT, PropertyScope.DATASET},
scopeQualifications = {AbstractXlsQueryExecuterFactory.QUERY_EXECUTER_NAME},
sinceVersion = PropertyConstants.VERSION_5_5_2
)
public static final String XLS_FORMAT = JRPropertiesUtil.PROPERTY_PREFIX + "xls.format";
private final static Object[] XLS_BUILTIN_PARAMETERS = {
XLS_WORKBOOK, "org.apache.poi.ss.usermodel.Workbook",
XLS_INPUT_STREAM, "java.io.InputStream",
XLS_FILE, "java.io.File",
XLS_SOURCE, "java.lang.String",
XLS_COLUMN_NAMES, "java.lang.String",
XLS_COLUMN_INDEXES, "java.lang.String",
XLS_COLUMN_NAMES_ARRAY, "java.lang.String[]",
XLS_COLUMN_INDEXES_ARRAY, "java.lang.Integer[]",
XLS_DATE_FORMAT, "java.text.DateFormat",
XLS_DATE_PATTERN, "java.lang.String",
XLS_NUMBER_FORMAT, "java.text.NumberFormat",
XLS_NUMBER_PATTERN, "java.lang.String",
XLS_USE_FIRST_ROW_AS_HEADER, "java.lang.Boolean",
XLS_LOCALE, "java.util.Locale",
XLS_LOCALE_CODE, "java.lang.String",
XLS_TIMEZONE, "java.util.TimeZone",
XLS_TIMEZONE_ID, "java.lang.String",
XLS_SHEET_SELECTION, "java.lang.String",
XLS_FORMAT, "net.sf.jasperreports.data.excel.ExcelFormatEnum"
};
@Override
public Object[] getBuiltinParameters() {
return XLS_BUILTIN_PARAMETERS;
}
@Override
public JRQueryExecuter createQueryExecuter(
JasperReportsContext jasperReportsContext,
JRDataset dataset,
Map parameters
) throws JRException
{
return new ExcelQueryExecuter(jasperReportsContext, dataset, parameters);
}
@Override
public boolean supportsQueryParameterType(String className) {
return true;
}
}