<h2>org.autoplot.excel.ExcelSpreadsheetDataSourceEditorPanel</h2><p>Read data from Excel spreadsheets. This supports .xls, but not .xlsx.</p> <h2>ExcelSpreadsheetDataSourceEditorPanel( )</h2> <p></p> <hr> <a name="PROP_FILE"></a> <h2>PROP_FILE</h2> <p></p> <hr> <a name="PROP_SHEET"></a> <h2>PROP_SHEET</h2> <p></p> <hr> <a name="PROP_FIRST_ROW"></a> <h2>PROP_FIRST_ROW</h2> <p></p> <hr> <a name="PROP_COLUMN"></a> <h2>PROP_COLUMN</h2> <p></p> <hr> <a name="PROP_DEP0"></a> <h2>PROP_DEP0</h2> <p></p> <hr> <a name="columnsComboBox"></a> <h2>columnsComboBox</h2> <p></p> <hr> <a name="dep0Columns"></a> <h2>dep0Columns</h2> <p></p> <hr> <a name="firstRowTextField"></a> <h2>firstRowTextField</h2> <p></p> <hr> <a name="jLabel1"></a> <h2>jLabel1</h2> <p></p> <hr> <a name="jLabel2"></a> <h2>jLabel2</h2> <p></p> <hr> <a name="jLabel3"></a> <h2>jLabel3</h2> <p></p> <hr> <a name="jLabel4"></a> <h2>jLabel4</h2> <p></p> <hr> <a name="jPanel1"></a> <h2>jPanel1</h2> <p></p> <hr> <a name="jScrollPane1"></a> <h2>jScrollPane1</h2> <p></p> <hr> <a name="jTable1"></a> <h2>jTable1</h2> <p></p> <hr> <a name="jToggleButton1"></a> <h2>jToggleButton1</h2> <p></p> <hr> <a name="jToggleButton2"></a> <h2>jToggleButton2</h2> <p></p> <hr> <a name="jToggleButton3"></a> <h2>jToggleButton3</h2> <p></p> <hr> <a name="sViewer1"></a> <h2>sViewer1</h2> <p></p> <hr> <a name="sheetComboBox"></a> <h2>sheetComboBox</h2> <p></p> <hr> <a name="getFile"></a> <h2>getFile</h2> getFile( ) → <a href='https://docs.oracle.com/javase/8/docs/api/java/io/File.html'>java.io.File</a> <p></p> <h3>Returns:</h3> java.io.File <br><br> <a href="https://github.com/autoplot/dev/search?q=getFile&unscoped_q=getFile">[search for examples]</a> <a href="https://github.com/autoplot/documentation/tree/master/javadoc/org/autoplot/excel/ExcelSpreadsheetDataSourceEditorPanel.md">[view on GitHub]</a> <a href="https://cottagesystems.com/~jbf/autoplot/doc2018/org/autoplot/excel/ExcelSpreadsheetDataSourceEditorPanel.html#getFile">[view on old javadoc]</a> <br> <br> <hr> <a name="getPanel"></a> <h2>getPanel</h2> getPanel( ) → <a href='https://cottagesystems.com/~jbf/autoplot/doc/javax/swing/JPanel.html'>javax.swing.JPanel</a> <p></p> <h3>Returns:</h3> javax.swing.JPanel <br><br> <a href="https://github.com/autoplot/dev/search?q=getPanel&unscoped_q=getPanel">[search for examples]</a> <a href="https://github.com/autoplot/documentation/tree/master/javadoc/org/autoplot/excel/ExcelSpreadsheetDataSourceEditorPanel.md">[view on GitHub]</a> <a href="https://cottagesystems.com/~jbf/autoplot/doc2018/org/autoplot/excel/ExcelSpreadsheetDataSourceEditorPanel.html#getPanel">[view on old javadoc]</a> <br> <br> <hr> <a name="getSheet"></a> <h2>getSheet</h2> getSheet( ) → <a href='https://docs.oracle.com/javase/8/docs/api/java/lang/String.html'>String</a> <p></p> <h3>Returns:</h3> java.lang.String <br><br> <a href="https://github.com/autoplot/dev/search?q=getSheet&unscoped_q=getSheet">[search for examples]</a> <a href="https://github.com/autoplot/documentation/tree/master/javadoc/org/autoplot/excel/ExcelSpreadsheetDataSourceEditorPanel.md">[view on GitHub]</a> <a href="https://cottagesystems.com/~jbf/autoplot/doc2018/org/autoplot/excel/ExcelSpreadsheetDataSourceEditorPanel.html#getSheet">[view on old javadoc]</a> <br> <br> <hr> <a name="getURI"></a> <h2>getURI</h2> getURI( ) → <a href='https://docs.oracle.com/javase/8/docs/api/java/lang/String.html'>String</a> <p></p> <h3>Returns:</h3> java.lang.String <br><br> <a href="https://github.com/autoplot/dev/search?q=getURI&unscoped_q=getURI">[search for examples]</a> <a href="https://github.com/autoplot/documentation/tree/master/javadoc/org/autoplot/excel/ExcelSpreadsheetDataSourceEditorPanel.md">[view on GitHub]</a> <a href="https://cottagesystems.com/~jbf/autoplot/doc2018/org/autoplot/excel/ExcelSpreadsheetDataSourceEditorPanel.html#getURI">[view on old javadoc]</a> <br> <br> <hr> <a name="markProblems-java.util.List"></a> <h2>markProblems</h2> markProblems( <a href='https://docs.oracle.com/javase/8/docs/api/java/util/List.html'>java.util.List</a> problems ) → void <p></p> <h3>Parameters</h3> problems - a java.util.List <h3>Returns:</h3> void (returns nothing) <br><br> <a href="https://github.com/autoplot/dev/search?q=markProblems&unscoped_q=markProblems">[search for examples]</a> <a href="https://github.com/autoplot/documentation/tree/master/javadoc/org/autoplot/excel/ExcelSpreadsheetDataSourceEditorPanel.md">[view on GitHub]</a> <a href="https://cottagesystems.com/~jbf/autoplot/doc2018/org/autoplot/excel/ExcelSpreadsheetDataSourceEditorPanel.html#markProblems-java.util.List">[view on old javadoc]</a> <br> <br> <hr> <a name="prepare-java.lang.String-java.awt.Window-org.das2.util.monitor.ProgressMonitor"></a> <h2>prepare</h2> prepare( <a href='https://docs.oracle.com/javase/8/docs/api/java/lang/String.html'>String</a> uri, <a href='https://docs.oracle.com/javase/8/docs/api/java/awt/Window.html'>java.awt.Window</a> parent, <a href='https://cottagesystems.com/~jbf/autoplot/doc/org/das2/util/monitor/ProgressMonitor.html'>ProgressMonitor</a> mon ) → boolean <p></p> <h3>Parameters</h3> uri - a String <br> parent - a Window <br> mon - a ProgressMonitor <h3>Returns:</h3> boolean <br><br> <a href="https://github.com/autoplot/dev/search?q=prepare&unscoped_q=prepare">[search for examples]</a> <a href="https://github.com/autoplot/documentation/tree/master/javadoc/org/autoplot/excel/ExcelSpreadsheetDataSourceEditorPanel.md">[view on GitHub]</a> <a href="https://cottagesystems.com/~jbf/autoplot/doc2018/org/autoplot/excel/ExcelSpreadsheetDataSourceEditorPanel.html#prepare-java.lang.String-java.awt.Window-org.das2.util.monitor.ProgressMonitor">[view on old javadoc]</a> <br> <br> <hr> <a name="reject-java.lang.String"></a> <h2>reject</h2> reject( <a href='https://docs.oracle.com/javase/8/docs/api/java/lang/String.html'>String</a> url ) → boolean <p></p> <h3>Parameters</h3> url - a String <h3>Returns:</h3> boolean <br><br> <a href="https://github.com/autoplot/dev/search?q=reject&unscoped_q=reject">[search for examples]</a> <a href="https://github.com/autoplot/documentation/tree/master/javadoc/org/autoplot/excel/ExcelSpreadsheetDataSourceEditorPanel.md">[view on GitHub]</a> <a href="https://cottagesystems.com/~jbf/autoplot/doc2018/org/autoplot/excel/ExcelSpreadsheetDataSourceEditorPanel.html#reject-java.lang.String">[view on old javadoc]</a> <br> <br> <hr> <a name="setFile-java.io.File"></a> <h2>setFile</h2> setFile( <a href='https://docs.oracle.com/javase/8/docs/api/java/io/File.html'>java.io.File</a> file ) → void <p></p> <h3>Parameters</h3> file - a File <h3>Returns:</h3> void (returns nothing) <br><br> <a href="https://github.com/autoplot/dev/search?q=setFile&unscoped_q=setFile">[search for examples]</a> <a href="https://github.com/autoplot/documentation/tree/master/javadoc/org/autoplot/excel/ExcelSpreadsheetDataSourceEditorPanel.md">[view on GitHub]</a> <a href="https://cottagesystems.com/~jbf/autoplot/doc2018/org/autoplot/excel/ExcelSpreadsheetDataSourceEditorPanel.html#setFile-java.io.File">[view on old javadoc]</a> <br> <br> <hr> <a name="setSheet-java.lang.String"></a> <h2>setSheet</h2> setSheet( <a href='https://docs.oracle.com/javase/8/docs/api/java/lang/String.html'>String</a> sheet ) → void <p></p> <h3>Parameters</h3> sheet - a String <h3>Returns:</h3> void (returns nothing) <br><br> <a href="https://github.com/autoplot/dev/search?q=setSheet&unscoped_q=setSheet">[search for examples]</a> <a href="https://github.com/autoplot/documentation/tree/master/javadoc/org/autoplot/excel/ExcelSpreadsheetDataSourceEditorPanel.md">[view on GitHub]</a> <a href="https://cottagesystems.com/~jbf/autoplot/doc2018/org/autoplot/excel/ExcelSpreadsheetDataSourceEditorPanel.html#setSheet-java.lang.String">[view on old javadoc]</a> <br> <br> <hr> <a name="setURI-java.lang.String"></a> <h2>setURI</h2> setURI( <a href='https://docs.oracle.com/javase/8/docs/api/java/lang/String.html'>String</a> url ) → void <p></p> <h3>Parameters</h3> url - a String <h3>Returns:</h3> void (returns nothing) <br><br> <a href="https://github.com/autoplot/dev/search?q=setURI&unscoped_q=setURI">[search for examples]</a> <a href="https://github.com/autoplot/documentation/tree/master/javadoc/org/autoplot/excel/ExcelSpreadsheetDataSourceEditorPanel.md">[view on GitHub]</a> <a href="https://cottagesystems.com/~jbf/autoplot/doc2018/org/autoplot/excel/ExcelSpreadsheetDataSourceEditorPanel.html#setURI-java.lang.String">[view on old javadoc]</a> <br> <br>