Converts the given or current cell coordinates to their corresponding A1-style address string (e.g., 'A1').
Optionalcoords: Partial<IRange.FixableCellCoords>The coordinates to convert. If not provided, the coordinates of the current cell in the iteration will be used.
The A1-style address string representing the cell coordinates.
Retrieves the ICell associated with the current iteration.
Retrieves the IRange.CellCoords associated with the current iteration.
Return the ScalarType of the value.
Convert the current value to a Javascript Date object, considering the containers's 1904 date system setting.
Optionalvalue: numberA JavaScript Date object representing the converted date, or null if the value is not a valid date (< 0 or greater than December 31, 9999).
Spreadsheets store dates internally as serial numbers (OADates) to optimize calculation performance. These are integer values representing the number of days since either January 1, 1900, or January 1, 1904, depending on the container's settings.
For type-safe date retrieval consider using the ICell.toDate method, which returns null if the cell value is not a valid date.
Refer to the following resources for more details: Date systems in Excel DateTime.ToOADate Method
Provides access to cell-specific information and utility functions during range iteration.
This object serves as a context in the iterator, offering a convenient way to retrieve the cell's coordinates, the full ICell object, and perform additional operations like converting values to JavaScript dates or getting the cell's address.