cellrange-ag凯发旗舰厅

overview  package   class  tree  deprecated  index  help 
 prev class   next class frames    no frames    
summary: nested | field | constr | method detail: field | constr | method

com.spire.xls
class cellrange

java.lang.object
  extended by com.spire.xls.core.spreadsheet.xlsobject
      extended by com.spire.xls.core.spreadsheet.xlsrange
          extended by com.spire.xls.cellrange
all implemented interfaces:
icombinedrange, ixlsrange, java.lang.iterable
public class cellrange
extends xlsrange

represents the cell range.

constructor summary
cellrange(java.lang.object parent)
           
cellrange(java.lang.object parent, int firstcol, int firstrow, int lastcol, int lastrow)
           
 
method summary
 cellrange activate()
          active single cell in the worksheet.
 excelcomment addcomment()
          adds a comment to the range.
 void addcomment(excelcomment comment)
          adds a comment to the range.
 cellrange copy(cellrange destrange)
          copies the range to the specified range.
 cellrange copy(cellrange destrange, boolean updatereference)
          copies the range to the specified range.
 cellrange copy(cellrange destrange, boolean updatereference, boolean copystyles)
          copies the range to the specified range.
 cellrange copy(cellrange destrange, java.util.enumset<copyrangeoptions> copyoptions)
          copies the range to the specified range.
 cellrange deepclone(java.lang.object parent, java.util.hashmap rangenames, workbook book)
          clones current ixlsrange.
 cellrange[] findallbool(boolean boolvalue)
          finds the cell with the input bool.
 cellrange[] findalldate(java.util.date datevalue)
          finds the cell with the input datetime.
 cellrange[] findallnumber(double doublevalue, boolean formulavalue)
          finds the cell with the input double.
 cellrange[] findallstring(java.lang.string stringvalue, boolean formula, boolean formulavalue)
          finds the cell with the input string.
 cellrange findbool(boolean boolvalue)
          finds the cell with the input bool.
 cellrange finddate(java.util.date datevalue)
          finds the cell with the input datetime.
 cellrange findnumber(double doublevalue, boolean formulavalue)
          finds the cell with the input double.
 cellrange findstring(java.lang.string stringvalue, boolean formula, boolean formulavalue)
          finds the cell with the input string.
 cellrange get(int row, int column)
          gets cell range.
 cellrange get(int row, int column, int lastrow, int lastcolumn)
          gets cell range.
 cellrange get(java.lang.string name)
          gets cell range.
 cellrange get(java.lang.string name, boolean isr1c1notation)
          gets cell range
 borderscollection getborders()
          returns a borders collection that represents the borders of a style or a range of cells (including a range defined as part of a conditional format).
 java.util.arraylist<cellrange> getcelllist()
          returns a range object that represents the cells in the specified range.
 cellstyle getcellstyle()
          returns a style object that represents the style of the specified range
 cellrange[] getcolumns()
          returns a range object that represents the columns in the specified range
 excelcomment getcomment()
          returns a comment object that represents the comment associated with the cell in the upper-left corner of the range.
 cellrange getendcell()
          returns a range object that represents the cell at the end of the region that contains the source range.
 cellrange getentirecolumn()
          returns a range object that represents the entire column (or columns) that contains the specified range.
 cellrange getentirerow()
          returns a range object that represents the entire row (or rows) that contains the specified range.
 cellrange getmergearea()
          returns a range object that represents the merged range containing the specified cell.
 richtext getrichtext()
          returns a rich text string object that represents the rich text style.
 cellrange[] getrows()
          returns the number of the first row of the first area in the range.
 worksheet getworksheet()
          returns a worksheet object that represents the worksheet
 cellrange intersect(cellrange range)
          get intersection range with the specified range.
 cellrange merge(cellrange range)
          creates a merged cell from the specified range object.
 void move(cellrange destrange)
          moves the cells to the specified range.
 void move(cellrange destrange, boolean copystyle, boolean updatereference)
          moves the cells to the specified range.
 void set(int row, int column, cellrange value)
          gets cell range.
 void setdatavalidation(validation datavalidation)
          sets data validation for the range.
 void setstyle(cellstyle value)
          returns a style object that represents the style of the specified range
 
methods inherited from class com.spire.xls.core.spreadsheet.xlsrange
activate, addcombinedrange, addcomment, autofitcolumns, autofitrows, borderaround, borderaround, borderaround, borderaround, borderinside, borderinside, borderinside, borderinside, bordernone, clear, clearall, clearconditionalformats, clearcontents, collapsegroup, converttonumber, deepclone, dispose, expandgroup, freezepanes, getbooleanvalue, getbuiltinstyle, getcellscount, getcellstylename, getcolumn, getcolumncount, getcolumngrouplevel, getcolumnwidth, getconditionalformats, getcount, getdatavalidation, getdatetimevalue, getdisplayedtext, getenvalutedvalue, geterrorvalue, getextendedformatindex, getformula, getformulaarray, getformulaarrayr1c1, getformulaboolvalue, getformuladatetime, getformulaerrorvalue, getformulanumbervalue, getformular1c1, getformulastringvalue, getformulavalue, gethorizontalalignment, gethtmlstring, gethyperlinks, getignoreerroroptions, getindentlevel, getlastcolumn, getlastrow, getnewrangelocation, getnumberformat, getnumbertext, getnumbervalue, getparent, getrangeaddress, getrangeaddresslocal, getrangeglobaladdress, getrangeglobaladdress2007, getrangeglobaladdresswithoutsheetname, getranger1c1address, getranger1c1addresslocal, getrectangles, getrow, getrowcount, getrowgrouplevel, getrowheight, getstyle, gettext, getvalue, getvalue2, getverticalalignment, getworksheetname, groupbycolumns, groupbyrows, hasboolean, hascomment, hasconditionformats, hasdatavalidation, hasdatetime, haserror, hasexternalformula, hasformula, hasformulaarray, hasformulaboolvalue, hasformuladatetime, hasformulaerrorvalue, hasformulanumbervalue, hasformulastringvalue, hasmerged, hasnumber, haspictures, hasrichtext, hasstring, hasstyle, intersect, isallnumber, isblank, isformulahidden, isformulahidden, isgroupedbycolumn, isgroupedbyrow, isinitialized, isstringspreserved, isstringspreserved, iswraptext, iswraptext, iterator, measurestring, merge, merge, merge, partialclear, replace, replace, replace, replace, replace, replace, replace, replace, set, setbooleanvalue, setbuiltinstyle, setcellstylename, setcolumnwidth, setdatavalidation, setdatetimevalue, setdatetimevalue, seterrorvalue, setextendedformatindex, setextendedformatindexs, setformula, setformulaarray, setformulaarrayr1c1, setformulaboolvalue, setformuladatetime, setformulaerrorvalue, setformulanumbervalue, setformular1c1, setformulastringvalue, sethorizontalalignment, sethtmlstring, setignoreerroroptions, setindentlevel, setlastcolumn, setlastrow, setnumberformat, setnumbervalue, setobjectvalue, setrowheight, setrowheight, setstyle, settext, setvalue, setverticalalignment, ungroupbycolumns, ungroupbyrows, unmerge, updaterange
 
methods inherited from interface com.spire.xls.core.icombinedrange
getrectanglescount
 
methods inherited from interface com.spire.xls.core.ixlsrange
expandgroup, getinnerformuladatetime, gettimespanvalue
 
constructor detail

cellrange

public cellrange(java.lang.object parent)

cellrange

public cellrange(java.lang.object parent,
                 int firstcol,
                 int firstrow,
                 int lastcol,
                 int lastrow)
method detail

activate

public cellrange activate()
active single cell in the worksheet.
overrides:
activate in class xlsrange
returns:
cellrange

addcomment

public void addcomment(excelcomment comment)
adds a comment to the range.
parameters:
comment - comment to add.

addcomment

public excelcomment addcomment()
adds a comment to the range.
specified by:
addcomment in interface ixlsrange
overrides:
addcomment in class xlsrange
returns:
created comment or exists one.

deepclone

public cellrange deepclone(java.lang.object parent,
                           java.util.hashmap rangenames,
                           workbook book)
clones current ixlsrange.
parameters:
parent - parent object.
rangenames - new names.
book - parent workbook.
returns:
cloned instance.

move

public void move(cellrange destrange)
moves the cells to the specified range.
parameters:
destrange - destnation range.

move

public void move(cellrange destrange,
                 boolean copystyle,
                 boolean updatereference)
moves the cells to the specified range.
parameters:
destrange - destination range.
copystyle - copy style
updatereference - indicates whether to update reference range.

copy

public cellrange copy(cellrange destrange)
copies the range to the specified range.
parameters:
destrange - destination range
returns:
destination range

copy

public cellrange copy(cellrange destrange,
                      boolean updatereference)
copies the range to the specified range.
parameters:
destrange - destination range.
updatereference - indicates whether to update reference cells.
returns:
destination range

copy

public cellrange copy(cellrange destrange,
                      boolean updatereference,
                      boolean copystyles)
copies the range to the specified range.
parameters:
destrange - destination range.
updatereference - indicates whether to update reference cells
copystyles - indicates whether to copy styles.
returns:
destination range

copy

public cellrange copy(cellrange destrange,
                      java.util.enumset<copyrangeoptions> copyoptions)
copies the range to the specified range.
parameters:
destrange - destination range.
copyoptions - copy options.
returns:

findallnumber

public cellrange[] findallnumber(double doublevalue,
                                 boolean formulavalue)
finds the cell with the input double.
parameters:
doublevalue - double value to search for
formulavalue - indicates whether to find formula value
returns:
found ranges

findallstring

public cellrange[] findallstring(java.lang.string stringvalue,
                                 boolean formula,
                                 boolean formulavalue)
finds the cell with the input string.
parameters:
stringvalue - string value to search for
formula - indicates whether include formula
formulavalue - indicates whether include formula value
returns:
found ranges

findalldate

public cellrange[] findalldate(java.util.date datevalue)
finds the cell with the input datetime.
parameters:
datevalue - date time value to search for
returns:
found ranges

findallbool

public cellrange[] findallbool(boolean boolvalue)
finds the cell with the input bool.
parameters:
boolvalue - bool value to search for
returns:
found ranges

findbool

public cellrange findbool(boolean boolvalue)
finds the cell with the input bool.
parameters:
boolvalue - bool value to search for
returns:
found range

findnumber

public cellrange findnumber(double doublevalue,
                            boolean formulavalue)
finds the cell with the input double.
parameters:
doublevalue - double value to search for
formulavalue - indicates whether includes formula value to search for
returns:
found range

findstring

public cellrange findstring(java.lang.string stringvalue,
                            boolean formula,
                            boolean formulavalue)
finds the cell with the input string.
parameters:
stringvalue - string value to search for
formula - indicates whether includes formula to search for
formulavalue - indicates whether includes formula value to search for
returns:
found range

finddate

public cellrange finddate(java.util.date datevalue)
finds the cell with the input datetime.
parameters:
datevalue - datetime value to search for
returns:
found range

intersect

public cellrange intersect(cellrange range)
get intersection range with the specified range.
parameters:
range - range which to intersect.
returns:
range intersection.

merge

public cellrange merge(cellrange range)
creates a merged cell from the specified range object.
parameters:
range - the range to merge with.
returns:
merged ranges.

setdatavalidation

public void setdatavalidation(validation datavalidation)
sets data validation for the range.
parameters:
datavalidation - data validation to set.

getborders

public borderscollection getborders()
returns a borders collection that represents the borders of a style or a range of cells (including a range defined as part of a conditional format).
specified by:
getborders in interface ixlsrange
overrides:
getborders in class xlsrange
returns:

getcellstyle

public cellstyle getcellstyle()
returns a style object that represents the style of the specified range
returns:
cell style

setstyle

public void setstyle(cellstyle value)
returns a style object that represents the style of the specified range

getcelllist

public java.util.arraylist<cellrange> getcelllist()
returns a range object that represents the cells in the specified range.
specified by:
getcelllist in interface ixlsrange
overrides:
getcelllist in class xlsrange
returns:

getcolumns

public cellrange[] getcolumns()
returns a range object that represents the columns in the specified range
specified by:
getcolumns in interface ixlsrange
overrides:
getcolumns in class xlsrange
returns:

getrows

public cellrange[] getrows()
returns the number of the first row of the first area in the range.
specified by:
getrows in interface ixlsrange
overrides:
getrows in class xlsrange
returns:
cell range arrays

get

public cellrange get(int row,
                     int column)
gets cell range. row and column indexes are one-based.
specified by:
get in interface ixlsrange
overrides:
get in class xlsrange
parameters:
row -
column -
returns:
cell range

set

public void set(int row,
                int column,
                cellrange value)
gets cell range. row and column indexes are one-based.
parameters:
row -
column -

get

public cellrange get(int row,
                     int column,
                     int lastrow,
                     int lastcolumn)
gets cell range. row and column indexes are one-based.
specified by:
get in interface ixlsrange
overrides:
get in class xlsrange
parameters:
row -
column -
lastrow -
lastcolumn -
returns:

get

public cellrange get(java.lang.string name)
gets cell range.
specified by:
get in interface ixlsrange
overrides:
get in class xlsrange
parameters:
name -
returns:

get

public cellrange get(java.lang.string name,
                     boolean isr1c1notation)
gets cell range
specified by:
get in interface ixlsrange
overrides:
get in class xlsrange
parameters:
name -
isr1c1notation -
returns:

getcomment

public excelcomment getcomment()
returns a comment object that represents the comment associated with the cell in the upper-left corner of the range.
specified by:
getcomment in interface ixlsrange
overrides:
getcomment in class xlsrange
returns:
excel comment

getworksheet

public worksheet getworksheet()
returns a worksheet object that represents the worksheet
specified by:
getworksheet in interface ixlsrange
overrides:
getworksheet in class xlsrange
returns:
containing the specified range.

getrichtext

public richtext getrichtext()
returns a rich text string object that represents the rich text style.
specified by:
getrichtext in interface ixlsrange
overrides:
getrichtext in class xlsrange
returns:

getentirecolumn

public cellrange getentirecolumn()
returns a range object that represents the entire column (or columns) that contains the specified range.
specified by:
getentirecolumn in interface ixlsrange
overrides:
getentirecolumn in class xlsrange
returns:

getendcell

public cellrange getendcell()
returns a range object that represents the cell at the end of the region that contains the source range.
specified by:
getendcell in interface ixlsrange
overrides:
getendcell in class xlsrange
returns:
cell range

getmergearea

public cellrange getmergearea()
returns a range object that represents the merged range containing the specified cell.
specified by:
getmergearea in interface ixlsrange
overrides:
getmergearea in class xlsrange
returns:
cell range

getentirerow

public cellrange getentirerow()
returns a range object that represents the entire row (or rows) that contains the specified range.
specified by:
getentirerow in interface ixlsrange
overrides:
getentirerow in class xlsrange
returns:
overview  package   class  tree  deprecated  index  help 
 prev class   next class frames    no frames    
summary: nested | field | constr | method detail: field | constr | method
网站地图