QAds
Nikon D90 DX 12.3MP Digital SLR Camera with 18-105mm f/3.5-5.6G ED AF-S VR DX Nikkor Zoom Lens
$0.69
Nokia N8 Touchscreen Phone Beyaz - gps navigation, Voice Navigation, 12 MP Camera
$449.99
Nokia N8 Touchscreen Phone Siyah - gps navigation, Voice Navigation, 12 MP Camera
$449.99
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