Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert XLS to XML without XLS Properties
Dear All,
I need to convert one excel (xls) file to XML file without the excel properties like height, width, font etc. This appears as 'Style' statements in the XML file. Following is the sample XML file showing the Style statments- <Style ss:ID="s23" <NumberFormat ss:Format="@"/ </Style <Style ss:ID="s24" <NumberFormat ss:Format="#,##0.000"/ </Style <Style ss:ID="s25" <Font ss:Color="#000000"/ <Interior ss:Color="#FFCC99" ss:Pattern="Solid"/ </Style <Style ss:ID="s26" <Interior/ <NumberFormat ss:Format="@"/ </Style Kindly help in saving the XLS to XML directly without above properites so that the XML will directly show the column headings and the data. Thanks & Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert number to its letters ( convert "1" to "One" ) | Excel Discussion (Misc queries) | |||
Querying Properties programmatically | Excel Discussion (Misc queries) | |||
CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions |