DateTimeParsingMode

XlsxSaveOptions.DateTimeParsingMode property

Gets or sets the mode that specifies how document text is parsed to identify date and time values. The default value is UseCurrentLocale.

public XlsxDateTimeParsingMode DateTimeParsingMode { get; set; }

Examples

Shows how to specify autodetection of the date time format.

Document doc = new Document(MyDir + "Xlsx DateTime.docx");

XlsxSaveOptions saveOptions = new XlsxSaveOptions();
// Specify using datetime format autodetection.
saveOptions.DateTimeParsingMode = XlsxDateTimeParsingMode.Auto;

doc.Save(ArtifactsDir + "XlsxSaveOptions.DateTimeParsingMode.xlsx", saveOptions);

See Also