public abstract class AbstractAnalyseTable extends Object
Constructor and Description |
---|
AbstractAnalyseTable() |
Modifier and Type | Method and Description |
---|---|
protected void |
analyse(URI location)
Load table to analyse from an Excel file.
|
protected void |
analyseHeader(org.apache.poi.ss.usermodel.Sheet sheet)
Analyzes the table header.
|
protected abstract void |
analyseRow(int num,
org.apache.poi.ss.usermodel.Row row)
Analyse a content row.
|
protected String |
extractText(org.apache.poi.ss.usermodel.Cell cell)
Extract the text from a given cell.
|
protected abstract void |
headerCell(int num,
String text) |
protected void analyse(URI location) throws Exception
location
- the file locationException
- if an error occurs loading the fileprotected void analyseHeader(org.apache.poi.ss.usermodel.Sheet sheet)
sheet
- the table sheetprotected abstract void headerCell(int num, String text)
num
- zero based column indextext
- the headerprotected abstract void analyseRow(int num, org.apache.poi.ss.usermodel.Row row)
num
- the row number (starting from one as the header row is handled
separately)row
- the table rowprotected String extractText(org.apache.poi.ss.usermodel.Cell cell)
null
is returnedcell
- the cellBuild 2013-10-07_11-27-38
Revision 99b27713a799a59a21b0b166eaaea8aaefbf125a