SetCellDate method: PSSpreadsheet class

Syntax

SetCellDate(rownum, colnum, date, locale, timezone, format)

Description

Use the SetCellDate method to set a date value and format for the specified cell in the active spreadsheet.

Parameters

Parameter	Description
rownum	Specifies the row number for the cell.
colnum	Specifies the column number for the cell.
date	Specifies the date value to be set in the cell.
locale	Specifies the locale for the date cell value.
timezone	Specifies the time zone for the date cell value.
format	Specifies the date format for the cell value.

Returns

(Optional) A Boolean value: True if the method completes successfully, False otherwise.

Example

The following example sets a date value and format for the cell within the spreadsheet.

&rownum = 2;
&colnum = 2;
&data = 120223323;
&locale = "EN";
&timezone = "Americas/Los_Angeles";
&format = "m/d/yy h:mm";
&ssObject. SetCellDate(&rownum, &colnum, &data, &locale, &timezone, &format);