help required to change format when converted from excel to xml.

T

tdnithin

Hi Guys,

I am Using Microsoft office Excel 2003.

I am saving an excel file as xmlspreadsheet.

When I do this the values in column L of the excel spreadsheet is
displayed in the xml spreadsheet in exponential form.

eg: 2.8525% in excel sheet is displayed in xml as

2.8524999999999998E-2



Could anyone please assist me in rectifying this: I need the value in
the xml to be displaying in %age form.

e.g: 2.8524999999999998E-2 in xml should actually be displayed as
2.8525%.

style defined for this particular value in the xml as below.

<Style ss:ID="s109" ssarent="s24">

<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>

<Borders/>

<Font x:Family="Swiss" ssize="7"/>

<Interior ss:Color="#FFFFFF" ssattern="Solid"/>

<NumberFormat ss:Format="0.0000000000%"/>

</Style>



Please help me to resolve this issue.

Looking forward for a quick response.



rgds

NithinJ
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to read accent character in a generated xml file 1
Generating an EXCEL dataset with formating 1
Value 1 in excel cell show as 0.99999999999999978 once save in XMLformat 3
Format cells using C# 0
ss:Formula in excel saved in xml format 4
XML ERROR in PivotTable on generated XML spreadsheet 0
Using System.Xml.XmlDocument to parse an XML Excel document 1
AutoFitHeight and Height not working together 0

Top