Excel Number format Issue while downloading result in EC
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.
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.
- pius_francis
- Posts: 49
- Joined: Mon Feb 03, 2014 10:30 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":
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>
- gsmith
- Posts: 291
- Joined: Thu May 12, 2011 9:40 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 ?
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 ?
- pius_francis
- Posts: 49
- Joined: Mon Feb 03, 2014 10:30 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...
- gsmith
- Posts: 291
- Joined: Thu May 12, 2011 9:40 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
Thanks
Pius
- pius_francis
- Posts: 49
- Joined: Mon Feb 03, 2014 10:30 am
5 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest