Aspose::Words::Saving::XlsxDateTimeParsingMode enum

XlsxDateTimeParsingMode enum

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

enum class XlsxDateTimeParsingMode

Values

NameValueDescription
UseCurrentLocale0The datetime format set for the current thread is used first to parse string values. If the parsing fails, other common datetime formats are tried.
Auto1The datetime format used in a document is determined automatically. This may take additional time.

Examples

Shows how to specify autodetection of the date time format.

auto doc = System::MakeObject<Aspose::Words::Document>(get_MyDir() + u"Xlsx DateTime.docx");

auto saveOptions = System::MakeObject<Aspose::Words::Saving::XlsxSaveOptions>();
// Specify using datetime format autodetection.
saveOptions->set_DateTimeParsingMode(Aspose::Words::Saving::XlsxDateTimeParsingMode::Auto);

doc->Save(get_ArtifactsDir() + u"XlsxSaveOptions.DateTimeParsingMode.xlsx", saveOptions);

See Also