ig.excel.WorksheetCellCollection

A collection of cells in a row.

Remarks

Cells in this collection are lazily created (they are only created and added to the collection when they are accessed). If this collection is enumerated, it only enumerates the cells which were already accessed.

Dependencies

jquery-1.4.4.js
infragistics.util.js
The current widget has no options.
The current widget has no events.
  • item

    .item( index:number );
    Return Type:
    ig.excel.WorksheetCell
    Return Type Description:
    The cell at the specified column index in the owning row.

    Gets the cell at the specified column index in the owning row.

    • index
    • Type:number
    • The zero-based column index of the cell to get.

    Exceptions

    Exception Description
    ig.ArgumentOutOfRangeException index is less than zero.
    ig.InvalidOperationException If the row was removed from the worksheet. index is greater than or equal to Workbook.maxExcelColumnCount or Workbook.maxExcel2007ColumnCount, depending on the Workbook.currentFormat.

    Remarks

    Note: Iterating the collection will not create all cells. It will only iterate the cells which have already been used. To create and iterate all cells in the worksheet use a For loop, iterating from 0 to one less than the maximum column count, and pass in each index to the collection's indexer.

  • maxCount

    .maxCount( );

    Gets the maximum number of items allowed in this collection.

Copyright © 1996 - 2024 Infragistics, Inc. All rights reserved.