Style Intelligence v12.0

inetsoft.uql.text
Class ExcelFileInfo

java.lang.Object
  extended by inetsoft.uql.text.ExcelFileInfo
All Implemented Interfaces:
TextFileInfo, inetsoft.util.XMLSerializable, Cloneable

public class ExcelFileInfo
extends Object
implements TextFileInfo

Descriptor for a Microsoft Excel file.

Since:
11.0

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

ExcelFileInfo

public ExcelFileInfo()
Creates a new instance of ExcelFileInfo.

Method Detail

getSheet

public final String getSheet()
Gets the name of the sheet that contains the data.

Returns:
the sheet name.

setSheet

public final void setSheet(String sheet)
Sets the name of the sheet that contains the data.

Parameters:
sheet - the sheet name.

getSheets

public final ArrayList getSheets()
Get the name of the sheet that contains in file.

Parameters:
sheet - the sheet name.

setSheets

public final void setSheets(ArrayList sheets)
Sets the name of the sheets that contains in the file.

Parameters:
sheet - the sheet name.

getStartRow

public final int getStartRow()
Gets the index of the first data row.

Returns:
the zero-based row index.

setStartRow

public final void setStartRow(int startRow)
Sets the index of the first data row.

Parameters:
startRow - the zero-based row index.

getEndRow

public final int getEndRow()
Gets the index of the last data row. If this value is less than zero, all rows following the start row will be included.

Returns:
the zero-based row index.

setEndRow

public final void setEndRow(int endRow)
Sets the index of the last data row. If this value is less than zero, all rows following the start row will be included.

Parameters:
endRow - the zero-based row index.

getStartColumn

public final int getStartColumn()
Gets the index of the first data column.

Returns:
the zero-based column index.

setStartColumn

public final void setStartColumn(int startColumn)
Sets the index of the first data column.

Parameters:
startColumn - the zero-based column index.

getEndColumn

public final int getEndColumn()
Gets the index of the last data column. If this value is less than zero, all columns following the start column will be included.

Returns:
the zero-based row index.

setEndColumn

public final void setEndColumn(int endColumn)
Sets the index of the last data column. If this value is less than zero, all columns following the start column will be included.

Parameters:
endColumn - the zero-based row index.

parseXML

public void parseXML(Element tag)
              throws Exception

Specified by:
parseXML in interface inetsoft.util.XMLSerializable
Throws:
Exception

writeXML

public void writeXML(PrintWriter writer)

Specified by:
writeXML in interface inetsoft.util.XMLSerializable

getRowLabel

public static String getRowLabel(int index)
Gets the Excel row label for the specified row index.

Parameters:
index - the row index.
Returns:
the row label.

getRowIndex

public static int getRowIndex(String label)
Gets the row index for the specified Excel row label.

Parameters:
label - the row label.
Returns:
the row index.

getColumnLabel

public static String getColumnLabel(int index)
Gets the Excel column label for the specified column index.

Parameters:
index - the column index.
Returns:
the column label.

getColumnIndex

public static int getColumnIndex(String label)
Gets the column index for the specified Excel column label.

Parameters:
label - the column label.
Returns:
the column index.

Copyright © 1996-2014 InetSoft Technology Corp. All Rights Reserved.