|
Style Intelligence v12.0 | ||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
java.lang.Objectinetsoft.uql.text.ExcelFileInfo
public class ExcelFileInfo
Descriptor for a Microsoft Excel file.
| Constructor Summary | |
|---|---|
ExcelFileInfo()
Creates a new instance of ExcelFileInfo. |
|
| Method Summary | |
|---|---|
static int |
getColumnIndex(String label)
Gets the column index for the specified Excel column label. |
static String |
getColumnLabel(int index)
Gets the Excel column label for the specified column index. |
int |
getEndColumn()
Gets the index of the last data column. |
int |
getEndRow()
Gets the index of the last data row. |
static int |
getRowIndex(String label)
Gets the row index for the specified Excel row label. |
static String |
getRowLabel(int index)
Gets the Excel row label for the specified row index. |
String |
getSheet()
Gets the name of the sheet that contains the data. |
ArrayList |
getSheets()
Get the name of the sheet that contains in file. |
int |
getStartColumn()
Gets the index of the first data column. |
int |
getStartRow()
Gets the index of the first data row. |
void |
parseXML(Element tag)
|
void |
setEndColumn(int endColumn)
Sets the index of the last data column. |
void |
setEndRow(int endRow)
Sets the index of the last data row. |
void |
setSheet(String sheet)
Sets the name of the sheet that contains the data. |
void |
setSheets(ArrayList sheets)
Sets the name of the sheets that contains in the file. |
void |
setStartColumn(int startColumn)
Sets the index of the first data column. |
void |
setStartRow(int startRow)
Sets the index of the first data row. |
void |
writeXML(PrintWriter writer)
|
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Constructor Detail |
|---|
public ExcelFileInfo()
| Method Detail |
|---|
public final String getSheet()
public final void setSheet(String sheet)
sheet - the sheet name.public final ArrayList getSheets()
sheet - the sheet name.public final void setSheets(ArrayList sheets)
sheet - the sheet name.public final int getStartRow()
public final void setStartRow(int startRow)
startRow - the zero-based row index.public final int getEndRow()
public final void setEndRow(int endRow)
endRow - the zero-based row index.public final int getStartColumn()
public final void setStartColumn(int startColumn)
startColumn - the zero-based column index.public final int getEndColumn()
public final void setEndColumn(int endColumn)
endColumn - the zero-based row index.
public void parseXML(Element tag)
throws Exception
parseXML in interface inetsoft.util.XMLSerializableExceptionpublic void writeXML(PrintWriter writer)
writeXML in interface inetsoft.util.XMLSerializablepublic static String getRowLabel(int index)
index - the row index.
public static int getRowIndex(String label)
label - the row label.
public static String getColumnLabel(int index)
index - the column index.
public static int getColumnIndex(String label)
label - the column label.
|
Copyright © 1996-2014 InetSoft Technology Corp. All Rights Reserved. | ||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||