XLS Writer Cell formatting issue

CloverDX Platform
1

Hi,
I have a clover graph running that uses the DB_EXECUTE component to read data from the database tables, formats it using the REFORMAT component and then writes it into an Excel file using the XLS_WRITER. I am using Clover’s Java API to achieve this. And I’m using Clover 2.7.2 API.

The issue I’m facing is that Excel strips the leading zeroes in fields that are defined as string type in clover but have a number as its data value, for example, a zip code. A value like 05401 will be seen as 5401 in Excel even though I’m defining it as a string in the clover meta-data.

Is there a way in clover to set the formatting on excel to treat it as a string and not a number? Or is there some way i can handle it in my reformat class?

Please let me know if you need more info.

Thanks in advance!
Pramod

2

I would recommend shifting to the latest Clover version (2.9.1.) where is no such problem. The leading zeros are seen in Excel as well.

Lucie Smrckova

3

Thanks Lucie.
I just finished migrating to 2.9.1 and I’m testing it and all looks fine so far!