|
Method Summary |
void |
activate()
|
Comment |
addComment()
|
Comment |
addComment(java.lang.String text)
|
void |
advancedFilter(FilterAction action)
|
void |
advancedFilter(FilterAction action,
Range criteriaRange)
|
void |
advancedFilter(FilterAction action,
Range criteriaRange,
Range copyToRange)
|
void |
advancedFilter(FilterAction action,
Range criteriaRange,
Range copyToRange,
boolean unique)
|
void |
applyNames(java.lang.String[] names)
|
void |
applyNames(java.lang.String[] names,
boolean ignoreRelativeAbsolute)
|
void |
applyNames(java.lang.String[] names,
boolean ignoreRelativeAbsolute,
boolean useRowColumnNames)
|
void |
applyNames(java.lang.String[] names,
boolean ignoreRelativeAbsolute,
boolean useRowColumnNames,
boolean omitColumn)
|
void |
applyNames(java.lang.String[] names,
boolean ignoreRelativeAbsolute,
boolean useRowColumnNames,
boolean omitColumn,
boolean omitRow)
|
void |
applyNames(java.lang.String[] names,
boolean ignoreRelativeAbsolute,
boolean useRowColumnNames,
boolean omitColumn,
boolean omitRow,
ApplyNamesOrder order)
|
void |
applyNames(java.lang.String[] names,
boolean ignoreRelativeAbsolute,
boolean useRowColumnNames,
boolean omitColumn,
boolean omitRow,
ApplyNamesOrder order,
boolean appendLast)
|
void |
applyOutlineStyles()
|
java.lang.String |
autoComplete(java.lang.String value)
|
void |
autoFill(Range destination)
|
void |
autoFill(Range destination,
AutoFillType type)
|
void |
autoFilter(int field)
|
void |
autoFilter(int field,
java.lang.String criteria1)
|
void |
autoFilter(int field,
java.lang.String criteria1,
AutoFilterOperator operator)
|
void |
autoFilter(int field,
java.lang.String criteria1,
AutoFilterOperator operator,
java.lang.String criteria2)
|
void |
autoFilter(int field,
java.lang.String criteria1,
AutoFilterOperator operator,
java.lang.String criteria2,
boolean visibleDropDown)
|
void |
autoFit()
|
void |
autoFormat(RangeAutoFormat format)
|
void |
autoFormat(RangeAutoFormat format,
boolean number)
|
void |
autoFormat(RangeAutoFormat format,
boolean number,
boolean font)
|
void |
autoFormat(RangeAutoFormat format,
boolean number,
boolean font,
boolean alignment)
|
void |
autoFormat(RangeAutoFormat format,
boolean number,
boolean font,
boolean alignment,
boolean border)
|
void |
autoFormat(RangeAutoFormat format,
boolean number,
boolean font,
boolean alignment,
boolean border,
boolean pattern)
|
void |
autoFormat(RangeAutoFormat format,
boolean number,
boolean font,
boolean alignment,
boolean border,
boolean pattern,
boolean width)
|
void |
autoOutline()
|
void |
borderAround(LineStyle lineStyle)
|
void |
borderAround(LineStyle lineStyle,
BorderWeight weight)
|
void |
borderAround(LineStyle lineStyle,
BorderWeight weight,
ColorIndex colorIndex)
|
void |
borderAround(LineStyle lineStyle,
BorderWeight weight,
ColorIndex colorIndex,
int color)
|
void |
calculate()
|
void |
checkSpelling()
|
void |
checkSpelling(java.lang.String customDictionary)
|
void |
checkSpelling(java.lang.String customDictionary,
boolean ignoreUppercase)
|
void |
checkSpelling(java.lang.String customDictionary,
boolean ignoreUppercase,
boolean alwaysSuggest)
|
void |
checkSpelling(java.lang.String customDictionary,
boolean ignoreUppercase,
boolean alwaysSuggest,
int spellLang)
|
void |
clear()
|
void |
clearComments()
|
void |
clearContents()
|
void |
clearFormats()
|
void |
clearNotes()
|
void |
clearOutline()
|
Range |
columnDifferences(Range comparisonCell)
|
void |
consolidate(java.lang.String[] sources)
|
void |
consolidate(java.lang.String[] sources,
ConsolidationFunction function)
|
void |
consolidate(java.lang.String[] sources,
ConsolidationFunction function,
boolean topRow)
|
void |
consolidate(java.lang.String[] sources,
ConsolidationFunction function,
boolean topRow,
boolean leftColumn)
|
void |
consolidate(java.lang.String[] sources,
ConsolidationFunction function,
boolean topRow,
boolean leftColumn,
boolean createLinks)
|
void |
copy(Range destination)
|
void |
copyPictureToClipboard()
|
void |
copyPictureToClipboard(PictureAppearance appearance)
|
void |
copyPictureToClipboard(PictureAppearance appearance,
CopyPictureFormat format)
|
void |
copyToClipboard()
|
void |
createNames()
|
void |
createNames(boolean top)
|
void |
createNames(boolean top,
boolean left)
|
void |
createNames(boolean top,
boolean left,
boolean bottom)
|
void |
createNames(boolean top,
boolean left,
boolean bottom,
boolean right)
|
void |
cut()
|
void |
cut(Range destination)
|
void |
dataSeries()
|
void |
dataSeries(RowCol rowcol)
|
void |
dataSeries(RowCol rowcol,
DataSeriesType type)
|
void |
dataSeries(RowCol rowcol,
DataSeriesType type,
DataSeriesDate date)
|
void |
dataSeries(RowCol rowcol,
DataSeriesType type,
DataSeriesDate date,
int step)
|
void |
dataSeries(RowCol rowcol,
DataSeriesType type,
DataSeriesDate date,
int step,
int stop)
|
void |
dataSeries(RowCol rowcol,
DataSeriesType type,
DataSeriesDate date,
int step,
int stop,
boolean trend)
|
void |
delete()
|
void |
delete(DeleteShiftDirection shift)
|
int |
dialogBox()
|
void |
dirty()
|
void |
fillDown()
|
void |
fillLeft()
|
void |
fillRight()
|
void |
fillUp()
|
Range |
find(java.util.Date what)
|
Range |
find(java.util.Date what,
Range after)
|
Range |
find(java.util.Date what,
Range after,
boolean matchCase)
|
Range |
find(double what)
|
Range |
find(double what,
Range after)
|
Range |
find(double what,
Range after,
boolean matchCase)
|
Range |
find(int what)
|
Range |
find(int what,
Range after)
|
Range |
find(int what,
Range after,
boolean matchCase)
|
Range |
find(java.lang.String what)
|
Range |
find(java.lang.String what,
Range after)
|
Range |
find(java.lang.String what,
Range after,
boolean matchCase)
|
Range |
findNext()
|
Range |
findNext(Range after)
|
Range |
findPrevious()
|
Range |
findPrevious(Range after)
|
boolean |
getAddIndent()
|
java.lang.String |
getAddress()
|
java.lang.String |
getAddress(boolean rowAbsolute)
|
java.lang.String |
getAddress(boolean rowAbsolute,
boolean columnAbsolute)
|
java.lang.String |
getAddress(boolean rowAbsolute,
boolean columnAbsolute,
ReferenceStyle referenceStyle)
|
java.lang.String |
getAddress(boolean rowAbsolute,
boolean columnAbsolute,
ReferenceStyle referenceStyle,
boolean external)
|
java.lang.String |
getAddress(boolean rowAbsolute,
boolean columnAbsolute,
ReferenceStyle referenceStyle,
boolean external,
Range relativeTo)
|
java.lang.String |
getAddressLocal()
|
java.lang.String |
getAddressLocal(boolean rowAbsolute)
|
java.lang.String |
getAddressLocal(boolean rowAbsolute,
boolean columnAbsolute)
|
java.lang.String |
getAddressLocal(boolean rowAbsolute,
boolean columnAbsolute,
ReferenceStyle referenceStyle)
|
java.lang.String |
getAddressLocal(boolean rowAbsolute,
boolean columnAbsolute,
ReferenceStyle referenceStyle,
boolean external)
|
java.lang.String |
getAddressLocal(boolean rowAbsolute,
boolean columnAbsolute,
ReferenceStyle referenceStyle,
boolean external,
Range relativeTo)
|
Areas |
getAreas()
|
Borders |
getBorders()
|
Range |
getCells()
|
Characters |
getCharacters()
|
Characters |
getCharacters(int start)
|
Characters |
getCharacters(int start,
int length)
|
int |
getColumn()
|
Range |
getColumns()
|
int |
getColumnWidth()
|
Comment |
getComment()
|
int |
getCount()
|
Range |
getCurrentArray()
|
Range |
getCurrentRegion()
|
Range |
getDependents()
|
Range |
getDirectDependents()
|
Range |
getDirectPrecedents()
|
Dispatch |
getDispatch()
|
Range |
getEnd(Direction value)
|
Range |
getEntireColumn()
|
Range |
getEntireRow()
|
Errors |
getErrors()
|
Font |
getFont()
|
FormatConditions |
getFormatConditions()
|
java.lang.String |
getFormula()
|
java.lang.String[] |
getFormulaArray()
|
boolean |
getFormulaHiddenWhenProtected()
|
FormulaLabel |
getFormulaLabel()
|
java.lang.String |
getFormulaLocal()
|
java.lang.String |
getFormulaR1C1()
|
java.lang.String |
getFormulaR1C1Local()
|
int |
getHeight()
|
boolean |
getHidden()
|
HAlign |
getHorizontalAlignment()
|
Hyperlinks |
getHyperlinks()
|
java.lang.String |
getID()
|
int |
getIndentLevel()
|
Interior |
getInterior()
|
Range |
getItem(int rowIndex)
|
Range |
getItem(int rowIndex,
int columnIndex)
|
Range |
getItem(int rowIndex,
java.lang.String column)
|
int |
getLeft()
|
int |
getListHeaderRows()
|
ListObject |
getListObject()
|
LocationInTable |
getLocationInTable()
|
boolean |
getLocked()
|
Range |
getMergeArea()
|
boolean |
getMergeCells()
|
java.lang.String |
getName()
|
Range |
getNext()
|
java.lang.String |
getNoteText()
|
java.lang.String |
getNumberFormat()
|
java.lang.String |
getNumberFormatLocal()
|
Range |
getOffset()
|
Range |
getOffset(int rowOffset)
|
Range |
getOffset(int rowOffset,
int columnOffset)
|
Orientation |
getOrientation()
|
int |
getOrientationValue()
|
int |
getOutlineLevel()
|
int |
getPageBreak()
|
Phonetic |
getPhonetic()
|
Phonetics |
getPhonetics()
|
Range |
getPrecedents()
|
java.lang.String |
getPrefixCharacter()
|
Range |
getPrevious()
|
QueryTable |
getQueryTable()
|
Range |
getRange(int rowIndex)
|
Range |
getRange(int rowIndex,
int columnIndex)
|
Range |
getRange(int rowIndex,
int columnIndex,
int rowCount,
int columnCount)
|
Range |
getRange(int rowIndex,
java.lang.String column)
|
Range |
getRange(int rowIndex,
java.lang.String column,
int rowCount,
int columnCount)
|
Range |
getRange(java.lang.String cell1)
|
Range |
getRange(java.lang.String cell1,
java.lang.String cell2)
|
int |
getReadingOrder()
|
int |
getRow()
|
int |
getRowHeight()
|
Range |
getRows()
|
boolean |
getShowDetail()
|
boolean |
getShrinkToFit()
|
SmartTags |
getSmartTags()
|
Style |
getStyle()
|
java.lang.String |
getText()
|
int |
getTop()
|
Validation |
getValidation()
|
java.lang.String |
getValue()
|
boolean |
getValueAsBoolean()
|
java.util.Date |
getValueAsDate()
|
double |
getValueAsDouble()
|
int |
getValueAsInt()
|
java.lang.String |
getValueAsString()
|
boolean[][] |
getValuesAsBoolean2DArray()
|
boolean[] |
getValuesAsBooleanArray()
|
byte[][] |
getValuesAsByte2DArray()
|
byte[] |
getValuesAsByteArray()
|
java.util.Date[] |
getValuesAsDateArray()
|
double[][] |
getValuesAsDouble2DArray()
|
double[] |
getValuesAsDoubleArray()
|
int[][] |
getValuesAsInt2DArray()
|
int[] |
getValuesAsIntArray()
|
long[][] |
getValuesAsLong2DArray()
|
long[] |
getValuesAsLongArray()
|
java.lang.String[][] |
getValuesAsString2DArray()
|
java.lang.String[] |
getValuesAsStringArray()
|
VAlign |
getVerticalAlignment()
|
int |
getWidth()
|
Worksheet |
getWorksheet()
|
XPath |
getXPath()
|
boolean |
goalSeek(int goal,
Range changingCell)
|
boolean |
hasArray()
|
boolean |
hasFormula()
|
void |
insert(InsertShiftDirection shift)
|
void |
insertIndent(int value)
|
boolean |
isAllowEdit()
|
boolean |
isSummary()
|
boolean |
isWrapText()
|
void |
justify()
|
void |
listNames()
|
void |
merge()
|
void |
merge(boolean across)
|
void |
navigateArrow()
|
void |
navigateArrow(boolean towardPrecedent)
|
void |
navigateArrow(boolean towardPrecedent,
int arrowNumber)
|
void |
navigateArrow(boolean towardPrecedent,
int arrowNumber,
int linkNumber)
|
void |
parse()
|
void |
parse(java.lang.String parseLine)
|
void |
parse(java.lang.String parseLine,
Range destination)
|
void |
pasteSpecial()
|
void |
pasteSpecial(PasteType paste)
|
void |
pasteSpecial(PasteType paste,
PasteSpecialOperation operation)
|
void |
pasteSpecial(PasteType paste,
PasteSpecialOperation operation,
boolean skipBlanks)
|
void |
pasteSpecial(PasteType paste,
PasteSpecialOperation operation,
boolean skipBlanks,
boolean transpose)
|
void |
printOut()
|
void |
printOut(int fromPage)
|
void |
printOut(int fromPage,
int toPage)
|
void |
printOut(int fromPage,
int toPage,
int copiesCount)
|
void |
printOut(int fromPage,
int toPage,
int copiesCount,
boolean preview)
|
void |
printOut(int fromPage,
int toPage,
int copiesCount,
boolean preview,
java.lang.String activePrinter)
|
void |
printOut(int fromPage,
int toPage,
int copiesCount,
boolean preview,
java.lang.String activePrinter,
boolean printToFile)
|
void |
printOut(int fromPage,
int toPage,
int copiesCount,
boolean preview,
java.lang.String activePrinter,
boolean printToFile,
boolean collate)
|
void |
printOut(int fromPage,
int toPage,
int copiesCount,
boolean preview,
java.lang.String activePrinter,
boolean printToFile,
boolean collate,
java.lang.String printToFileName)
|
void |
printPreview()
|
void |
printPreview(boolean enableChanges)
|
void |
removeSubtotal()
|
boolean |
replace(java.lang.String what,
java.lang.String replacement)
|
boolean |
replace(java.lang.String what,
java.lang.String replacement,
LookAt lookAt)
|
boolean |
replace(java.lang.String what,
java.lang.String replacement,
LookAt lookAt,
SearchOrder searchOrder)
|
boolean |
replace(java.lang.String what,
java.lang.String replacement,
LookAt lookAt,
SearchOrder searchOrder,
boolean matchCase)
|
boolean |
replace(java.lang.String what,
java.lang.String replacement,
LookAt lookAt,
SearchOrder searchOrder,
boolean matchCase,
boolean matchByte)
|
boolean |
replace(java.lang.String what,
java.lang.String replacement,
LookAt lookAt,
SearchOrder searchOrder,
boolean matchCase,
boolean matchByte,
java.lang.String searchFormat)
|
boolean |
replace(java.lang.String what,
java.lang.String replacement,
LookAt lookAt,
SearchOrder searchOrder,
boolean matchCase,
boolean matchByte,
java.lang.String searchFormat,
java.lang.String replaceFormat)
|
Range |
resize(int rowSize,
int columnSize)
|
Range |
resizeColumns(int columnSize)
|
Range |
resizeRows(int rowSize)
|
Range |
rowDifferences(Range comparisonCell)
|
void |
select()
|
void |
setAddIndent(boolean value)
|
void |
setColumnWidth(int value)
|
void |
setFormula(java.lang.String formula)
|
void |
setFormulaArray(java.lang.String value)
|
void |
setFormulaHiddenWhenProtected(boolean value)
|
void |
setFormulaLabel(FormulaLabel value)
|
void |
setFormulaLocal(java.lang.String value)
|
void |
setFormulaR1C1(java.lang.String value)
|
void |
|