org.autoplot.excel.ExcelUtil
Utilties.
ExcelUtil( )
getColumnNumber
getColumnNumber( HSSFSheet sheet, String id, int firstRow ) → short
Parameters
sheet - a HSSFSheet
id - a String
firstRow - an int
Returns:
short
[search for examples]
[view on GitHub]
[view on old javadoc]
getColumns
getColumns( HSSFWorkbook wb, String ssheet, String firstRowString, ProgressMonitor mon ) → java.util.Map
inspect the first row for columns. Strings may be picked up as labels if the
next row contains values.
Parameters
wb - a HSSFWorkbook
ssheet - the sheet name
firstRowString - the firstRow or null.
mon - a ProgressMonitor
Returns:
a java.util.Map
[search for examples]
[view on GitHub]
[view on old javadoc]
getSheets
getSheets( HSSFWorkbook wb, org.autoplot.datasource.CompletionContext cc, ProgressMonitor mon ) → java.util.List
Parameters
wb - a HSSFWorkbook
cc - a CompletionContext
mon - a ProgressMonitor
Returns:
java.util.List
[search for examples]
[view on GitHub]
[view on old javadoc]