Altova Mailing List Archives>Archive Index >microsoft.public.xml Archive Home >Recent entries [Thread Prev] >Thread Next - Re: File XML to open with Microsoft Excel File XML to open with Microsoft ExcelTo: NULL Date: 7/17/2009 2:36:00 AM Hi, we have created the following XML file. We should have to open it
with Excel and do an automatic Sum of the FIELD1 colum. So we have
created this file:
<?xml version="1.0" encoding="ISO-8859-1"?>
<Document>
<Costs>
<Record>
<FIELD1>100</FIELD1>
<FIELD2>110</FIELD2>
</Record>
<Record>
<FIELD1>200</FIELD>
<FIELD2>210</FIELD>
</Record>
</Costs>
</Document>
This file works fine with Excel, we can do the automatic Sum of the
column FIELD1 without problems.
The problem is that if we have values with decimals (for example
100,10) then Excel cannot do the automatic Sum of the colum.
So, if we try this file :
<?xml version="1.0" encoding="ISO-8859-1"?>
<Document>
<Costs>
<Record>
<FIELD1>100,1</FIELD1>
<FIELD2>110,2</FIELD2>
</Record>
<Record>
<FIELD1>200,3</FIELD>
<FIELD2>210,1</FIELD>
</Record>
</Costs>
</Document>
Then we get the problem..
How should we change the XML file to solve the problem? (because we
have number with decimals)
Thanks!
Best regards,
Maurizio
| ||||||
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | Mobile | Full Site | |||
|
