使用PHP解析Excel XML [英] Parsing Excel XML with PHP

问题描述

我使用excel下载作为用户下载分数表的方式，
填写分数，然后重新上传此分数表进入
系统。

I'm using excel downloads as a way of users downloading a score sheet, filling out scores and then re-uploading this score sheet into the system.

这部分需要将数据库中的数据放入CSV中。
然后在客户端计算机上打开。

Part of this requires the data in the database to be put into a CSV. Then its opened on the client computer.

CSV不允许我使用任何
种格式化。这包括隐藏单元格，使文本粗体等。

The problem I'm having is that the CSV does not allow me to use any kind of formatting. This includes hiding cells, making text bold etc.

因此，解析数据输入和输出excel格式（xls）文档将
更有意义。 。但是从我听到的和读的，这将是
真的很难，因为不同的excel版本等等。

So parsing the data in and out of an excel format (xls) document would make more sense... But from what I've heard and read, this would be really difficult because of different excel versions etc etc.

我听说XML是将数据解析成excel格式的好方法。
我想知道是否有任何人有使用php的任何经验？

I heard that XML is a good way of parsing data into an excel format. I wondered if anyone had any experience of this using php?

有没有人听说过好的脚本？
任何人对不同版本的excel有任何意见打开
ir（甚至，像开放办公室或莲花）
如果我最好的一步，你认为如何？

Is there a good script anyone has heard of? Does anyone have any comments on different versions of excel opening ir (or even, things like open office or lotus) What do you think if my best step forward?

非常感谢您的帮助！
回复或发送电子邮件给我
tom at坦诚的天空点com

Thanks very much for your help! Either reply or email me tom at candid sky dot com

推荐答案

http://phpexcel.codeplex.com/ =nofollow noreferrer> PHP Excel （不确定两个链接是否相同）和 PHP Excel Reader 。

Try out PHP Excel (not sure if both links are the same) and PHP Excel Reader.

这篇关于使用PHP解析Excel XML的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！