public class ExcelDataSource 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 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, 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 |
---|
ExcelDataSource(File file)
Creates a data source instance from an XLSX or XLS file with the default autodetect Excel format.
|
ExcelDataSource(File file,
ExcelFormatEnum format)
Creates a data source instance from an XLSX or XLS file.
|
ExcelDataSource(InputStream is)
Creates a data source instance from an XLSX or XLS data input stream with the default autodetect Excel format.
|
ExcelDataSource(InputStream is,
ExcelFormatEnum format)
Creates a data source instance from an XLSX or XLS data input stream.
|
ExcelDataSource(JasperReportsContext jasperReportsContext,
String location)
Creates a datasource instance that reads XLSX or XLS data from a given location.
|
ExcelDataSource(JasperReportsContext jasperReportsContext,
String location,
ExcelFormatEnum format)
Creates a datasource instance that reads XLSX or XLS data from a given location.
|
ExcelDataSource(String location) |
ExcelDataSource(String location,
ExcelFormatEnum format) |
ExcelDataSource(org.apache.poi.ss.usermodel.Workbook workbook)
Creates a data source instance from a workbook with the default autodetect Excel format.
|
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 ExcelDataSource(org.apache.poi.ss.usermodel.Workbook workbook)
workbook
- the workbookpublic ExcelDataSource(InputStream is) throws JRException, IOException
is
- an input stream containing XLSX or XLS dataJRException
IOException
public ExcelDataSource(InputStream is, ExcelFormatEnum format) throws JRException, IOException
is
- an input stream containing XLSX or XLS dataformat
- the Excel formatJRException
IOException
public ExcelDataSource(File file) throws JRException, IOException
file
- a file containing XLSX or XLS dataFileNotFoundException
JRException
IOException
public ExcelDataSource(File file, ExcelFormatEnum format) throws JRException, IOException
file
- a file containing XLSX or XLS dataformat
- the Excel formatFileNotFoundException
JRException
IOException
public ExcelDataSource(JasperReportsContext jasperReportsContext, String location) throws JRException, IOException
jasperReportsContext
- the JasperReportsContextlocation
- a String representing XLSX or XLS data sourceIOException
JRException
public ExcelDataSource(JasperReportsContext jasperReportsContext, String location, ExcelFormatEnum format) throws JRException, IOException
jasperReportsContext
- the JasperReportsContextlocation
- a String representing XLSX or XLS data sourceformat
- the Excel formatIOException
JRException
public ExcelDataSource(String location) throws JRException, IOException
JRException
IOException
ExcelDataSource(JasperReportsContext, String)
public ExcelDataSource(String location, ExcelFormatEnum format) throws JRException, IOException
JRException
IOException
ExcelDataSource(JasperReportsContext, String)
protected org.apache.poi.ss.usermodel.Workbook loadWorkbook(InputStream inputStream) throws IOException
loadWorkbook
in class AbstractPoiXlsDataSource
IOException
Copyright © 2016. All rights reserved.