_Application.SaveISO8601Dates Property
Gets or sets whether Excel saves date and time values using the ISO 8601 format.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property SaveISO8601Dates As Boolean
Get
Set
'Usage
Dim instance As _Application
Dim value As Boolean
value = instance.SaveISO8601Dates
instance.SaveISO8601Dates = value
bool SaveISO8601Dates { get; set; }
Property Value
Type: System.Boolean
true if Excel saves date and time values using the ISO 8601 format; otherwise, false.
Remarks
Read/write.
Setting the SaveISO8601Dates property to true is equivalent to selecting the Save date and time values using ISO 8601 date format check box in the Excel Options dialog box. To access this setting, click the File tab, click Options, and then click Save. The check box is located in the Save workbooks section of the dialog box. This setting applies only to cells formatted with the Date or Time format in files saved to Open XML file formats, such as .xlsx.