Subject: [xsl] RE: generate xml from excel file From: Dan Diebolt <dandiebolt@xxxxxxxxx> Date: Sat, 24 Nov 2001 21:04:58 -0800 (PST) |
Excel in Office XP will directly read/write "XML spreadsheets". **alt** **enter** is represented as in the XML Here is a snip of the XML for the following data: | A | B | --+------+-----+ |Hello | | 1 |World | 2 | --|------+-----+ 2 | 3 | 4 | <?xml version="1.0"?> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40"> ... <Worksheet ss:Name="Sheet1"> <Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="2" x:FullColumns="1" x:FullRows="1"> <Row ss:Height="25.5"> <Cell ss:StyleID="s21"><Data ss:Type="String">hello world</Data></Cell> <Cell><Data ss:Type="Number">2</Data></Cell> </Row> <Row> <Cell><Data ss:Type="Number">3</Data></Cell> <Cell><Data ss:Type="Number">4</Data></Cell> </Row> </Table> <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> <Selected/> <Panes> <Pane> <Number>3</Number> <ActiveRow>1</ActiveRow> <ActiveCol>1</ActiveCol> </Pane> </Panes> <ProtectObjects>False</ProtectObjects> <ProtectScenarios>False</ProtectScenarios> </WorksheetOptions> </Worksheet> <Worksheet ss:Name="Sheet2"> ... </Worksheet> </Workbook> __________________________________________________ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] generate xml from excel file, Yang | Thread | [xsl] higher-order functions in xsl, Oleg Tkachenko |
RE: [xsl] dynamic grouping of tabul, Chris Bayes | Date | RE: [xsl] dynamic grouping of tabul, Dan Diebolt |
Month |