public abstract class AbstractXlsDataSource extends JRAbstractTextDataSource implements JRRewindableDataSource
The default naming convention is to name report fields COLUMN_x and map each column with the field found at index x in each row (these indices start with 0). To avoid this situation, users can either specify a collection of column names or set a flag to read the column names from the first row of the XLSX or XLS file.
Modifier and Type | Field and Description |
---|---|
protected java.util.Map<java.lang.String,java.lang.Integer> |
columnNames |
protected java.text.DateFormat |
dateFormat |
static java.lang.String |
EXCEPTION_MESSAGE_KEY_XLS_COLUMN_NAMES_MISMATCH_COLUMN_INDEXES |
static java.lang.String |
EXCEPTION_MESSAGE_KEY_XLS_FIELD_VALUE_NOT_RETRIEVED |
static java.lang.String |
EXCEPTION_MESSAGE_KEY_XLS_SHEET_INDEX_OUT_OF_RANGE |
static java.lang.String |
EXCEPTION_MESSAGE_KEY_XLS_SHEET_NOT_FOUND |
protected java.text.NumberFormat |
numberFormat |
protected java.lang.String |
sheetSelection |
protected boolean |
useFirstRowAsHeader |
EXCEPTION_MESSAGE_KEY_CANNOT_CONVERT_FIELD_TYPE, EXCEPTION_MESSAGE_KEY_CANNOT_MODIFY_PROPERTIES_AFTER_START, EXCEPTION_MESSAGE_KEY_NODE_NOT_AVAILABLE, EXCEPTION_MESSAGE_KEY_NULL_DOCUMENT, EXCEPTION_MESSAGE_KEY_NULL_SELECT_EXPRESSION, EXCEPTION_MESSAGE_KEY_UNKNOWN_COLUMN_NAME, EXCEPTION_MESSAGE_KEY_UNKNOWN_NUMBER_TYPE
Constructor and Description |
---|
AbstractXlsDataSource() |
Modifier and Type | Method and Description |
---|---|
protected abstract void |
checkReadStarted() |
abstract void |
close()
Closes the reader.
|
java.util.Map<java.lang.String,java.lang.Integer> |
getColumnNames() |
java.text.DateFormat |
getDateFormat()
Gets the date format that will be used to parse date fields.
|
java.text.NumberFormat |
getNumberFormat()
Gets the number format that will be used to parse numeric fields.
|
java.lang.String |
getSheetSelection() |
void |
setColumnIndexes(java.lang.Integer[] columnIndexes)
Specifies an array of integers representing the column indexes in the sheet.
|
void |
setColumnNames(java.lang.String[] columnNames)
Specifies an array of strings representing column names matching field names in the report template.
|
void |
setColumnNames(java.lang.String[] columnNames,
int[] columnIndexes)
Specifies an array of strings representing column names matching field names in the report template
and an array of integers representing the column indexes in the sheet.
|
void |
setDateFormat(java.text.DateFormat dateFormat)
Sets the desired date format to be used for parsing date fields.
|
void |
setNumberFormat(java.text.NumberFormat numberFormat)
Sets the desired number format to be used for parsing numeric fields.
|
void |
setSheetSelection(java.lang.String sheetSelection) |
void |
setUseFirstRowAsHeader(boolean useFirstRowAsHeader)
Specifies whether the first row of the XLS file should be considered a table
header, containing column names matching field names in the report template.
|
convertNumber, convertStringValue, getConvertBean, getDatePattern, getFormattedDate, getFormattedNumber, getLocale, getNumberPattern, getTextAttributes, getTimeZone, setDatePattern, setLocale, setLocale, setNumberPattern, setTextAttributes, setTextAttributes, setTimeZone, setTimeZone
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
moveFirst
getFieldValue, next
public static final java.lang.String EXCEPTION_MESSAGE_KEY_XLS_COLUMN_NAMES_MISMATCH_COLUMN_INDEXES
public static final java.lang.String EXCEPTION_MESSAGE_KEY_XLS_FIELD_VALUE_NOT_RETRIEVED
public static final java.lang.String EXCEPTION_MESSAGE_KEY_XLS_SHEET_INDEX_OUT_OF_RANGE
public static final java.lang.String EXCEPTION_MESSAGE_KEY_XLS_SHEET_NOT_FOUND
protected java.lang.String sheetSelection
protected java.text.DateFormat dateFormat
protected java.text.NumberFormat numberFormat
protected java.util.Map<java.lang.String,java.lang.Integer> columnNames
protected boolean useFirstRowAsHeader
public java.text.DateFormat getDateFormat()
public void setDateFormat(java.text.DateFormat dateFormat)
public java.text.NumberFormat getNumberFormat()
public void setNumberFormat(java.text.NumberFormat numberFormat)
public void setColumnNames(java.lang.String[] columnNames)
public void setColumnNames(java.lang.String[] columnNames, int[] columnIndexes)
public void setColumnIndexes(java.lang.Integer[] columnIndexes)
public void setUseFirstRowAsHeader(boolean useFirstRowAsHeader)
public abstract void close()
protected abstract void checkReadStarted()
public java.util.Map<java.lang.String,java.lang.Integer> getColumnNames()
public java.lang.String getSheetSelection()
public void setSheetSelection(java.lang.String sheetSelection)
© 2001-2014 TIBCO Software Inc. www.jaspersoft.com