[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: SV: SV: XML=WAP? And DOA?
Mike Champion wrote: > How about a simple CSV vs XML export of a realistic, non- > trivial document/spreadsheet/etc. from a real program? I'd > guess that Excel XP can do that (but I don't have it > installed). Can someone provide such an example? Gnumeric's native format is gzipped XML, and it can handle both Excel 95 and CSV formats. I am not a spreadsheet user, so don't have any "realistic" ones lying around; however, here is a spreadsheet wherein A1 = 3, A2 = 4, and A3 is the formula "A1 + A2". Content and presentation information are rather intermingled, but I find it fairly readable, as XML goes. <?xml version="1.0"?> <gmr:Workbook xmlns:gmr="http://www.gnome.org/gnumeric/v5"> <gmr:Attributes> <gmr:Attribute> <gmr:name>WorkbookView::show_horizontal_scrollbar</gmr:name> <gmr:type>4</gmr:type> <gmr:value>TRUE</gmr:value> </gmr:Attribute> <gmr:Attribute> <gmr:name>WorkbookView::show_vertical_scrollbar</gmr:name> <gmr:type>4</gmr:type> <gmr:value>TRUE</gmr:value> </gmr:Attribute> <gmr:Attribute> <gmr:name>WorkbookView::show_notebook_tabs</gmr:name> <gmr:type>4</gmr:type> <gmr:value>TRUE</gmr:value> </gmr:Attribute> </gmr:Attributes> <gmr:Summary> <gmr:Item> <gmr:name>application</gmr:name> <gmr:val-string>gnumeric</gmr:val-string> </gmr:Item> <gmr:Item> <gmr:name>author</gmr:name> <gmr:val-string>John Cowan</gmr:val-string> </gmr:Item> </gmr:Summary> <gmr:Names/> <gmr:Geometry Width="0" Height="0"/> <gmr:Sheets> <gmr:Sheet> <gmr:Name>Sheet1</gmr:Name> <gmr:MaxCol>2</gmr:MaxCol> <gmr:MaxRow>0</gmr:MaxRow> <gmr:Zoom>1.000000</gmr:Zoom> <gmr:Names/> <gmr:PrintInformation> <gmr:PrintUnit Points="28.34645669291" PrefUnit="cm">top</gmr:PrintUnit> <gmr:PrintUnit Points="28.34645669291" PrefUnit="cm">bottom</gmr:PrintUn it> <gmr:PrintUnit Points="28.34645669291" PrefUnit="cm">left</gmr:PrintUnit > <gmr:PrintUnit Points="28.34645669291" PrefUnit="cm">right</gmr:PrintUni t> <gmr:PrintUnit Points="14.17322834646" PrefUnit="cm">header</gmr:PrintUn it> <gmr:PrintUnit Points="14.17322834646" PrefUnit="cm">footer</gmr:PrintUn it> <gmr:vcenter value="0"/> <gmr:hcenter value="0"/> <gmr:grid value="0"/> <gmr:monochrome value="0"/> <gmr:draft value="0"/> <gmr:titles value="0"/> <gmr:repeat_top value=""/> <gmr:repeat_left value=""/> <gmr:order>r_then_d</gmr:order> <gmr:orientation>landscape</gmr:orientation> <gmr:Header Left="" Middle="&[TAB]" Right=""/> <gmr:Footer Left="" Middle="Page &[PAGE]" Right=""/> <gmr:paper>A4</gmr:paper> </gmr:PrintInformation> <gmr:Cols DefaultSizePts="48"> <gmr:ColInfo No="0" Unit="48" MarginA="2" MarginB="2" HardSize="0" Hidde n="0" Count="3"/> </gmr:Cols> <gmr:Rows DefaultSizePts="12.75"> <gmr:RowInfo No="0" Unit="12.75" MarginA="1" MarginB="0" HardSize="0" Hi dden="0"/> </gmr:Rows> <gmr:Selections CursorCol="2" CursorRow="1"> <gmr:Selection startCol="2" startRow="1" endCol="2" endRow="1"/> </gmr:Selections> <gmr:Cells> <gmr:Cell Col="0" Row="0" ValueType="30"> <gmr:Content>3</gmr:Content> </gmr:Cell> <gmr:Cell Col="1" Row="0" ValueType="30"> <gmr:Content>4</gmr:Content> </gmr:Cell> <gmr:Cell Col="2" Row="0"> <gmr:Content>=A1+B1</gmr:Content> </gmr:Cell> </gmr:Cells> <gmr:Solver TargetCol="-1" TargetRow="-1" ProblemType="1" Inputs=""/> </gmr:Sheet> </gmr:Sheets> <gmr:UIData SelectedTab="0"/> </gmr:Workbook> -- Not to perambulate || John Cowan <jcowan@r...> the corridors || http://www.reutershealth.com during the hours of repose || http://www.ccil.org/~cowan in the boots of ascension. \\ Sign in Austrian ski-resort hotel
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|