开发者

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/

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜