Datatype mismatch in Javelin table export

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Working with Javelin flows and Export Data Table activity in excel files. The columns that contains numbers (for example when data table type is “Decimal”) are exported in text format, and workarounds are needed to convert directly into excel file.

Is there a solution/suggestion for that?

Environment

Javelin 4.11.0.X

Cause

By default, existing Export to DataTable activity does set all Excel cells as Strings when exporting.

Resolution

Attached is an example flow with a few steps added to fix all numbers to be handled as numbers and not strings anymore.