public abstract class AbstractPoiXlsDataSource extends AbstractXlsDataSource
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.
columnNames, dateFormat, EXCEPTION_MESSAGE_KEY_XLS_COLUMN_NAMES_MISMATCH_COLUMN_INDEXES, EXCEPTION_MESSAGE_KEY_XLS_FIELD_VALUE_NOT_RETRIEVED, EXCEPTION_MESSAGE_KEY_XLS_SHEET_INDEX_OUT_OF_RANGE, EXCEPTION_MESSAGE_KEY_XLS_SHEET_NOT_FOUND, numberFormat, sheetSelection, useFirstRowAsHeaderEXCEPTION_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 |
|---|
AbstractPoiXlsDataSource(File file)
Creates a data source instance from an XLSX or XLS file.
|
AbstractPoiXlsDataSource(InputStream is)
Creates a data source instance from an XLSX or XLS data input stream.
|
AbstractPoiXlsDataSource(JasperReportsContext jasperReportsContext,
String location)
Creates a data source instance that reads XLSX or XLS data from a given location.
|
AbstractPoiXlsDataSource(String location) |
AbstractPoiXlsDataSource(org.apache.poi.ss.usermodel.Workbook workbook)
Creates a data source instance from a workbook.
|
| Modifier and Type | Method and Description |
|---|---|
protected void |
checkReadStarted() |
void |
close()
Closes the reader.
|
Object |
getFieldValue(JRField jrField)
Gets the field value for the current position.
|
protected abstract org.apache.poi.ss.usermodel.Workbook |
loadWorkbook(InputStream is) |
void |
moveFirst()
Moves back to the first element in the data source.
|
boolean |
next()
Tries to position the cursor on the next element in the data source.
|
getColumnNames, getDateFormat, getNumberFormat, getSheetSelection, setColumnIndexes, setColumnNames, setColumnNames, setDateFormat, setNumberFormat, setSheetSelection, setUseFirstRowAsHeaderconvertNumber, convertStringValue, getConvertBean, getDatePattern, getFormattedDate, getFormattedNumber, getLocale, getNumberPattern, getTextAttributes, getTimeZone, setDatePattern, setLocale, setLocale, setNumberPattern, setTextAttributes, setTextAttributes, setTimeZone, setTimeZonepublic AbstractPoiXlsDataSource(org.apache.poi.ss.usermodel.Workbook workbook)
workbook - the workbookpublic AbstractPoiXlsDataSource(InputStream is) throws JRException, IOException
is - an input stream containing XLSX or XLS dataJRExceptionIOExceptionpublic AbstractPoiXlsDataSource(File file) throws JRException, IOException
file - a file containing XLSX or XLS dataJRExceptionIOExceptionpublic AbstractPoiXlsDataSource(JasperReportsContext jasperReportsContext, String location) throws JRException, IOException
jasperReportsContext - the JasperReportsContextlocation - a String representing XLSX or XLS data sourceIOExceptionJRExceptionpublic AbstractPoiXlsDataSource(String location) throws JRException, IOException
JRExceptionIOExceptionAbstractPoiXlsDataSource(JasperReportsContext, String)protected abstract org.apache.poi.ss.usermodel.Workbook loadWorkbook(InputStream is) throws IOException
IOExceptionpublic boolean next()
throws JRException
JRDataSourceJRException - if any error occurs while trying to move to the next elementpublic void moveFirst()
JRRewindableDataSourcepublic Object getFieldValue(JRField jrField) throws JRException
JRDataSourceJRExceptionpublic void close()
close in class AbstractXlsDataSourceprotected void checkReadStarted()
checkReadStarted in class AbstractXlsDataSourceCopyright © 2017. All rights reserved.