Page 1 of 1

Problem in Import excel - Cell format

Posted: Thu Jan 29, 2009 4:49 am
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.

Re: Problem in Import excel - Cell format

Posted: Thu Jan 29, 2009 8:09 am
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