out.dataTypes Argument

Parent Previous Next

out.dataTypes Argument

The out.dataTypes argument specifies how DbTransfer should write values to the excel file.






This argument is optional. If not specified the mode "Text" is used.

Possible values

Text or Native


DbTransfer will write values as their native excel data types in excel files.

For example decimals are stored as native excel numbers.

This is useful when you want to be able to sort values in the excel file and use values in formulas.


DbTransfer will write all values as text in excel file.

For example decimals are stored as their textual representation (according to the settings specified in the Data Format section) and not as native excel numbers.

When you are using excel files as backup for your database this is the recommended mode, since it will prevent excel from changing (reformatting) values.