org.autoplot.excel.ExcelUtil

Utilties.

ExcelUtil( )

getColumnNumber( HSSFSheet sheet, String id, int firstRow ) → short [view source]

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( HSSFWorkbook wb, org.autoplot.datasource.CompletionContext cc, ProgressMonitor mon ) → java.util.List [view source]