Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Introducedin
8.4
8.4
Description

Excerpt

Sets or returns whether to convert numeric strings such as currencies and formatted numerals in the imported data to numbers by using the culture information specified through the ConversionCulture property. By default it is set to false.

...

Example
Code Block
csharp
csharp
titleC#

    DataImportProperties importProps = wb.CreateDataImportProperties();

    //--- Get ConvertStrings
    bool convertStrings = importProps.ConvertStrings;

    //--- Set ConvertStrings
    importProps.ConvertStrings = true;

Code Block
vb.net
vb.net
titlevb.net

    Dim importProps As DataImportProperties = wb.CreateDataImportProperties()

    '--- Get ConvertStrings
    Dim convertStrings As Boolean =  importProps.ConvertStrings

    '--- Set ConvertStrings
    importProps.ConvertStrings = True

Remarks

When ConvertStrings is set to true it will also affect column names when UseColumnNames is also set to true.