SheetXL - v0.3.20
    Preparing search index...

    Interface ModifiersFromStringOptions

    Configuration options for customizing the parsing of a string into an ICell.Update object. Commonly used for processing CSV imports and other string-based data sources.

    interface ModifiersFromStringOptions {
        date1904?: boolean;
        dateNF?: boolean;
        ignoreQuotePrefix?: boolean;
        parse?: (text: string, context: IteratorContext) => ICell.Update;
    }
    Index

    Properties

    date1904?: boolean

    If true, dates parsed as numbers will follow the 1904 date system. When not specified, the setting is inherited from the containing cell's configuration.

    inherited from the cell container
    
    dateNF?: boolean

    When true, strings in the format m/d/yy will be automatically parsed as dates. This option is usually bypassed in favor of using localization for date formatting.

    false
    
    ignoreQuotePrefix?: boolean

    If true, the leading quote character in the string will be ignored during parsing. This option is typically useful when importing data from CSV files.

    false
    
    parse?: (text: string, context: IteratorContext) => ICell.Update

    Provides a custom callback for parsing strings during updates. This is particularly useful for handling complex data transformations in CSV imports or other data bindings.

    • The context parameter supplies cell-specific information and utility methods.
    • The callback should return an ICell.Update object, or undefined to use the default parsed value.

    Type declaration

      • (text: string, context: IteratorContext): ICell.Update
      • Parameters

        • text: string

          The input string to parse.

        • context: IteratorContext

          The context providing access to cell-specific information for parsing.

        Returns ICell.Update

        The parsed ICell.Update object, or undefined to use the default value.