Overview  Package   Class  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

com.moyosoft.connector.ms.excel
Class Range

java.lang.Object
  |
  +--com.moyosoft.connector.ms.excel.Range
public class Range
extends java.lang.Object

Field Summary
static int VALUE_TYPE_BOOLEAN
           
static int VALUE_TYPE_CURRENCY
           
static int VALUE_TYPE_DATE
           
static int VALUE_TYPE_NUMBER
           
static int VALUE_TYPE_TEXT
           
 
Constructor Summary
Range(Dispatch dispatch)
           
 
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, int colorIndex)
           
 void borderAround(LineStyle lineStyle, BorderWeight weight, int 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()
           
 int getValueType()
           
 int getValueVariantType()
           
 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 copies, boolean preview, boolean collate)
           
 void printOut(int copies, boolean preview, java.lang.String activePrinter, boolean printToFile, boolean collate, java.lang.String printToFilename)
           
 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 setFormulaR1C1Local(java.lang.String value)
           
 void setHidden(boolean value)
           
 void setHorizontalAlignment(HAlign value)
           
 void setID(java.lang.String value)
           
 void setIndentLevel(int value)
           
 void setItem(int rowIndex, int columnIndex, Range item)
           
 void setItem(int rowIndex, Range item)
           
 void setItem(int rowIndex, java.lang.String column, Range item)
           
 void setLocked(boolean value)
           
 void setMergeCells(boolean value)
           
 void setName(java.lang.String value)
           
 void setNoteText(java.lang.String text)
           
 void setNumberFormat(java.lang.String value)
           
 void setNumberFormatLocal(java.lang.String value)
           
 void setOrientation(Orientation value)
           
 void setOrientationValue(int orientationInDegrees)
           
 void setOutlineLevel(int value)
           
 void setPageBreak(int value)
           
 void setPhonetic()
           
 void setReadingOrder(int value)
           
 void setRowHeight(int value)
           
 void setShowDetail(boolean value)
           
 void setShrinkToFit(boolean value)
           
 void setUseStandardHeight(boolean value)
           
 void setUseStandardWidth(boolean value)
           
 void setValue(boolean value)
           
 void setValue(java.util.Date value)
           
 void setValue(double value)
           
 void setValue(int value)
           
 void setValue(java.lang.String value)
           
 void setValues(boolean[] values)
           
 void setValues(boolean[][] values)
           
 void setValues(byte[] values)
           
 void setValues(byte[][] values)
           
 void setValues(java.util.Date[] values)
           
 void setValues(double[] values)
           
 void setValues(double[][] values)
           
 void setValues(int[] values)
           
 void setValues(int[][] values)
           
 void setValues(long[] values)
           
 void setValues(long[][] values)
           
 void setValues(java.lang.String[] values)
           
 void setValues(java.lang.String[][] values)
           
 void setVerticalAlignment(VAlign value)
           
 void setWrapText(boolean value)
           
 void show()
           
 void showDependents()
           
 void showDependents(boolean remove)
           
 void showErrors()
           
 void showPrecedents()
           
 void showPrecedents(boolean remove)
           
 void sort()
           
 void sort(java.lang.String key1)
           
 void sort(java.lang.String key1, SortOrder order1)
           
 void sort(java.lang.String key1, SortOrder order1, java.lang.String key2)
           
 void sort(java.lang.String key1, SortOrder order1, java.lang.String key2, SortOrder order2)
           
 void sortSpecial()
           
 void sortSpecial(SortMethod sortMethod)
           
 void sortSpecial(SortMethod sortMethod, java.lang.String key1)
           
 void sortSpecial(SortMethod sortMethod, java.lang.String key1, SortOrder order1)
           
 void sortSpecial(SortMethod sortMethod, java.lang.String key1, SortOrder order1, java.lang.String key2, SortOrder order2)
           
 Range specialCells(CellType type)
           
 Range specialCells(CellType type, SpecialCellsValue value)
           
 void table(Range rowInputCell)
           
 void table(Range rowInputCell, Range columnInputCell)
           
 void ungroup()
           
 void unMerge()
           
 boolean useStandardHeight()
           
 boolean useStandardWidth()
           
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

VALUE_TYPE_NUMBER

public static final int VALUE_TYPE_NUMBER
See Also:
Constant Field Values

VALUE_TYPE_TEXT

public static final int VALUE_TYPE_TEXT
See Also:
Constant Field Values

VALUE_TYPE_CURRENCY

public static final int VALUE_TYPE_CURRENCY
See Also:
Constant Field Values

VALUE_TYPE_BOOLEAN

public static final int VALUE_TYPE_BOOLEAN
See Also:
Constant Field Values

VALUE_TYPE_DATE

public static final int VALUE_TYPE_DATE
See Also:
Constant Field Values
Constructor Detail

Range

public Range(Dispatch dispatch)
Method Detail

getDispatch

public Dispatch getDispatch()

activate

public void activate()

getAddIndent

public boolean getAddIndent()

setAddIndent

public void setAddIndent(boolean value)

getAddress

public java.lang.String getAddress()

getAddress

public java.lang.String getAddress(boolean rowAbsolute)

getAddress

public java.lang.String getAddress(boolean rowAbsolute,
                                   boolean columnAbsolute)

getAddress

public java.lang.String getAddress(boolean rowAbsolute,
                                   boolean columnAbsolute,
                                   ReferenceStyle referenceStyle)

getAddress

public java.lang.String getAddress(boolean rowAbsolute,
                                   boolean columnAbsolute,
                                   ReferenceStyle referenceStyle,
                                   boolean external)

getAddress

public java.lang.String getAddress(boolean rowAbsolute,
                                   boolean columnAbsolute,
                                   ReferenceStyle referenceStyle,
                                   boolean external,
                                   Range relativeTo)

getAddressLocal

public java.lang.String getAddressLocal()

getAddressLocal

public java.lang.String getAddressLocal(boolean rowAbsolute)

getAddressLocal

public java.lang.String getAddressLocal(boolean rowAbsolute,
                                        boolean columnAbsolute)

getAddressLocal

public java.lang.String getAddressLocal(boolean rowAbsolute,
                                        boolean columnAbsolute,
                                        ReferenceStyle referenceStyle)

getAddressLocal

public java.lang.String getAddressLocal(boolean rowAbsolute,
                                        boolean columnAbsolute,
                                        ReferenceStyle referenceStyle,
                                        boolean external)

getAddressLocal

public java.lang.String getAddressLocal(boolean rowAbsolute,
                                        boolean columnAbsolute,
                                        ReferenceStyle referenceStyle,
                                        boolean external,
                                        Range relativeTo)

advancedFilter

public void advancedFilter(FilterAction action)

advancedFilter

public void advancedFilter(FilterAction action,
                           Range criteriaRange)

advancedFilter

public void advancedFilter(FilterAction action,
                           Range criteriaRange,
                           Range copyToRange)

advancedFilter

public void advancedFilter(FilterAction action,
                           Range criteriaRange,
                           Range copyToRange,
                           boolean unique)

applyNames

public void applyNames(java.lang.String[] names)

applyNames

public void applyNames(java.lang.String[] names,
                       boolean ignoreRelativeAbsolute)

applyNames

public void applyNames(java.lang.String[] names,
                       boolean ignoreRelativeAbsolute,
                       boolean useRowColumnNames)

applyNames

public void applyNames(java.lang.String[] names,
                       boolean ignoreRelativeAbsolute,
                       boolean useRowColumnNames,
                       boolean omitColumn)

applyNames

public void applyNames(java.lang.String[] names,
                       boolean ignoreRelativeAbsolute,
                       boolean useRowColumnNames,
                       boolean omitColumn,
                       boolean omitRow)

applyNames

public void applyNames(java.lang.String[] names,
                       boolean ignoreRelativeAbsolute,
                       boolean useRowColumnNames,
                       boolean omitColumn,
                       boolean omitRow,
                       ApplyNamesOrder order)

applyNames

public void applyNames(java.lang.String[] names,
                       boolean ignoreRelativeAbsolute,
                       boolean useRowColumnNames,
                       boolean omitColumn,
                       boolean omitRow,
                       ApplyNamesOrder order,
                       boolean appendLast)

applyOutlineStyles

public void applyOutlineStyles()

getAreas

public Areas getAreas()

autoComplete

public java.lang.String autoComplete(java.lang.String value)

autoFill

public void autoFill(Range destination)

autoFill

public void autoFill(Range destination,
                     AutoFillType type)

autoFilter

public void autoFilter(int field)

autoFilter

public void autoFilter(int field,
                       java.lang.String criteria1)

autoFilter

public void autoFilter(int field,
                       java.lang.String criteria1,
                       AutoFilterOperator operator)

autoFilter

public void autoFilter(int field,
                       java.lang.String criteria1,
                       AutoFilterOperator operator,
                       java.lang.String criteria2)

autoFilter

public void autoFilter(int field,
                       java.lang.String criteria1,
                       AutoFilterOperator operator,
                       java.lang.String criteria2,
                       boolean visibleDropDown)

autoFit

public void autoFit()

autoFormat

public void autoFormat(RangeAutoFormat format)

autoFormat

public void autoFormat(RangeAutoFormat format,
                       boolean number)

autoFormat

public void autoFormat(RangeAutoFormat format,
                       boolean number,
                       boolean font)

autoFormat

public void autoFormat(RangeAutoFormat format,
                       boolean number,
                       boolean font,
                       boolean alignment)

autoFormat

public void autoFormat(RangeAutoFormat format,
                       boolean number,
                       boolean font,
                       boolean alignment,
                       boolean border)

autoFormat

public void autoFormat(RangeAutoFormat format,
                       boolean number,
                       boolean font,
                       boolean alignment,
                       boolean border,
                       boolean pattern)

autoFormat

public void autoFormat(RangeAutoFormat format,
                       boolean number,
                       boolean font,
                       boolean alignment,
                       boolean border,
                       boolean pattern,
                       boolean width)

autoOutline

public void autoOutline()

borderAround

public void borderAround(LineStyle lineStyle)

borderAround

public void borderAround(LineStyle lineStyle,
                         BorderWeight weight)

borderAround

public void borderAround(LineStyle lineStyle,
                         BorderWeight weight,
                         int colorIndex)

borderAround

public void borderAround(LineStyle lineStyle,
                         BorderWeight weight,
                         int colorIndex,
                         int color)

getBorders

public Borders getBorders()

calculate

public void calculate()

getCells

public Range getCells()

getCharacters

public Characters getCharacters()

getCharacters

public Characters getCharacters(int start)

getCharacters

public Characters getCharacters(int start,
                                int length)

checkSpelling

public void checkSpelling()

checkSpelling

public void checkSpelling(java.lang.String customDictionary)

checkSpelling

public void checkSpelling(java.lang.String customDictionary,
                          boolean ignoreUppercase)

checkSpelling

public void checkSpelling(java.lang.String customDictionary,
                          boolean ignoreUppercase,
                          boolean alwaysSuggest)

checkSpelling

public void checkSpelling(java.lang.String customDictionary,
                          boolean ignoreUppercase,
                          boolean alwaysSuggest,
                          int spellLang)

clear

public void clear()

clearContents

public void clearContents()

clearFormats

public void clearFormats()

clearNotes

public void clearNotes()

clearOutline

public void clearOutline()

getColumn

public int getColumn()

columnDifferences

public Range columnDifferences(Range comparisonCell)

getColumns

public Range getColumns()

getColumnWidth

public int getColumnWidth()

setColumnWidth

public void setColumnWidth(int value)

consolidate

public void consolidate(java.lang.String[] sources)

consolidate

public void consolidate(java.lang.String[] sources,
                        ConsolidationFunction function)

consolidate

public void consolidate(java.lang.String[] sources,
                        ConsolidationFunction function,
                        boolean topRow)

consolidate

public void consolidate(java.lang.String[] sources,
                        ConsolidationFunction function,
                        boolean topRow,
                        boolean leftColumn)

consolidate

public void consolidate(java.lang.String[] sources,
                        ConsolidationFunction function,
                        boolean topRow,
                        boolean leftColumn,
                        boolean createLinks)

copyToClipboard

public void copyToClipboard()

copy

public void copy(Range destination)

copyPictureToClipboard

public void copyPictureToClipboard()

copyPictureToClipboard

public void copyPictureToClipboard(PictureAppearance appearance)

copyPictureToClipboard

public void copyPictureToClipboard(PictureAppearance appearance,
                                   CopyPictureFormat format)

getCount

public int getCount()

createNames

public void createNames()

createNames

public void createNames(boolean top)

createNames

public void createNames(boolean top,
                        boolean left)

createNames

public void createNames(boolean top,
                        boolean left,
                        boolean bottom)

createNames

public void createNames(boolean top,
                        boolean left,
                        boolean bottom,
                        boolean right)

getCurrentArray

public Range getCurrentArray()

getCurrentRegion

public Range getCurrentRegion()

cut

public void cut()

cut

public void cut(Range destination)

dataSeries

public void dataSeries()

dataSeries

public void dataSeries(RowCol rowcol)

dataSeries

public void dataSeries(RowCol rowcol,
                       DataSeriesType type)

dataSeries

public void dataSeries(RowCol rowcol,
                       DataSeriesType type,
                       DataSeriesDate date)

dataSeries

public void dataSeries(RowCol rowcol,
                       DataSeriesType type,
                       DataSeriesDate date,
                       int step)

dataSeries

public void dataSeries(RowCol rowcol,
                       DataSeriesType type,
                       DataSeriesDate date,
                       int step,
                       int stop)

dataSeries

public void dataSeries(RowCol rowcol,
                       DataSeriesType type,
                       DataSeriesDate date,
                       int step,
                       int stop,
                       boolean trend)

delete

public void delete()

delete

public void delete(DeleteShiftDirection shift)

getDependents

public Range getDependents()

dialogBox

public int dialogBox()

getDirectDependents

public Range getDirectDependents()

getDirectPrecedents

public Range getDirectPrecedents()

getEnd

public Range getEnd(Direction value)

getEntireColumn

public Range getEntireColumn()

getEntireRow

public Range getEntireRow()

fillDown

public void fillDown()

fillLeft

public void fillLeft()

fillRight

public void fillRight()

fillUp

public void fillUp()

find

public Range find(java.lang.String what)

find

public Range find(java.lang.String what,
                  Range after)

find

public Range find(java.lang.String what,
                  Range after,
                  boolean matchCase)

find

public Range find(int what)

find

public Range find(int what,
                  Range after)

find

public Range find(int what,
                  Range after,
                  boolean matchCase)

find

public Range find(double what)

find

public Range find(double what,
                  Range after)

find

public Range find(double what,
                  Range after,
                  boolean matchCase)

find

public Range find(java.util.Date what)

find

public Range find(java.util.Date what,
                  Range after)

find

public Range find(java.util.Date what,
                  Range after,
                  boolean matchCase)

findNext

public Range findNext()

findNext

public Range findNext(Range after)

findPrevious

public Range findPrevious()

findPrevious

public Range findPrevious(Range after)

getFont

public Font getFont()

getFormula

public java.lang.String getFormula()

setFormula

public void setFormula(java.lang.String formula)

getFormulaArray

public java.lang.String[] getFormulaArray()

setFormulaArray

public void setFormulaArray(java.lang.String value)

getFormulaLabel

public FormulaLabel getFormulaLabel()

setFormulaLabel

public void setFormulaLabel(FormulaLabel value)

getFormulaHiddenWhenProtected

public boolean getFormulaHiddenWhenProtected()

setFormulaHiddenWhenProtected

public void setFormulaHiddenWhenProtected(boolean value)

getFormulaLocal

public java.lang.String getFormulaLocal()

setFormulaLocal

public void setFormulaLocal(java.lang.String value)

getFormulaR1C1

public java.lang.String getFormulaR1C1()

setFormulaR1C1

public void setFormulaR1C1(java.lang.String value)

getFormulaR1C1Local

public java.lang.String getFormulaR1C1Local()

setFormulaR1C1Local

public void setFormulaR1C1Local(java.lang.String value)

goalSeek

public boolean goalSeek(int goal,
                        Range changingCell)

hasArray

public boolean hasArray()

hasFormula

public boolean hasFormula()

getHeight

public int getHeight()

getHidden

public boolean getHidden()

setHidden

public void setHidden(boolean value)

getHorizontalAlignment

public HAlign getHorizontalAlignment()

setHorizontalAlignment

public void setHorizontalAlignment(HAlign value)

getIndentLevel

public int getIndentLevel()

setIndentLevel

public void setIndentLevel(int value)

insertIndent

public void insertIndent(int value)

insert

public void insert(InsertShiftDirection shift)

getInterior

public Interior getInterior()

getItem

public Range getItem(int rowIndex)

getItem

public Range getItem(int rowIndex,
                     int columnIndex)

getItem

public Range getItem(int rowIndex,
                     java.lang.String column)

setItem

public void setItem(int rowIndex,
                    Range item)

setItem

public void setItem(int rowIndex,
                    int columnIndex,
                    Range item)

setItem

public void setItem(int rowIndex,
                    java.lang.String column,
                    Range item)

justify

public void justify()

getLeft

public int getLeft()

getListHeaderRows

public int getListHeaderRows()

listNames

public void listNames()

getLocationInTable

public LocationInTable getLocationInTable()

getLocked

public boolean getLocked()

setLocked

public void setLocked(boolean value)

merge

public void merge()

merge

public void merge(boolean across)

unMerge

public void unMerge()

getMergeArea

public Range getMergeArea()

getMergeCells

public boolean getMergeCells()

setMergeCells

public void setMergeCells(boolean value)

getName

public java.lang.String getName()

setName

public void setName(java.lang.String value)

navigateArrow

public void navigateArrow()

navigateArrow

public void navigateArrow(boolean towardPrecedent)

navigateArrow

public void navigateArrow(boolean towardPrecedent,
                          int arrowNumber)

navigateArrow

public void navigateArrow(boolean towardPrecedent,
                          int arrowNumber,
                          int linkNumber)

getNext

public Range getNext()

getNoteText

public java.lang.String getNoteText()

setNoteText

public void setNoteText(java.lang.String text)

getNumberFormat

public java.lang.String getNumberFormat()

setNumberFormat

public void setNumberFormat(java.lang.String value)

getNumberFormatLocal

public java.lang.String getNumberFormatLocal()

setNumberFormatLocal

public void setNumberFormatLocal(java.lang.String value)

getOffset

public Range getOffset()

getOffset

public Range getOffset(int rowOffset)

getOffset

public Range getOffset(int rowOffset,
                       int columnOffset)

getOrientation

public Orientation getOrientation()

setOrientation

public void setOrientation(Orientation value)

getOrientationValue

public int getOrientationValue()

setOrientationValue

public void setOrientationValue(int orientationInDegrees)

getOutlineLevel

public int getOutlineLevel()

setOutlineLevel

public void setOutlineLevel(int value)

getPageBreak

public int getPageBreak()

setPageBreak

public void setPageBreak(int value)

parse

public void parse()

parse

public void parse(java.lang.String parseLine)

parse

public void parse(java.lang.String parseLine,
                  Range destination)

getPrecedents

public Range getPrecedents()

getPrefixCharacter

public java.lang.String getPrefixCharacter()

getPrevious

public Range getPrevious()

printPreview

public void printPreview()

printPreview

public void printPreview(boolean enableChanges)

getQueryTable

public QueryTable getQueryTable()

getRange

public Range getRange(java.lang.String cell1)

getRange

public Range getRange(java.lang.String cell1,
                      java.lang.String cell2)

getRange

public Range getRange(int rowIndex)

getRange

public Range getRange(int rowIndex,
                      int columnIndex)

getRange

public Range getRange(int rowIndex,
                      java.lang.String column)

getRange

public Range getRange(int rowIndex,
                      int columnIndex,
                      int rowCount,
                      int columnCount)

getRange

public Range getRange(int rowIndex,
                      java.lang.String column,
                      int rowCount,
                      int columnCount)

removeSubtotal

public void removeSubtotal()

replace

public boolean replace(java.lang.String what,
                       java.lang.String replacement)

replace

public boolean replace(java.lang.String what,
                       java.lang.String replacement,
                       LookAt lookAt)

replace

public boolean replace(java.lang.String what,
                       java.lang.String replacement,
                       LookAt lookAt,
                       SearchOrder searchOrder)

replace

public boolean replace(java.lang.String what,
                       java.lang.String replacement,
                       LookAt lookAt,
                       SearchOrder searchOrder,
                       boolean matchCase)

replace

public boolean replace(java.lang.String what,
                       java.lang.String replacement,
                       LookAt lookAt,
                       SearchOrder searchOrder,
                       boolean matchCase,
                       boolean matchByte)

replace

public boolean replace(java.lang.String what,
                       java.lang.String replacement,
                       LookAt lookAt,
                       SearchOrder searchOrder,
                       boolean matchCase,
                       boolean matchByte,
                       java.lang.String searchFormat)

replace

public 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)

resizeRows

public Range resizeRows(int rowSize)

resize

public Range resize(int rowSize,
                    int columnSize)

resizeColumns

public Range resizeColumns(int columnSize)

getRow

public int getRow()

rowDifferences

public Range rowDifferences(Range comparisonCell)

getRowHeight

public int getRowHeight()

setRowHeight

public void setRowHeight(int value)

getRows

public Range getRows()

select

public void select()

show

public void show()

showDependents

public void showDependents()

showDependents

public void showDependents(boolean remove)

getShowDetail

public boolean getShowDetail()

setShowDetail

public void setShowDetail(boolean value)

showErrors

public void showErrors()

showPrecedents

public void showPrecedents()

showPrecedents

public void showPrecedents(boolean remove)

getShrinkToFit

public boolean getShrinkToFit()

setShrinkToFit

public void setShrinkToFit(boolean value)

sort

public void sort()

sort

public void sort(java.lang.String key1)

sort

public void sort(java.lang.String key1,
                 SortOrder order1)

sort

public void sort(java.lang.String key1,
                 SortOrder order1,
                 java.lang.String key2)

sort

public void sort(java.lang.String key1,
                 SortOrder order1,
                 java.lang.String key2,
                 SortOrder order2)

sortSpecial

public void sortSpecial()

sortSpecial

public void sortSpecial(SortMethod sortMethod)

sortSpecial

public void sortSpecial(SortMethod sortMethod,
                        java.lang.String key1)

sortSpecial

public void sortSpecial(SortMethod sortMethod,
                        java.lang.String key1,
                        SortOrder order1)

sortSpecial

public void sortSpecial(SortMethod sortMethod,
                        java.lang.String key1,
                        SortOrder order1,
                        java.lang.String key2,
                        SortOrder order2)

specialCells

public Range specialCells(CellType type)

specialCells

public Range specialCells(CellType type,
                          SpecialCellsValue value)

getStyle

public Style getStyle()

isSummary

public boolean isSummary()

table

public void table(Range rowInputCell)

table

public void table(Range rowInputCell,
                  Range columnInputCell)

getText

public java.lang.String getText()

getTop

public int getTop()

ungroup

public void ungroup()

useStandardHeight

public boolean useStandardHeight()

setUseStandardHeight

public void setUseStandardHeight(boolean value)

useStandardWidth

public boolean useStandardWidth()

setUseStandardWidth

public void setUseStandardWidth(boolean value)

getValidation

public Validation getValidation()

getValueVariantType

public int getValueVariantType()

getValueType

public int getValueType()

getValue

public java.lang.String getValue()

getValueAsString

public java.lang.String getValueAsString()

getValueAsInt

public int getValueAsInt()

getValueAsDouble

public double getValueAsDouble()

getValueAsDate

public java.util.Date getValueAsDate()

getValueAsBoolean

public boolean getValueAsBoolean()

setValue

public void setValue(java.lang.String value)

setValue

public void setValue(int value)

setValue

public void setValue(double value)

setValue

public void setValue(java.util.Date value)

setValue

public void setValue(boolean value)

setValues

public void setValues(boolean[] values)

setValues

public void setValues(byte[] values)

setValues

public void setValues(int[] values)

setValues

public void setValues(double[] values)

setValues

public void setValues(long[] values)

setValues

public void setValues(java.util.Date[] values)

setValues

public void setValues(java.lang.String[] values)

setValues

public void setValues(boolean[][] values)

setValues

public void setValues(byte[][] values)

setValues

public void setValues(int[][] values)

setValues

public void setValues(double[][] values)

setValues

public void setValues(long[][] values)

setValues

public void setValues(java.lang.String[][] values)

getValuesAsBooleanArray

public boolean[] getValuesAsBooleanArray()

getValuesAsByteArray

public byte[] getValuesAsByteArray()

getValuesAsIntArray

public int[] getValuesAsIntArray()

getValuesAsDoubleArray

public double[] getValuesAsDoubleArray()

getValuesAsLongArray

public long[] getValuesAsLongArray()

getValuesAsDateArray

public java.util.Date[] getValuesAsDateArray()

getValuesAsStringArray

public java.lang.String[] getValuesAsStringArray()

getValuesAsBoolean2DArray

public boolean[][] getValuesAsBoolean2DArray()

getValuesAsByte2DArray

public byte[][] getValuesAsByte2DArray()

getValuesAsInt2DArray

public int[][] getValuesAsInt2DArray()

getValuesAsDouble2DArray

public double[][] getValuesAsDouble2DArray()

getValuesAsLong2DArray

public long[][] getValuesAsLong2DArray()

getValuesAsString2DArray

public java.lang.String[][] getValuesAsString2DArray()

getVerticalAlignment

public VAlign getVerticalAlignment()

setVerticalAlignment

public void setVerticalAlignment(VAlign value)

getWidth

public int getWidth()

getWorksheet

public Worksheet getWorksheet()

isWrapText

public boolean isWrapText()

setWrapText

public void setWrapText(boolean value)

addComment

public Comment addComment()

addComment

public Comment addComment(java.lang.String text)

getComment

public Comment getComment()

clearComments

public void clearComments()

getPhonetic

public Phonetic getPhonetic()

getFormatConditions

public FormatConditions getFormatConditions()

getReadingOrder

public int getReadingOrder()

setReadingOrder

public void setReadingOrder(int value)

getHyperlinks

public Hyperlinks getHyperlinks()

getPhonetics

public Phonetics getPhonetics()

setPhonetic

public void setPhonetic()

getID

public java.lang.String getID()

setID

public void setID(java.lang.String value)

printOut

public void printOut()

printOut

public void printOut(int fromPage)

printOut

public void printOut(int fromPage,
                     int toPage)

printOut

public void printOut(int fromPage,
                     int toPage,
                     int copiesCount)

printOut

public void printOut(int fromPage,
                     int toPage,
                     int copiesCount,
                     boolean preview)

printOut

public void printOut(int fromPage,
                     int toPage,
                     int copiesCount,
                     boolean preview,
                     java.lang.String activePrinter)

printOut

public void printOut(int fromPage,
                     int toPage,
                     int copiesCount,
                     boolean preview,
                     java.lang.String activePrinter,
                     boolean printToFile)

printOut

public void printOut(int fromPage,
                     int toPage,
                     int copiesCount,
                     boolean preview,
                     java.lang.String activePrinter,
                     boolean printToFile,
                     boolean collate)

printOut

public void printOut(int fromPage,
                     int toPage,
                     int copiesCount,
                     boolean preview,
                     java.lang.String activePrinter,
                     boolean printToFile,
                     boolean collate,
                     java.lang.String printToFileName)

printOut

public void printOut(int copies,
                     boolean preview,
                     boolean collate)

printOut

public void printOut(int copies,
                     boolean preview,
                     java.lang.String activePrinter,
                     boolean printToFile,
                     boolean collate,
                     java.lang.String printToFilename)

dirty

public void dirty()

getErrors

public Errors getErrors()

getSmartTags

public SmartTags getSmartTags()

pasteSpecial

public void pasteSpecial()

pasteSpecial

public void pasteSpecial(PasteType paste)

pasteSpecial

public void pasteSpecial(PasteType paste,
                         PasteSpecialOperation operation)

pasteSpecial

public void pasteSpecial(PasteType paste,
                         PasteSpecialOperation operation,
                         boolean skipBlanks)

pasteSpecial

public void pasteSpecial(PasteType paste,
                         PasteSpecialOperation operation,
                         boolean skipBlanks,
                         boolean transpose)

isAllowEdit

public boolean isAllowEdit()

getListObject

public ListObject getListObject()

getXPath

public XPath getXPath()
Overview  Package   Class  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD