Enum XlsxDateTimeParsingMode

Namespace: Aspose.Words.Saving
Assembly: Aspose.Words.dll (25.12.0)

Specifies how document text is parsed to identify date and time values.

public enum XlsxDateTimeParsingMode

Fields

Auto = 1

The datetime format used in a document is determined automatically. This may take additional time.

UseCurrentLocale = 0

The datetime format set for the current thread is used first to parse string values. If the parsing fails, other common datetime formats are tried.

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);