Parse Excel sheet through PHP script

[pushya]

Hi everyone I am just joined this and new in PHP.I have a PHP script which reads data form Excel sheet but there are certain changes needed like it does not reads formats like negative values from sheet. Can anyone please suggest me the best solution for reading Excel sheet in Unix. Also I want to convert it in pipe delimited format.

[Motoma]

Hi everyone I am just joined this and new in PHP.I have a PHP script which reads data form Excel sheet but there are certain changes needed like it does not reads formats like negative values from sheet. Can anyone please suggest me the best solution for reading Excel sheet in Unix. Also I want to convert it in pipe delimited format.

Is the file in the excel format, or is it comma or tab delimited? You can find out by opening it up in a text editor; if the first line is garbage, then it is Excel format.

Let us know, and welcome to The Scripts.