Problem in Import excel - Cell format

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
akwok
Forum Newbie
Posts: 1
Joined: Thu Jan 29, 2009 4:28 am

Problem in Import excel - Cell format

Post by akwok »

Hi All,

I want to read the cell format from an excel file(e.g alignment, border setting, size, bg/fg color, date/number format etc.).
I tried the spreadsheet excel reader class but find out it can only read the text but not these formats.
If I am wrong and the "spreadsheet excel reader" can actually do the job, can anyone plz plz give me an example.

On the other hand, I am now thinking of reading in a XML excel file to get the cell formats.
Is there any class available for retrieving the EXCEL XML cell Format ??
I found a class called "Excel xml Parser". However, it only works to the level of cell content but not the cell formats.

If there are any other suggestions on reading the excel cell format, please let me know. Thx in advance.
Mark Baker
Forum Regular
Posts: 710
Joined: Thu Oct 30, 2008 6:24 pm

Re: Problem in Import excel - Cell format

Post by Mark Baker »

akwok wrote:If there are any other suggestions on reading the excel cell format, please let me know. Thx in advance.
PHPExcel can both read and write xls and xlsx workbooks, with formatting and calculations
Post Reply