public class XlsDataSource extends AbstractPoiXlsDataSource
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 CSV 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, 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 |
---|
XlsDataSource(File file)
Creates a data source instance from an XLS file.
|
XlsDataSource(InputStream inputStream)
Creates a data source instance from an XLS data input stream.
|
XlsDataSource(JasperReportsContext jasperReportsContext,
String location)
Creates a data source instance that reads XLS data from a given location.
|
XlsDataSource(String location) |
XlsDataSource(org.apache.poi.ss.usermodel.Workbook workbook)
Creates a data source instance from a workbook.
|
Modifier and Type | Method and Description |
---|---|
protected org.apache.poi.ss.usermodel.Workbook |
loadWorkbook(InputStream inputStream) |
checkReadStarted, close, getFieldValue, moveFirst, next
getColumnNames, getDateFormat, getNumberFormat, getSheetSelection, setColumnIndexes, setColumnNames, setColumnNames, setDateFormat, setNumberFormat, setSheetSelection, setUseFirstRowAsHeader
convertNumber, convertStringValue, getConvertBean, getDatePattern, getFormattedDate, getFormattedNumber, getLocale, getNumberPattern, getTextAttributes, getTimeZone, setDatePattern, setLocale, setLocale, setNumberPattern, setTextAttributes, setTextAttributes, setTimeZone, setTimeZone
public XlsDataSource(org.apache.poi.ss.usermodel.Workbook workbook)
workbook
- the workbookpublic XlsDataSource(InputStream inputStream) throws JRException, IOException
inputStream
- an input stream containing XLS dataJRException
IOException
public XlsDataSource(File file) throws JRException, IOException
file
- a file containing XLS dataJRException
IOException
public XlsDataSource(JasperReportsContext jasperReportsContext, String location) throws JRException, IOException
jasperReportsContext
- the JasperReportsContextlocation
- a String representing XLS data sourceIOException
JRException
public XlsDataSource(String location) throws JRException, IOException
JRException
IOException
XlsDataSource(JasperReportsContext, String)
protected org.apache.poi.ss.usermodel.Workbook loadWorkbook(InputStream inputStream) throws IOException
loadWorkbook
in class AbstractPoiXlsDataSource
IOException
Copyright © 2016. All rights reserved.