com.spire.xls.core.spreadsheet
Class XlsDataValidationTable

java.lang.Object
  com.spire.ms.System.Collections.CollectionBase
      com.spire.xls.core.spreadsheet.collections.CollectionExtended
          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 CollectionExtended
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.