[SOLVED] php API's to read Microsoft Excel rows/columns

[arianhojat]

I was looking for classes to read and write Excel files in php.

Didnt seem to find anything built into php, but found 2 separate projects...

For reading an Excel file:

www.sourceforge.net/projects/phpexcelreader

 

and for writing an Excel file:

www.pizzaseo.com/php-excel-creator-class

 

The writing part works perfectly.

However the reader tries to see what excel data format the cell is in, and tries to format it.

It goofs alot on dates...

For example if a column has data of 9/30/2006 then it gives you a value  of 29/09/2006.

It would be nice to get the value without formatting, but unfortunately nothing i try works.

 

anyone have any new php API's that read Excel files (easy API's to read rows/columns)?

 

Thanks in advance.

 

 

[cmgmyr]

Check out what I posted here: http://www.phpfreaks.com/forums/index.php/topic,133807.msg563168.html#msg563168

 

hope that gets you started.

[emehrkay]

$f = fopen($file, 'r');

while ($row = fgetcsv($f)) {

}

 

fgetcsv and fputcsv are built into php to handle csv files

[arianhojat]

cool, thanx to both of you