xlsdatavalidationtable-人生就是博尊龙凯时

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
class xlsdatavalidationtable

java.lang.object
  com.spire.ms.system.collections.collectionbase
      
          com.spire.xls.core.spreadsheet.xlsdatavalidationtable

all implemented interfaces:: com.spire.ms.system.collections.icollection, com.spire.ms.system.collections.ienumerable, idatavalidationtable, java.lang.iterable

public class xlsdatavalidationtable
extends
implements idatavalidationtable
extends
implements idatavalidationtable

table of all data validations in the worksheet.

constructor summary
`xlsdatavalidationtable(java.lang.object parent)`

method summary
`idatavalidation`	`finddatavalidation(long icellindex)` searches for corresponding data validation.
`xlsdatavalidationcollection`	`get(int index)` returns single entry from the collection.
`int`	`getshapescount()` gets number of required shapes objects.
`workbook`	`getworkbook()` gets parent workbook.
`worksheet`	`getworksheet()` gets parent wokrsheet.
`void`	`remove(java.awt.rectangle[] rectangles)` removes specified rectangles from the collection.

constructor detail

xlsdatavalidationtable

public xlsdatavalidationtable(java.lang.object parent)

method detail

getworksheet

public worksheet getworksheet()

gets parent wokrsheet. read-only.

specified by:: getworksheet in interface idatavalidationtable

returns:

getworkbook

public workbook getworkbook()

description copied from interface: idatavalidationtable

gets parent workbook. read-only.

specified by:: getworkbook in interface idatavalidationtable

returns:

get

public xlsdatavalidationcollection get(int index)

returns single entry from the collection. read-only.

specified by:: get in interface idatavalidationtable

parameters:: index -
returns:

getshapescount

public int getshapescount()

gets number of required shapes objects.

specified by:: getshapescount in interface idatavalidationtable

returns:

finddatavalidation

public idatavalidation finddatavalidation(long icellindex)

searches for corresponding data validation.

specified by:: finddatavalidation in interface idatavalidationtable

parameters:: icellindex - cell index.
returns:: found data validation or null.

remove

public void remove(java.awt.rectangle[] rectangles)

removes specified rectangles from the collection.

specified by:: remove in interface idatavalidationtable

parameters:: rectangles - rectangles to remove.