Returning Fields of an excel xml file with PHP or jquery
I have created and excel xml file that has three cols First Name, Surname and Email. New information is added to the file but how can i call back the rows to show the information one under each other like in excel by using php or jquery (ajax) to do this?
construction is
<Row>
<Cell ss:StyleID="s21"><Data ss:Type="String">First Name</Data></Cell>
<Cell ss:StyleID="s21"><Data ss:Type="String">Surname</Data></Cell>
开发者_如何学编程 <Cell ss:StyleID="s21"><Data ss:Type="String">Email Address</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">NAME1</Data></Cell>
<Cell><Data ss:Type="String">SURNAME1</Data></Cell>
<Cell ss:StyleID="s22" ss:HRef="mailto:EMAIL1"><Data
ss:Type="String">EMAIL1</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">NAME2</Data></Cell>
<Cell><Data ss:Type="String">SURNAME2</Data></Cell>
<Cell ss:StyleID="s22" ss:HRef="mailto:EMAIL2"><Data
ss:Type="String">EMAIL2</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">NAME3</Data></Cell>
<Cell><Data ss:Type="String">SURNAME3</Data></Cell>
<Cell ss:StyleID="s22" ss:HRef="mailto:EMAIL3"><Data
ss:Type="String">EMAIL3</Data></Cell>
</Row>
RESULT:
FIRST NAME SURNAME EMAIL
NAME1 SURNAME1 EMAIL1
NAME2 SURNAME2 EMAIL2
ETC.
You could try http://phpexcel.codeplex.com/
精彩评论