public class JRXlsQueryExecuterFactory extends java.lang.Object implements JRQueryExecuterFactory
JRXlsQueryExecuter
query executers.Modifier and Type | Field and Description |
---|---|
static java.lang.String |
XLS_COLUMN_INDEXES
Built-in parameter/property holding the value of the column indexs to be extracted from the XLS source.
|
static java.lang.String |
XLS_COLUMN_INDEXES_ARRAY
Built-in parameter holding the value of the column indexes to be extracted from the XLS source, as a
java.lang.Integer[] object. |
static java.lang.String |
XLS_COLUMN_NAMES
Built-in parameter/property holding the value of the columns to be extracted from the XLS source.
|
static java.lang.String |
XLS_COLUMN_NAMES_ARRAY
Built-in parameter holding the value of the columns to be extracted from the XLS source, as a
java.lang.String[] object. |
static java.lang.String |
XLS_DATE_FORMAT
Built-in parameter holding the value of the
java.text.DateFormat used to format date columns from the XLS source. |
static java.lang.String |
XLS_DATE_PATTERN
Built-in parameter/property holding the value of the date format pattern to be used when parsing the XLS data.
|
static java.lang.String |
XLS_FILE
Built-in parameter holding the value of the
java.io.File to be used for obtaining the XLS data. |
static java.lang.String |
XLS_INPUT_STREAM
Built-in parameter holding the value of the
java.io.InputStream to be used for obtaining the XLS data. |
static java.lang.String |
XLS_LOCALE
Built-in parameter holding the
java.util.Locale value of the locale to be used when parsing the XLS data. |
static java.lang.String |
XLS_LOCALE_CODE
Built-in parameter/property holding the
java.lang.String code of the locale to be used when parsing the XLS data. |
static java.lang.String |
XLS_NUMBER_FORMAT
Built-in parameter holding the value of the
java.text.NumberFormat used to format numeric columns from the XLS source. |
static java.lang.String |
XLS_NUMBER_PATTERN
Built-in parameter/property holding the value of the number format pattern to be used when parsing the XLS data.
|
static java.lang.String |
XLS_SOURCE
Built-in parameter holding the value of the
java.lang.String source to be used for obtaining the XLS data. |
static java.lang.String |
XLS_TIMEZONE
Built-in parameter holding the
java.util.TimeZone value of the timezone to be used when parsing the XLS data. |
static java.lang.String |
XLS_TIMEZONE_ID
Built-in parameter/property holding the
java.lang.String value of the time zone id to be used when parsing the XLS data. |
static java.lang.String |
XLS_USE_FIRST_ROW_AS_HEADER
Built-in parameter/property specifying whether or not the column names should be obtained
from the first row in the XLS source.
|
static java.lang.String |
XLS_WORKBOOK
Built-in parameter holding the value of the
jxl.Workbook to be used for obtaining the XLS data. |
QUERY_EXECUTER_FACTORY_PREFIX
Constructor and Description |
---|
JRXlsQueryExecuterFactory() |
Modifier and Type | Method and Description |
---|---|
JRQueryExecuter |
createQueryExecuter(JRDataset dataset,
java.util.Map parameters)
Creates a query executer.
|
java.lang.Object[] |
getBuiltinParameters()
Returns the built-in parameters associated with this query type.
|
boolean |
supportsQueryParameterType(java.lang.String className)
Decides whether the query executers created by this factory support a query parameter type.
|
public static final java.lang.String XLS_WORKBOOK
jxl.Workbook
to be used for obtaining the XLS data.public static final java.lang.String XLS_INPUT_STREAM
java.io.InputStream
to be used for obtaining the XLS data.public static final java.lang.String XLS_FILE
java.io.File
to be used for obtaining the XLS data.public static final java.lang.String XLS_SOURCE
java.lang.String
source to be used for obtaining the XLS data.public static final java.lang.String XLS_COLUMN_NAMES
java.lang.String
object containing column names separated by commas.
It can also be used as the prefix for custom dataset properties specifying the names of the XLS columns in the format:
net.sf.jasperreports.xls.column.names.{arbitrary_name}=value1[, value2, ...]
public static final java.lang.String XLS_COLUMN_INDEXES
java.lang.String
object containing column indexes separated by comma.
It can also be used as the prefix for custom dataset properties specifying the names of the XLS column indexes in the format:
net.sf.jasperreports.xls.column.indexes.{arbitrary_name}=value1[, value2, ...]
public static final java.lang.String XLS_COLUMN_NAMES_ARRAY
java.lang.String[]
object.
When this parameter is null or missing, its value defaults to the values provided
by properties prefixed with XLS_COLUMN_NAMES
.public static final java.lang.String XLS_COLUMN_INDEXES_ARRAY
java.lang.Integer[]
object.
When this parameter is null or missing, its value defaults to the values provided
by properties prefixed with XLS_COLUMN_INDEXES
.public static final java.lang.String XLS_LOCALE
java.util.Locale
value of the locale to be used when parsing the XLS data.public static final java.lang.String XLS_LOCALE_CODE
java.lang.String
code of the locale to be used when parsing the XLS data.
The allowed format is: language[_country[_variant]]public static final java.lang.String XLS_TIMEZONE
java.util.TimeZone
value of the timezone to be used when parsing the XLS data.public static final java.lang.String XLS_TIMEZONE_ID
java.lang.String
value of the time zone id to be used when parsing the XLS data.public static final java.lang.String XLS_DATE_FORMAT
java.text.DateFormat
used to format date columns from the XLS source.public static final java.lang.String XLS_DATE_PATTERN
public static final java.lang.String XLS_NUMBER_FORMAT
java.text.NumberFormat
used to format numeric columns from the XLS source.public static final java.lang.String XLS_NUMBER_PATTERN
public static final java.lang.String XLS_USE_FIRST_ROW_AS_HEADER
java.lang.Boolean
value, while as custom dataset property, it should be true or false.
If this parameter is set to true, then setting the XLS_COLUMN_NAMES
or XLS_COLUMN_NAMES_ARRAY
would have no effect.public java.lang.Object[] getBuiltinParameters()
JRQueryExecuterFactory
{"Param1", String.class, "Param2", "List.class"}
).getBuiltinParameters
in interface JRQueryExecuterFactory
public JRQueryExecuter createQueryExecuter(JRDataset dataset, java.util.Map parameters) throws JRException
JRQueryExecuterFactory
createQueryExecuter
in interface JRQueryExecuterFactory
dataset
- the dataset containing the query, fields, etcparameters
- map of value parameters (instances of JRValueParameter
)
indexed by nameJRException
public boolean supportsQueryParameterType(java.lang.String className)
JRQueryExecuterFactory
supportsQueryParameterType
in interface JRQueryExecuterFactory
className
- the value class name of the parameter© 2001-2010 Jaspersoft Corporation www.jaspersoft.com