icombinedrange-j9官方网址

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
interface icombinedrange

all superinterfaces:: java.lang.iterable, ixlsrange

all known implementing classes:: cellrange, xlsrange, xlsrangescollection

public interface icombinedrange
extends ixlsrange
extends ixlsrange

represents a combined range.

method summary
`void`	`clearconditionalformats()` clears conditional formats.
`ixlsrange`	`deepclone(java.lang.object parent, java.util.hashmap hashnewnames, xlsworkbook book)` clones current ixlsrange.
`int`	`getcellscount()` number of cells in the range.
`java.lang.string`	`getnewrangelocation(java.util.hashmap names, java.lang.string[] strsheetname)` gets new address of range.
`java.lang.string`	`getrangeglobaladdress2007()` gets address global in the format required by excel 2007.
`java.awt.rectangle[]`	`getrectangles()` returns array that contains information about range.
`int`	`getrectanglescount()` returns number of rectangles returned by getrectangles method.
`java.lang.string`	`getworksheetname()` gets name of the parent worksheet.

methods inherited from interface com.spire.xls.core.ixlsrange
activate, addcomment, autofitcolumns, autofitrows, borderaround, borderaround, borderaround, borderaround, borderinside, borderinside, borderinside, borderinside, bordernone, clear, clearcontents, collapsegroup, expandgroup, expandgroup, freezepanes, get, get, get, get, getbooleanvalue, getborders, getbuiltinstyle, getcelllist, getcellstylename, getcolumn, getcolumngrouplevel, getcolumns, getcolumnwidth, getcomment, getconditionalformats, getcount, getdatavalidation, getdatetimevalue, getendcell, getentirecolumn, getentirerow, getenvalutedvalue, geterrorvalue, getformula, getformulaarray, getformulaarrayr1c1, getformulaboolvalue, getformulaerrorvalue, getformulanumbervalue, getformular1c1, getformulastringvalue, gethorizontalalignment, gethtmlstring, getignoreerroroptions, getindentlevel, getinnerformuladatetime, getlastcolumn, getlastrow, getmergearea, getnumberformat, getnumbertext, getnumbervalue, getrangeaddress, getrangeaddresslocal, getrangeglobaladdress, getranger1c1address, getranger1c1addresslocal, getrichtext, getrow, getrowgrouplevel, getrowheight, getrows, getstyle, gettext, gettimespanvalue, getvalue, getvalue2, getverticalalignment, getworksheet, hasboolean, hasdatavalidation, hasdatetime, haserror, hasexternalformula, hasformula, hasformulaarray, hasformulaboolvalue, hasformuladatetime, hasformulaerrorvalue, hasformulanumbervalue, hasformulastringvalue, hasmerged, hasnumber, hasrichtext, hasstring, hasstyle, intersect, isblank, isformulahidden, isgroupedbycolumn, isgroupedbyrow, isinitialized, isstringspreserved, isstringspreserved, iswraptext, iswraptext, merge, merge, merge, set, setbooleanvalue, setbuiltinstyle, setformulanumbervalue, setformulastringvalue, sethtmlstring, setignoreerroroptions, setobjectvalue, setvalue, setverticalalignment, unmerge

methods inherited from interface com.spire.xls.core.ixlsrange

activate, addcomment, autofitcolumns, autofitrows, borderaround, borderaround, borderaround, borderaround, borderinside, borderinside, borderinside, borderinside, bordernone, clear, clearcontents, collapsegroup, expandgroup, expandgroup, freezepanes, get, get, get, get, getbooleanvalue, getborders, getbuiltinstyle, getcelllist, getcellstylename, getcolumn, getcolumngrouplevel, getcolumns, getcolumnwidth, getcomment, getconditionalformats, getcount, getdatavalidation, getdatetimevalue, getendcell, getentirecolumn, getentirerow, getenvalutedvalue, geterrorvalue, getformula, getformulaarray, getformulaarrayr1c1, getformulaboolvalue, getformulaerrorvalue, getformulanumbervalue, getformular1c1, getformulastringvalue, gethorizontalalignment, gethtmlstring, getignoreerroroptions, getindentlevel, getinnerformuladatetime, getlastcolumn, getlastrow, getmergearea, getnumberformat, getnumbertext, getnumbervalue, getrangeaddress, getrangeaddresslocal, getrangeglobaladdress, getranger1c1address, getranger1c1addresslocal, getrichtext, getrow, getrowgrouplevel, getrowheight, getrows, getstyle, gettext, gettimespanvalue, getvalue, getvalue2, getverticalalignment, getworksheet, hasboolean, hasdatavalidation, hasdatetime, haserror, hasexternalformula, hasformula, hasformulaarray, hasformulaboolvalue, hasformuladatetime, hasformulaerrorvalue, hasformulanumbervalue, hasformulastringvalue, hasmerged, hasnumber, hasrichtext, hasstring, hasstyle, intersect, isblank, isformulahidden, isgroupedbycolumn, isgroupedbyrow, isinitialized, isstringspreserved, isstringspreserved, iswraptext, iswraptext, merge, merge, merge, set, setbooleanvalue, setbuiltinstyle, setformulanumbervalue, setformulastringvalue, sethtmlstring, setignoreerroroptions, setobjectvalue, setvalue, setverticalalignment, unmerge

method detail

getnewrangelocation

java.lang.string getnewrangelocation(java.util.hashmap names,
                                     java.lang.string[] strsheetname)

gets new address of range.

parameters:: names - hashtable with worksheet names.; strsheetname - string that sets as a worksheet name.
returns:: returns string with new name.

deepclone

ixlsrange deepclone(java.lang.object parent,
                    java.util.hashmap hashnewnames,
                    xlsworkbook book)

clones current ixlsrange.

parameters:: parent - parent object.; hashnewnames - hash table with new names.; book - parent workbook.
returns:: returns clone of current instance.

clearconditionalformats

void clearconditionalformats()

clears conditional formats.

getrectangles

java.awt.rectangle[] getrectangles()

returns array that contains information about range.

returns:: rectangles that describes range

getrectanglescount

int getrectanglescount()

returns number of rectangles returned by getrectangles method.

returns:: number of rectangles returned by getrectangles method.

getcellscount

int getcellscount()

number of cells in the range. read-only.

getrangeglobaladdress2007

java.lang.string getrangeglobaladdress2007()

gets address global in the format required by excel 2007.

getworksheetname

java.lang.string getworksheetname()

gets name of the parent worksheet.