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]