xlsrangescollection-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.core.spreadsheet.collections
class xlsrangescollection

java.lang.object
  extended by com.spire.ms.system.collections.collectionbase
      extended by 
          extended by com.spire.xls.core.spreadsheet.collections.xlsrangescollection
all implemented interfaces:
com.spire.ms.system.collections.icollection, com.spire.ms.system.collections.ienumerable, icombinedrange, ixlsrange, ixlsranges, java.lang.iterable
public class xlsrangescollection
extends 
implements ixlsranges, icombinedrange

summary description for rangescollection.

constructor summary
xlsrangescollection(java.lang.object parent)
          creates new instance of rangescollection.
 
method summary
 ixlsrange activate(boolean scroll)
          activages a single cell, scroll to it and activates the respective sheet to select a range of cells, use the select method.
 icommentshape addcomment()
          adds comment to the range.
 void autofitcolumns()
          autofits all columns.
 void autofitrows()
          autofits all rows.
 void borderaround()
          sets around border for current range.
 void borderaround(linestyletype borderline)
          sets around border for current range.
 void borderaround(linestyletype borderline, java.awt.color bordercolor)
          sets around border for current range.
 void borderaround(linestyletype borderline, excelcolors bordercolor)
          sets around border for current range.
 void borderinside()
          sets inside border for current range.
 void borderinside(linestyletype borderline)
          sets inside border for current range.
 void borderinside(linestyletype borderline, java.awt.color bordercolor)
          sets inside border for current range.
 void borderinside(linestyletype borderline, excelcolors bordercolor)
          sets inside border for current range.
 void bordernone()
          sets none border for current range.
 void clearconditionalformats()
          clears conditional formats.
 void collapsegroup(groupbytype groupby)
          collapses current group.
 ixlsrange deepclone(java.lang.object parent, java.util.hashmap hashnewnames, xlsworkbook book)
          clones current ixlsrange.
 void expandgroup(groupbytype groupby)
          expands current group.
 void expandgroup(groupbytype groupby, expandcollapseflags flags)
          expands current group.
 void freezepanes()
          freezes pane at the current range.
 ixlsrange get(int index)
          returns item by index from the collection.
 ixlsrange get(int row, int column)
          gets / sets cell by row and index.
 ixlsrange get(int row, int column, int lastrow, int lastcolumn)
          get cell range.
 ixlsrange get(java.lang.string name)
          get cell range.
 ixlsrange get(java.lang.string name, boolean isr1c1notation)
          gets cell range.
 boolean getbooleanvalue()
          gets / sets boolean value that is contained by this range.
 iborders 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).
 builtinstyles getbuiltinstyle()
          gets/sets built in style.
 int getcellscount()
          number of cells in the range.
 java.lang.string getcellstylename()
          returns name of the style object that represents the style of the specified range.
 int getcolumn()
          returns the number of the first column in the first area in the specified range.
 int getcolumngrouplevel()
          column group level.
 ixlsrange[] getcolumns()
          for a range object, returns an array of range objects that represent the columns in the specified range.
 double getcolumnwidth()
          returns or sets the width of all columns in the specified range.
 icommentshape getcomment()
          comment assigned to the range.
 conditionalformats getconditionalformats()
          collection of conditional formats.
 int getcount()
          returns the number of objects in the collection.
 validation getdatavalidation()
          data validation for the range.
 java.util.date getdatetimevalue()
          gets datetime contained by this cell.
 ixlsrange getendcell()
          returns a range object that represents the cell at the end of the region that contains the source range.
 ixlsrange getentirecolumn()
          returns a range object that represents the entire column (or columns) that contains the specified range.
 ixlsrange getentirerow()
          returns a range object that represents the entire row (or rows) that contains the specified range.
 java.lang.string geterrorvalue()
          gets / sets error value that is contained by this range.
 java.lang.string getformula()
          returns or sets the object's formula in a1-style notation and in the language of the macro.
 java.lang.string getformulaarray()
          represents array-entered formula.
 java.lang.string getformulaarrayr1c1()
          returns or sets the array-entered formula in r1c1-style notation and in the language of the macro.
 boolean getformulaboolvalue()
          returns the calculated value of the formula as a boolean.
 java.util.date getformuladatetime()
          get formula datetime value contained by this cell.
 java.lang.string getformulaerrorvalue()
          returns the calculated value of the formula as a string.
 double getformulanumbervalue()
          gets / sets number value evaluated by formula.
 java.lang.string getformular1c1()
          returns or sets the object's formula in r1c1-style notation and in the language of the macro.
 java.lang.string getformulastringvalue()
          gets / sets string value evaluated by formula.
 horizontalaligntype gethorizontalalignment()
          returns or sets the horizontal alignment for the specified object.
 java.lang.string gethtmlstring()
          gets the html string which contains data and some formattings in this cell.
 ihyperlinks gethyperlinks()
          returns hyperlinks for this ranges collection.
 java.util.enumset<ignoreerrortype> getignoreerroroptions()
          represents ignore error options.
 int getindentlevel()
          returns or sets the indent level for the cell or range.
 int getlastcolumn()
          returns last column of the range.
 int getlastrow()
          returns last row of the range.
 ixlsrange getmergearea()
          returns a range object that represents the merged range containing the specified cell.
 java.lang.string getnewrangelocation(java.util.hashmap names, java.lang.string[] sheetname)
          gets new address of range.
 java.lang.string getnumberformat()
          format of current cell.
 java.lang.string getnumbertext()
          returns cell value after number format application.
 double getnumbervalue()
          gets / sets double value of the range.
 java.lang.string getrangeaddress()
          returns the range reference in the language of the macro.
 java.lang.string getrangeaddresslocal()
          returns the range reference for the specified range in the language of the user.
 java.lang.string getrangeglobaladdress()
          returns the range reference in the language of the macro.
 java.lang.string getrangeglobaladdress2007()
          gets address global in the format required by excel 2007.
 java.lang.string getranger1c1address()
          returns the range reference in the language of the macro using r1c1-style reference.
 java.lang.string getranger1c1addresslocal()
          returns the range reference for the specified range in the language of the user using r1c1 style reference .
 java.awt.rectangle[] getrectangles()
          returns array that contains information about range.
 int getrectanglescount()
          returns number of rectangles returned by getrectangles method.
 irichtextstring getrichtext()
          string with rich text formatting.
 int getrow()
          returns the number of the first row of the first area in the range.
 int getrowgrouplevel()
          row group level.
 double getrowheight()
          returns the height of all the rows in the range specified, measured in points.
 ixlsrange[] getrows()
          for a range object, returns an array of range objects that represent the rows in the specified range.
 istyle getstyle()
          returns a style object that represents the style of the specified range.
 java.lang.string gettext()
          gets / sets string value of the range.
 com.spire.ms.system.timespan gettimespanvalue()
          gets / sets time value of the range.
 java.lang.string getvalue()
          returns or sets the value of the specified range.
 java.lang.object getvalue2()
          returns or sets the cell value.
 verticalaligntype getverticalalignment()
          returns or sets the vertical alignment of the specified object.
 iworksheet getworksheet()
          returns a worksheet object that represents the worksheet containing the specified range.
 java.lang.string getworksheetname()
          gets name of the parent worksheet.
 boolean hasboolean()
          indicates whether range contains bool value.
 boolean hasdatavalidation()
          indicates whether specified range object has data validation.
 boolean hasdatetime()
          indicates whether range contains datetime value.
 boolean haserror()
          indicates whether range contains error value.
 boolean hasexternalformula()
          indicates is current range has external formula.
 boolean hasformula()
          true if all cells in the range contain formulas; false if at least one of the cells in the range doesn't contain a formula.
 boolean hasformulaarray()
          indicates whether range contains array-entered formula.
 boolean hasformulaboolvalue()
          indicates if current range has formula bool value.
 boolean hasformuladatetime()
          indicates if current range has formula value formatted as datetime.
 boolean hasformulaerrorvalue()
          indicates if current range has formula error value.
 boolean hasmerged()
          indicates whether this range is part of merged range.
 boolean hasnumber()
          indicates whether the range contains number.
 boolean hasrichtext()
          indicates whether cell contains formatted rich text string.
 boolean hasstring()
          indicates whether the range contains string.
 boolean hasstyle()
          indicates whether range has default style.
 ixlsrange intersect(ixlsrange range)
          returns intersection of this range with the specified one.
 boolean isblank()
          indicates whether the range is blank.
 boolean isformulahidden()
          true if the formula will be hidden when the worksheet is protected.
 boolean isgroupedbycolumn()
          indicates whether this range is grouped by column.
 boolean isgroupedbyrow()
          indicates whether this range is grouped by row.
 boolean isinitialized()
          indicates whether cell is initialized.
 java.lang.boolean isstringspreserved()
          indicates whether all values in the range are preserved as strings.
 boolean iswraptext()
          true if microsoft excel wraps the text in the object.
 void merge()
          creates a merged cell from the specified range object.
 void merge(boolean clearcells)
          creates a merged cell from the specified range object.
 ixlsrange merge(ixlsrange range)
          returns merge of this range with the specified one.
 void remove(ixlsrange range)
          removes range from the collection.
 void setdatetimevalue(java.util.date data)
          gets datetime contained by this cell.
 void setformuladatetime(java.util.date data)
          set formula datetime value contained by this cell.
 void sethtmlstring(java.lang.string value)
          sets the html string which contains data and some formattings in this cell.
 void unmerge()
          separates a merged area into individual cells.
 
methods inherited from interface com.spire.xls.core.ixlsrange
clear, clearcontents, getcelllist, getenvalutedvalue, getinnerformuladatetime, hasformulanumbervalue, hasformulastringvalue, isstringspreserved, iswraptext, set, setbooleanvalue, setbuiltinstyle, setformulanumbervalue, setformulastringvalue, setignoreerroroptions, setobjectvalue, setvalue, setverticalalignment
 
constructor detail

xlsrangescollection

public xlsrangescollection(java.lang.object parent)
creates new instance of rangescollection.
parameters:
parent - parent object.
method detail

getrangeaddress

public java.lang.string getrangeaddress()
returns the range reference in the language of the macro. read-only string.
specified by:
getrangeaddress in interface ixlsrange

getrangeaddresslocal

public java.lang.string getrangeaddresslocal()
returns the range reference for the specified range in the language of the user. read-only string.
specified by:
getrangeaddresslocal in interface ixlsrange

getrangeglobaladdress

public java.lang.string getrangeglobaladdress()
returns the range reference in the language of the macro. read-only string.
specified by:
getrangeglobaladdress in interface ixlsrange

getranger1c1address

public java.lang.string getranger1c1address()
returns the range reference in the language of the macro using r1c1-style reference. read-only string.
specified by:
getranger1c1address in interface ixlsrange

getranger1c1addresslocal

public java.lang.string getranger1c1addresslocal()
returns the range reference for the specified range in the language of the user using r1c1 style reference . read-only string.
specified by:
getranger1c1addresslocal in interface ixlsrange

getbooleanvalue

public boolean getbooleanvalue()
gets / sets boolean value that is contained by this range.
specified by:
getbooleanvalue in interface ixlsrange

getborders

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

getcolumn

public int getcolumn()
returns the number of the first column in the first area in the specified range. read-only.
specified by:
getcolumn in interface ixlsrange

getcolumngrouplevel

public int getcolumngrouplevel()
column group level. read-only. -1 - not all columns in the range have same group level. 0 - no grouping, 1 - 7 - group level.
specified by:
getcolumngrouplevel in interface ixlsrange

getcolumnwidth

public double getcolumnwidth()
returns or sets the width of all columns in the specified range. read/write double.
specified by:
getcolumnwidth in interface ixlsrange

getcount

public int getcount()
returns the number of objects in the collection. read-only. !!!autoporter warning: namesake explicit interface implementation property that can't be autoported! if you want to autoport it, the explicit property should just call the actual property.
specified by:
getcount in interface ixlsrange

getdatetimevalue

public java.util.date getdatetimevalue()
gets datetime contained by this cell. read-write datetime.
specified by:
getdatetimevalue in interface ixlsrange

setdatetimevalue

public void setdatetimevalue(java.util.date data)
gets datetime contained by this cell. read-write datetime.

getnumbertext

public java.lang.string getnumbertext()
returns cell value after number format application. read-only.
specified by:
getnumbertext in interface ixlsrange

getendcell

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

getentirecolumn

public ixlsrange getentirecolumn()
returns a range object that represents the entire column (or columns) that contains the specified range. read-only.
specified by:
getentirecolumn in interface ixlsrange

getentirerow

public ixlsrange getentirerow()
returns a range object that represents the entire row (or rows) that contains the specified range. read-only.
specified by:
getentirerow in interface ixlsrange

geterrorvalue

public java.lang.string geterrorvalue()
gets / sets error value that is contained by this range.
specified by:
geterrorvalue in interface ixlsrange

getformula

public java.lang.string getformula()
returns or sets the object's formula in a1-style notation and in the language of the macro. read/write variant.
specified by:
getformula in interface ixlsrange

getformular1c1

public java.lang.string getformular1c1()
returns or sets the object's formula in r1c1-style notation and in the language of the macro. read/write variant.
specified by:
getformular1c1 in interface ixlsrange

getformulaarray

public java.lang.string getformulaarray()
represents array-entered formula. visit http: *www.cpearson.com/excel/array.htm for more information.
specified by:
getformulaarray in interface ixlsrange

getformulaarrayr1c1

public java.lang.string getformulaarrayr1c1()
returns or sets the array-entered formula in r1c1-style notation and in the language of the macro. read/write variant.
specified by:
getformulaarrayr1c1 in interface ixlsrange

isformulahidden

public boolean isformulahidden()
true if the formula will be hidden when the worksheet is protected. false if at least part of formula in the range is not hidden.
specified by:
isformulahidden in interface ixlsrange

getformuladatetime

public java.util.date getformuladatetime()
get formula datetime value contained by this cell. datetime.minvalue if not all cells of the range have same datetime value.

setformuladatetime

public void setformuladatetime(java.util.date data)
set formula datetime value contained by this cell. datetime.minvalue if not all cells of the range have same datetime value.

hasdatavalidation

public boolean hasdatavalidation()
indicates whether specified range object has data validation. if range is not single cell, then returns true only if all cells have data validation. read-only.
specified by:
hasdatavalidation in interface ixlsrange

hasboolean

public boolean hasboolean()
indicates whether range contains bool value. read-only.
specified by:
hasboolean in interface ixlsrange

hasdatetime

public boolean hasdatetime()
indicates whether range contains datetime value. read-only.
specified by:
hasdatetime in interface ixlsrange

hasformulaboolvalue

public boolean hasformulaboolvalue()
indicates if current range has formula bool value. read only.
specified by:
hasformulaboolvalue in interface ixlsrange

hasformulaerrorvalue

public boolean hasformulaerrorvalue()
indicates if current range has formula error value. read only.
specified by:
hasformulaerrorvalue in interface ixlsrange

hasformuladatetime

public boolean hasformuladatetime()
indicates if current range has formula value formatted as datetime. read-only.
specified by:
hasformuladatetime in interface ixlsrange

hasformula

public boolean hasformula()
true if all cells in the range contain formulas; false if at least one of the cells in the range doesn't contain a formula. read-only boolean.
specified by:
hasformula in interface ixlsrange

hasformulaarray

public boolean hasformulaarray()
indicates whether range contains array-entered formula. read-only.
specified by:
hasformulaarray in interface ixlsrange

hasnumber

public boolean hasnumber()
indicates whether the range contains number. read-only.
specified by:
hasnumber in interface ixlsrange

hasrichtext

public boolean hasrichtext()
indicates whether cell contains formatted rich text string.
specified by:
hasrichtext in interface ixlsrange

hasstring

public boolean hasstring()
indicates whether the range contains string. read-only.
specified by:
hasstring in interface ixlsrange

hasstyle

public boolean hasstyle()
indicates whether range has default style. false means default style. read-only.
specified by:
hasstyle in interface ixlsrange

gethorizontalalignment

public horizontalaligntype gethorizontalalignment()
returns or sets the horizontal alignment for the specified object. read/write horizontalaligntype.
specified by:
gethorizontalalignment in interface ixlsrange

gethyperlinks

public ihyperlinks gethyperlinks()
returns hyperlinks for this ranges collection.

getindentlevel

public int getindentlevel()
returns or sets the indent level for the cell or range. can be an integer from 0 to 15. read/write integer.
specified by:
getindentlevel in interface ixlsrange

isblank

public boolean isblank()
indicates whether the range is blank. read-only.
specified by:
isblank in interface ixlsrange

haserror

public boolean haserror()
indicates whether range contains error value.
specified by:
haserror in interface ixlsrange

isgroupedbycolumn

public boolean isgroupedbycolumn()
indicates whether this range is grouped by column. read-only.
specified by:
isgroupedbycolumn in interface ixlsrange

isgroupedbyrow

public boolean isgroupedbyrow()
indicates whether this range is grouped by row. read-only.
specified by:
isgroupedbyrow in interface ixlsrange

isinitialized

public boolean isinitialized()
indicates whether cell is initialized. read-only.
specified by:
isinitialized in interface ixlsrange

getlastcolumn

public int getlastcolumn()
returns last column of the range. read-only.
specified by:
getlastcolumn in interface ixlsrange

getlastrow

public int getlastrow()
returns last row of the range. read-only.
specified by:
getlastrow in interface ixlsrange

getnumbervalue

public double getnumbervalue()
gets / sets double value of the range.
specified by:
getnumbervalue in interface ixlsrange

getnumberformat

public java.lang.string getnumberformat()
format of current cell. analog of style.numberformat property.
specified by:
getnumberformat in interface ixlsrange

getrow

public int getrow()
returns the number of the first row of the first area in the range. read-only long.
specified by:
getrow in interface ixlsrange

getrowgrouplevel

public int getrowgrouplevel()
row group level. read-only. -1 - not all rows in the range have same group level. 0 - no grouping, 1 - 7 - group level.
specified by:
getrowgrouplevel in interface ixlsrange

getrowheight

public double getrowheight()
returns the height of all the rows in the range specified, measured in points. returns double.minvalue if the rows in the specified range aren't all the same height. read / write double.
specified by:
getrowheight in interface ixlsrange

getrows

public ixlsrange[] getrows()
for a range object, returns an array of range objects that represent the rows in the specified range.
specified by:
getrows in interface ixlsrange

getcolumns

public ixlsrange[] getcolumns()
for a range object, returns an array of range objects that represent the columns in the specified range.
specified by:
getcolumns in interface ixlsrange

getstyle

public istyle getstyle()
returns a style object that represents the style of the specified range. read/write istyle.
specified by:
getstyle in interface ixlsrange

getcellstylename

public java.lang.string getcellstylename()
returns name of the style object that represents the style of the specified range. read/write string.
specified by:
getcellstylename in interface ixlsrange

gettext

public java.lang.string gettext()
gets / sets string value of the range.
specified by:
gettext in interface ixlsrange

gettimespanvalue

public com.spire.ms.system.timespan gettimespanvalue()
gets / sets time value of the range.
specified by:
gettimespanvalue in interface ixlsrange

getvalue

public java.lang.string getvalue()
returns or sets the value of the specified range. read/write variant.
specified by:
getvalue in interface ixlsrange

getvalue2

public java.lang.object getvalue2()
returns or sets the cell value. read/write variant. the only difference between this property and the value property is that the value2 property doesn't use the currency and date data types.
specified by:
getvalue2 in interface ixlsrange
returns:

getverticalalignment

public verticalaligntype getverticalalignment()
returns or sets the vertical alignment of the specified object. read/write verticalaligntype.
specified by:
getverticalalignment in interface ixlsrange

getworksheet

public iworksheet getworksheet()
returns a worksheet object that represents the worksheet containing the specified range. read-only.
specified by:
getworksheet in interface ixlsrange

get

public ixlsrange get(int row,
                     int column)
gets / sets cell by row and index.
specified by:
get in interface ixlsrange

get

public ixlsrange get(int row,
                     int column,
                     int lastrow,
                     int lastcolumn)
get cell range.
specified by:
get in interface ixlsrange

get

public ixlsrange get(java.lang.string name)
get cell range.
specified by:
get in interface ixlsrange

get

public ixlsrange get(java.lang.string name,
                     boolean isr1c1notation)
gets cell range. read-only.
specified by:
get in interface ixlsrange

getconditionalformats

public conditionalformats getconditionalformats()
collection of conditional formats.
specified by:
getconditionalformats in interface ixlsrange

getdatavalidation

public validation getdatavalidation()
data validation for the range.
specified by:
getdatavalidation in interface ixlsrange

getformulastringvalue

public java.lang.string getformulastringvalue()
description copied from interface: ixlsrange
gets / sets string value evaluated by formula.
specified by:
getformulastringvalue in interface ixlsrange

getformulanumbervalue

public double getformulanumbervalue()
description copied from interface: ixlsrange
gets / sets number value evaluated by formula.
specified by:
getformulanumbervalue in interface ixlsrange

getformulaboolvalue

public boolean getformulaboolvalue()
returns the calculated value of the formula as a boolean.
specified by:
getformulaboolvalue in interface ixlsrange

getformulaerrorvalue

public java.lang.string getformulaerrorvalue()
returns the calculated value of the formula as a string.
specified by:
getformulaerrorvalue in interface ixlsrange

gethtmlstring

public java.lang.string gethtmlstring()
gets the html string which contains data and some formattings in this cell.
specified by:
gethtmlstring in interface ixlsrange
returns:

sethtmlstring

public void sethtmlstring(java.lang.string value)
sets the html string which contains data and some formattings in this cell.
specified by:
sethtmlstring in interface ixlsrange
parameters:
value -

getcomment

public icommentshape getcomment()
comment assigned to the range. read-only.
specified by:
getcomment in interface ixlsrange

getrichtext

public irichtextstring getrichtext()
string with rich text formatting. read-only.
specified by:
getrichtext in interface ixlsrange

hasmerged

public boolean hasmerged()
indicates whether this range is part of merged range. read-only.
specified by:
hasmerged in interface ixlsrange

getmergearea

public ixlsrange getmergearea()
returns a range object that represents the merged range containing the specified cell. if the specified cell isn抰 in a merged range, this property returns null. read-only.
specified by:
getmergearea in interface ixlsrange

iswraptext

public boolean iswraptext()
true if microsoft excel wraps the text in the object. read/write boolean.
specified by:
iswraptext in interface ixlsrange

hasexternalformula

public boolean hasexternalformula()
indicates is current range has external formula. read-only.
specified by:
hasexternalformula in interface ixlsrange

getignoreerroroptions

public java.util.enumset<ignoreerrortype> getignoreerroroptions()
represents ignore error options. if not single cell returs concatenateed flags.
specified by:
getignoreerroroptions in interface ixlsrange
returns:

isstringspreserved

public java.lang.boolean isstringspreserved()
indicates whether all values in the range are preserved as strings.
specified by:
isstringspreserved in interface ixlsrange

getbuiltinstyle

public builtinstyles getbuiltinstyle()
gets/sets built in style.
specified by:
getbuiltinstyle in interface ixlsrange

getrangeglobaladdress2007

public java.lang.string getrangeglobaladdress2007()
gets address global in the format required by excel 2007.
specified by:
getrangeglobaladdress2007 in interface icombinedrange

activate

public ixlsrange activate(boolean scroll)
activages a single cell, scroll to it and activates the respective sheet to select a range of cells, use the select method.
specified by:
activate in interface ixlsrange
parameters:
scroll - true to scroll to the cell
returns:

merge

public void merge()
creates a merged cell from the specified range object.
specified by:
merge in interface ixlsrange

merge

public void merge(boolean clearcells)
creates a merged cell from the specified range object.
specified by:
merge in interface ixlsrange
parameters:
clearcells - indicates whether to clear unnecessary cells.

unmerge

public void unmerge()
separates a merged area into individual cells.
specified by:
unmerge in interface ixlsrange

freezepanes

public void freezepanes()
freezes pane at the current range.
specified by:
freezepanes in interface ixlsrange

intersect

public ixlsrange intersect(ixlsrange range)
returns intersection of this range with the specified one.
specified by:
intersect in interface ixlsrange
parameters:
range - the range with which to intersect.
returns:
range intersection; if there is no intersection, null is returned.

merge

public ixlsrange merge(ixlsrange range)
returns merge of this range with the specified one.
specified by:
merge in interface ixlsrange
parameters:
range - the range to merge with.
returns:
merged ranges or null if wasn't able to merge ranges.

autofitrows

public void autofitrows()
autofits all rows.
specified by:
autofitrows in interface ixlsrange

autofitcolumns

public void autofitcolumns()
autofits all columns.
specified by:
autofitcolumns in interface ixlsrange

addcomment

public icommentshape addcomment()
adds comment to the range.
specified by:
addcomment in interface ixlsrange
returns:
range's comment.

borderaround

public void borderaround()
sets around border for current range.
specified by:
borderaround in interface ixlsrange

borderaround

public void borderaround(linestyletype borderline)
sets around border for current range.
specified by:
borderaround in interface ixlsrange
parameters:
borderline - represents border line.

borderaround

public void borderaround(linestyletype borderline,
                         java.awt.color bordercolor)
sets around border for current range.
specified by:
borderaround in interface ixlsrange
parameters:
borderline - represents border line.
bordercolor - represents border color.

borderaround

public void borderaround(linestyletype borderline,
                         excelcolors bordercolor)
sets around border for current range.
specified by:
borderaround in interface ixlsrange
parameters:
borderline - represents border line.
bordercolor - represents border color as excelcolors.

borderinside

public void borderinside()
sets inside border for current range.
specified by:
borderinside in interface ixlsrange

borderinside

public void borderinside(linestyletype borderline)
sets inside border for current range.
specified by:
borderinside in interface ixlsrange
parameters:
borderline - represents border line.

borderinside

public void borderinside(linestyletype borderline,
                         java.awt.color bordercolor)
sets inside border for current range.
specified by:
borderinside in interface ixlsrange
parameters:
borderline - represents border line.
bordercolor - represents border color.

borderinside

public void borderinside(linestyletype borderline,
                         excelcolors bordercolor)
sets inside border for current range.
specified by:
borderinside in interface ixlsrange
parameters:
borderline - represents border line.
bordercolor - represents border color as excelcolors.

bordernone

public void bordernone()
sets none border for current range.
specified by:
bordernone in interface ixlsrange

collapsegroup

public void collapsegroup(groupbytype groupby)
collapses current group.
specified by:
collapsegroup in interface ixlsrange
parameters:
groupby - this parameter specifies whether the grouping should be performed by rows or by columns.

expandgroup

public void expandgroup(groupbytype groupby)
expands current group.
specified by:
expandgroup in interface ixlsrange
parameters:
groupby - this parameter specifies whether the grouping should be performed by rows or by columns.

expandgroup

public void expandgroup(groupbytype groupby,
                        expandcollapseflags flags)
expands current group.
specified by:
expandgroup in interface ixlsrange
parameters:
groupby - this parameter specifies whether the grouping should be performed by rows or by columns.
flags - additional option flags.

getnewrangelocation

public java.lang.string getnewrangelocation(java.util.hashmap names,
                                            java.lang.string[] sheetname)
gets new address of range.
specified by:
getnewrangelocation in interface icombinedrange
parameters:
names - hashtable with worksheet names.
sheetname - string that sets as a worksheet name.
returns:
returns string with new name.

deepclone

public ixlsrange deepclone(java.lang.object parent,
                           java.util.hashmap hashnewnames,
                           xlsworkbook book)
clones current ixlsrange.
specified by:
deepclone in interface icombinedrange
parameters:
parent - parent object.
hashnewnames - hash table with new names.
book - parent workbook.
returns:
returns clone of current instance.

getcellscount

public int getcellscount()
number of cells in the range. read-only.
specified by:
getcellscount in interface icombinedrange

clearconditionalformats

public void clearconditionalformats()
clears conditional formats.
specified by:
clearconditionalformats in interface icombinedrange

getrectangles

public java.awt.rectangle[] getrectangles()
returns array that contains information about range.
specified by:
getrectangles in interface icombinedrange
returns:
rectangles that describes range

getrectanglescount

public int getrectanglescount()
returns number of rectangles returned by getrectangles method.
specified by:
getrectanglescount in interface icombinedrange
returns:
number of rectangles returned by getrectangles method.

getworksheetname

public java.lang.string getworksheetname()
gets name of the parent worksheet.
specified by:
getworksheetname in interface icombinedrange

remove

public void remove(ixlsrange range)
removes range from the collection.
specified by:
remove in interface ixlsranges
parameters:
range - range to remove.

get

public ixlsrange get(int index)
returns item by index from the collection.
specified by:
get in interface ixlsranges
overview  package   class  tree  deprecated  index  help 
 prev class   next class frames    no frames    
summary: nested | field | constr | method detail: field | constr | method
网站地图