Geek Answers Handbook

Parsing Excel XML with PHP

Introduction

I use excel downloads as a way for users to upload a score table, filling in points, and then reloading this score sheet into the system.

In part, this requires that the data in the database be placed in the CSV. Then it opens on the client computer.

PROBLEM

The problem I am facing is that CSV does not allow me to use the form of formatting. This includes hiding cells, highlighting text, etc.

Thus, parsing data in Excel (xls) format and from it makes more sense ... But from what I heard and read, it would be really difficult due to different versions of excel, etc. etc.

Question

I heard that XML is a good way to parse excel data. I was wondering if anyone has any experience using php?

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

Many thanks for your help! Either the answer, or write me Tom in the open sky dot com

+6
xml php parsing excel csv
source share
2 answers

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

+3
source share

I am sure that there are, for example, Perl modules that will help with XML, but also believe that the HTML table: <tr>, <td>, <th> tags will be opened by Excel and at least some of the formatting will translate into Excel

you just need to call it ... something.xls

0
source share

More articles:


All Articles