QAds
Apple iPad 64gb Wi-Fi 3G
$0.78
Apple iPad 32gb Wi-Fi
$548.97
Coby MP305-2G MP3 Player
$12.98
Coby 2.8-Inch LCD Touchscreen Video MP3 Player
$52.49
:: HOME PHP How To Read Excel File
 
How To Read Excel File

If you want to read an excel file with PHP you can use script below.

I want to explain how to use it. at first, copy codes below and paste in PHP file.

 

you just need to include reader.PHP file into your code :

require_once 'reader.PHP';

 

dont forget that reader.PHP file requires oleread.inc file.

after that  you need to describe class and then read the file:

    $data = new Spreadsheet_Excel_Reader();
    $data->setOutputEncoding('CP1251');
    $data->read('myExcelFile.xls');

thats it. After that you can start to read your excel file:

$data->sheets[1]['cells'][2][3];

by this way you can read any cell from excel file. what you need to determine which sheet, which row and which column.

$data->sheets[SHEET]['cells'][ROW][COLUMN];

you need to put 0 for first sheet, 1 for second sheet. 1 for first row of sheet and 1 for first column of row.

 

thats it

 

oleread.inc file

www.bounmis.com/files/oleread.inc.txt

 

reader.PHP file

 www.bounmis.com/files/reader.txt