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
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
Please sign in to leave a comment.
Comments 2