Data type conversions from DataStage to Microsoft Excel

Last updated: Mar 12, 2025

Before the Excel stage writes data that is extracted from input links to Microsoft Excel files, the data is converted to Microsoft Excel data types.

The following table shows the mapping between DataStage® data types and Microsoft Excel data types .

Note: The Excel stage maps the data type conversions from DataStage data types to Microsoft Excel files only when the Excel stage writes records to the Microsoft Excel data source.

Table 1. Mapping between Microsoft Excel cell value data types and DataStage data types
DataStage data type	Microsoft Excel cell data type
Text data types Char, VarChar, LongVarChar National language text data types NChar, NVarChar, LongNVarChar	String
Integer data types BigInt, Integer, SmallInt, TinyInt Fraction data types Double, Float, Real Decimal data types Decimal, Numeric	Numeric
Date and time data types Date, Time, Timestamp	Numeric Note: This note is applicable only when you are writing data to existing Microsoft Excel files. Excel stage does not set format for date and time data types. It is recommended to set proper format to express the date, time or timestamp to your Microsoft Excel file.
Binary data types Binary, VarBinary, LongVarBinary, Bit	Not supported.

Was the topic helpful?

0/1000