Returns a number that represents the date in the date-time code.
Name | Type | Description |
arg1 | number | A number from 1900 or 1904 (depending on the workbook's date system) to 9999. |
arg2 | number | A number from 1 to 12 representing the month of the year. |
arg3 | number | A number from 1 to 31 representing the day of the month. |
builder.CreateFile("xlsx"); var oWorksheet = Api.GetActiveSheet(); var oFunction = Api.GetWorksheetFunction(); oWorksheet.GetRange("A1").SetValue(oFunction.DATE(2018, 3, 16)); builder.SaveFile("xlsx", "DATE.xlsx"); builder.CloseFile();