<h2>org.autoplot.excel.ExcelUtil</h2><p>Utilties.</p>
<h2>ExcelUtil( )</h2>
<p></p>

<hr>
<a name="getColumnNumber-HSSFSheet-java.lang.String-int"></a>
<h2>getColumnNumber</h2>
getColumnNumber( HSSFSheet sheet, <a href='https://docs.oracle.com/javase/8/docs/api/java/lang/String.html'>String</a> id, int firstRow ) &rarr; short

<p></p>

<h3>Parameters</h3>
sheet - a HSSFSheet
<br>
id - a String
<br>
firstRow - an int

<h3>Returns:</h3>
short

<br><br>
<a href="https://github.com/autoplot/dev/search?q=getColumnNumber&unscoped_q=getColumnNumber">[search for examples]</a>
 <a href="https://github.com/autoplot/documentation/tree/master/javadoc/org/autoplot/excel/ExcelUtil.md">[view on GitHub]</a>
 <a href="https://cottagesystems.com/~jbf/autoplot/doc2018/org/autoplot/excel/ExcelUtil.html#getColumnNumber-HSSFSheet-java.lang.String-int">[view on old javadoc]</a>
<br>
<br>
<hr>
<a name="getColumns-HSSFWorkbook-java.lang.String-java.lang.String-org.das2.util.monitor.ProgressMonitor"></a>
<h2>getColumns</h2>
getColumns( HSSFWorkbook wb, <a href='https://docs.oracle.com/javase/8/docs/api/java/lang/String.html'>String</a> ssheet, <a href='https://docs.oracle.com/javase/8/docs/api/java/lang/String.html'>String</a> firstRowString, <a href='https://cottagesystems.com/~jbf/autoplot/doc/org/das2/util/monitor/ProgressMonitor.html'>ProgressMonitor</a> mon ) &rarr; <a href='https://docs.oracle.com/javase/8/docs/api/java/util/Map.html'>java.util.Map</a>

<p>inspect the first row for columns.  Strings may be picked up as labels if the
 next row contains values.</p>

<h3>Parameters</h3>
wb - a HSSFWorkbook
<br>
ssheet - the sheet name
<br>
firstRowString - the firstRow or null.
<br>
mon - a ProgressMonitor

<h3>Returns:</h3>
a java.util.Map

<br><br>
<a href="https://github.com/autoplot/dev/search?q=getColumns&unscoped_q=getColumns">[search for examples]</a>
 <a href="https://github.com/autoplot/documentation/tree/master/javadoc/org/autoplot/excel/ExcelUtil.md">[view on GitHub]</a>
 <a href="https://cottagesystems.com/~jbf/autoplot/doc2018/org/autoplot/excel/ExcelUtil.html#getColumns-HSSFWorkbook-java.lang.String-java.lang.String-org.das2.util.monitor.ProgressMonitor">[view on old javadoc]</a>
<br>
<br>
<hr>
<a name="getSheets-HSSFWorkbook-org.autoplot.datasource.CompletionContext-org.das2.util.monitor.ProgressMonitor"></a>
<h2>getSheets</h2>
getSheets( HSSFWorkbook wb, <a href='https://cottagesystems.com/~jbf/autoplot/doc/org/autoplot/datasource/CompletionContext.html'>org.autoplot.datasource.CompletionContext</a> cc, <a href='https://cottagesystems.com/~jbf/autoplot/doc/org/das2/util/monitor/ProgressMonitor.html'>ProgressMonitor</a> mon ) &rarr; <a href='https://docs.oracle.com/javase/8/docs/api/java/util/List.html'>java.util.List</a>

<p></p>

<h3>Parameters</h3>
wb - a HSSFWorkbook
<br>
cc - a CompletionContext
<br>
mon - a ProgressMonitor

<h3>Returns:</h3>
java.util.List

<br><br>
<a href="https://github.com/autoplot/dev/search?q=getSheets&unscoped_q=getSheets">[search for examples]</a>
 <a href="https://github.com/autoplot/documentation/tree/master/javadoc/org/autoplot/excel/ExcelUtil.md">[view on GitHub]</a>
 <a href="https://cottagesystems.com/~jbf/autoplot/doc2018/org/autoplot/excel/ExcelUtil.html#getSheets-HSSFWorkbook-org.autoplot.datasource.CompletionContext-org.das2.util.monitor.ProgressMonitor">[view on old javadoc]</a>
<br>
<br>