Page History

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`.

Signature

	C#
	C#

public boolean ConvertStrings{ get; set; }

Signature

	vb.net
	vb.net

Public Property ConvertStrings() As Boolean

Remarks

By default, when importing data, ExcelWriter will not convert numeric strings to numbers. If ConvertStrings is set to true, ExcelWriter will parse the strings into a decimal type by using the culture information specified through the ConversionCulture property. If no specific culture is explicitly set explicitly, the invariant culture will be used to parse the numeric string. Currently only the currencies and formatted numerals (such as numbers with the decimal and thousands delimiters) will be parsed into numbers. Percentage, date and time, exponents and hexadecimal representations won't be converted.

Example

Code Block

	csharp
	csharp
title	C#


      DataImportProperties importProps = wb.CreateDataImportProperties();

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

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

Code Block

	vb.net
	vb.net
title	vb.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.

Space Shortcuts

Page tree

Versions Compared

Old Version 1

New Version Current

Key