Excel Number format Issue while downloading result in EC

Thu Oct 30, 2014 9:39 am

Hi ,
I am encountering an issue with number format in excel for the results downloaded from ECL watch. PFB, the example.
//Start of code
layout := RECORD
STRING text;
END;

output := DATASET(['.15'],layout);
output;
//End of code
While downlaoding the result from ECL as excel the value .15 is being stored as 0.15. Is there is workaroud to avoid it?

Please help me out regarding the same.

Thu Oct 30, 2014 9:56 am

How interesting...

I just opened the raw xls file in a text editor and it looks like it is Excel that is adding the "0":

Code: Select all: <html xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xs="http://www.w3.org/2001/XMLSchema"> <head> <META http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Result </title> </head> <body class="yui-skin-sam"> <table xmlns:msxsl="urn:schemas-microsoft-com:xslt" class="results" cellspacing="0" frame="box" rules="all"> <thead> <tr valign="bottom"> <th rowspan="1">text</th> </tr> </thead> <tr> <td>.15</td> </tr> </table> </body> </html>

Thu Oct 30, 2014 10:07 am

Thanks for the reply.

Yeah Smith , in xml we will get .15 only. Is this an issue with ECL download or can we have any work around like specifying the number format for excel while downloading ?

Thu Oct 30, 2014 10:33 am

In the IDE you can save a result as CSV - then in Excel, click on the DATA tab and import the CSV, during that process you can specify the data type for each column...

Thu Oct 30, 2014 10:44 am

Smith , i have tried that part. The scenario i have shared is a sample one. But we have different number format for same column for the real Use Case.Only if we are able to avoid the formatting change when it goes into excel or csv it will be useful.

Thanks
Pius