带有日期格式php的XlS文件

Question

I have created a xls file with following row,

  <Row>
   <Cell><Data ss:Type="String">1761601 21:36</Data></Cell>
   <Cell><Data ss:Type="DateTime">2014-08-20</Data></Cell>
   <Cell><Data ss:Type="Number">12</Data></Cell>
 </Row>

But, <Cell><Data ss:Type="DateTime">2014-08-20</Data></Cell> will create a cell with value 41871 ,Why? How can i show that value in date format?

Answer 1

IN the <style> section add

   <Style ss:ID="s22">
   <NumberFormat ss:Format="yyyy\-mm\-dd"/>
   </Style>

then mark your cell with the style:

 <Cell ss:StyleID="s22"><Data ss:Type="DateTime">2014-08-20</Data></Cell>

Try this it should work!!

DO LET ME KNOW IF IT WORKS