public abstract class AbstractXlsQueryExecuterFactory extends AbstractQueryExecuterFactory
Modifier and Type | Field and Description |
---|---|
static String |
XLS_COLUMN_INDEXES
Built-in parameter/property holding the value of the column indexes to be extracted from the Excel source.
|
static String |
XLS_COLUMN_INDEXES_ARRAY
Built-in parameter holding the value of the column indexes to be extracted from the Excel source, as a
java.lang.Integer[] object. |
static String |
XLS_COLUMN_NAMES
Built-in parameter/property holding the value of the columns to be extracted from the Excel source.
|
static String |
XLS_COLUMN_NAMES_ARRAY
Built-in parameter holding the value of the columns to be extracted from the Excel source, as a
java.lang.String[] object. |
static String |
XLS_DATE_FORMAT
Built-in parameter holding the value of the
java.text.DateFormat used to format date columns from the Excel source. |
static String |
XLS_DATE_PATTERN
Built-in parameter/property holding the value of the date format pattern to be used when parsing the Excel data.
|
static String |
XLS_FILE
Built-in parameter holding the value of the
java.io.File to be used for obtaining the Excel data. |
static String |
XLS_INPUT_STREAM
Built-in parameter holding the value of the
java.io.InputStream to be used for obtaining the Excel data. |
static String |
XLS_LOCALE
Built-in parameter holding the
java.util.Locale value of the locale to be used when parsing the Excel data. |
static String |
XLS_LOCALE_CODE
Built-in parameter/property holding the
java.lang.String code of the locale to be used when parsing the Excel data. |
static String |
XLS_NUMBER_FORMAT
Built-in parameter holding the value of the
java.text.NumberFormat used to format numeric columns from the Excel source. |
static String |
XLS_NUMBER_PATTERN
Built-in parameter/property holding the value of the number format pattern to be used when parsing the Excel data.
|
static String |
XLS_SHEET_SELECTION
Built-in parameter/property holding the value of the sheet name to be used when parsing the Excel data.
|
static String |
XLS_SOURCE
Built-in parameter/property holding the value of the
java.lang.String source to be used for obtaining the Excel data. |
static String |
XLS_TIMEZONE
Built-in parameter holding the
java.util.TimeZone value of the timezone to be used when parsing the Excel data. |
static 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 Excel data. |
static 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 Excel source.
|
static String |
XLS_WORKBOOK
Built-in parameter holding the value of the
Workbook to be used for obtaining the Excel data. |
QUERY_EXECUTER_FACTORY_PREFIX
Constructor and Description |
---|
AbstractXlsQueryExecuterFactory() |
createQueryExecuter
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
createQueryExecuter, getBuiltinParameters, supportsQueryParameterType
public static final String XLS_WORKBOOK
Workbook
to be used for obtaining the Excel data.public static final String XLS_INPUT_STREAM
java.io.InputStream
to be used for obtaining the Excel data.public static final String XLS_FILE
java.io.File
to be used for obtaining the Excel data.public static final String XLS_SOURCE
java.lang.String
source to be used for obtaining the Excel data.public static final 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 Excel columns in the format:
net.sf.jasperreports.xls.column.names.{arbitrary_name}=value1[, value2, ...]
public static final 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 Excel column indexes in the format:
net.sf.jasperreports.xls.column.indexes.{arbitrary_name}=value1[, value2, ...]
public static final 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 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 String XLS_LOCALE
java.util.Locale
value of the locale to be used when parsing the Excel data.public static final String XLS_LOCALE_CODE
java.lang.String
code of the locale to be used when parsing the Excel data.
The allowed format is: language[_country[_variant]]public static final String XLS_TIMEZONE
java.util.TimeZone
value of the timezone to be used when parsing the Excel data.public static final String XLS_TIMEZONE_ID
java.lang.String
value of the time zone id to be used when parsing the Excel data.public static final String XLS_DATE_FORMAT
java.text.DateFormat
used to format date columns from the Excel source.public static final String XLS_DATE_PATTERN
public static final String XLS_NUMBER_FORMAT
java.text.NumberFormat
used to format numeric columns from the Excel source.public static final String XLS_NUMBER_PATTERN
public static final String XLS_SHEET_SELECTION
public static final 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.Copyright © 2016. All rights reserved.