Data

Data settings allow you to configure data processing during import.

 

ExpandedToggleIcon        General

Too long values

Maximum number of characters

The default value is 32767 - it is the maximum number of characters in a cell that Devart Excel Add-ins can import. You can set this parameter to a lower value, but not higher.

 

Processing options

You can choose an action to be performed in case when the length (number of characters) of an item in the table is greater than the specified maximum number of characters:

•Do not import this value (empty cell) - the cell for such value will be empty in Excel and not editable.
•Trim value - the data will be trimmed to the length set as maximum number of characters.
•Trim values and add to the end -  the data will be trimmed to the length set as maximum number of characters, and the specified text is appended to the value.
•Replace with text - the specified text is placed to the cell instead of a value

 

Show warning about such long strings when importing

If selected, a warning will be displayed during the import operations if too long values are imported.

 

Binary values

Binary data cannot be displayed in Excel and may be too big. So you can set the behavior for cases, when the imported table contains binary data:

 

Show binary columns

Select this check box if you want to import cells containing binary data with one of the following options:

•Do not import (empty cell) - the cell for such value will be empty in Excel and not editable
•Replace by text - binary values will be replaced with the text, specified here.
•Hexadecimal representation - binary data will be imported in hexadecimal representation.

 

ExpandedToggleIcon        Escaping

Escape text values that start with '=' so Excel does not treat them as formulas

Select to escape imported strings that start with '=' so that Excel treats them as string values instead of formulas.

 

Escape text values that contain special chars so Excel does not treat them as datetime

Select to escape imported strings that can be treated as datetime values by Excel, so that Excel treats them as string values instead of datetime.

 

Escape text values that end with '%' so Excel does not treat them as percentage

Select to escape imported strings that end with the percent sign (%) so that Excel treats them as string values instead of percentage.

 

Escape negative time values so Excel does not treat them as formulas

Select to escape imported negative time values so that Excel treats them as string values instead of formulas.

 

Escape large integer values so Excel does not round them

Select to escape imported integer values that exceed 15 digits so that Excel doesn't round them.

 

Escape text values that start with '$' so Excel does not convert them

Select to escape imported text values that start with the '$' character so that Excel doesn't convert them.