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}
{signature:

}

Signature

	vb.net


	vb.net

Public Property ConvertStrings() As Boolean
{signature}

{remarks}
By

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

|DataImportProperties.ConversionCulture]

property.

If

no

specific

culture

is

explicitly

set,

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.

{remarks} {example} {code:csharp|title=C#}

Example

Code Block

	csharp
	csharp
title	C#



    DataImportProperties importProps = wb.CreateDataImportProperties();

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

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

{code} {code:

Code Block

	vb.net

|title=


	vb.net
title	vb.net

}



    Dim importProps As DataImportProperties = wb.CreateDataImportProperties()

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

    '--- Set ConvertStrings
    importProps.ConvertStrings = True

{code} {example} {remarks}When {{ConvertStrings}} is set to {{true}} it will also affect column names when {{UseColumnNames}} is also set to true. {remarks}

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 9

New Version Current

Key