Cant read excel workbook data using excelReader

See more:

PHP

Hi,

I have a problem that my excel reader does not read the data from the excel file(with multiple sheets[some has hided sheets]) which excel version 2003. However if I copy and move all the sheets to a new workbook or save as the file as version 5.0/95. It works.

when delete some of the content its work too.


hence ,
1) how to delete the content of worksheet automatically if the worksheet content 'row' have the word"sample".(using php code,not using macro).

2) how to change the version of the excel workbook version.(is this possible?)

Is anyone know how to solve it? thanks .