How to open an Excel file in PHP?

php import-from-excel
Click Upvote picture Click Upvote · Mar 18, 2009 · Viewed 12.9k times · Source

How can an excel file be opened, all cols/rows read in an array etc the same way .csv files can be? Is there any built in libraries/classes for that in php?

Answer

jonstjohn picture jonstjohn · Mar 18, 2009

I've use the PHP Excel Reader

and here is a Good Write-up From Zend

Related questions

Reading an Excel file in PHP

I'm trying to read an Excel file (Office 2003). There is an Excel file that needs to be uploaded and its contents parsed. Via Google, I can only find answers to these related (and insufficient topics): generating Excel files, reading Excel …

Read More
Excel date conversion using PHP Excel

i am reading date from excel which is in this format 12/5/2012 day/month/year using this code to read . using PHP EXCEL PHPExcel_Style_NumberFormat::toFormattedString($value['A'],'YYYY-MM-DD' ); its working like charm converting the above date '12/5/2012' to …

Read More
How do I read sheet two of an xlsx file with PHPExcel?

I know how to read my xlsx spreadsheet and loop through the first sheet. It has 5 sheets and I am having trouble getting to any other than the first. Here is the code I am using which was straight from …

Read More