Problem in Import excel - Cell format
Posted: Thu Jan 29, 2009 4:49 am
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.
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.