Hi all, I go through a regular search to parse excell file using PHP and finally I get the solution.
For this we need – excel foder, contains – oleread.inc and reader.php files.
<?
if(is_uploaded_file($_FILES['data']['tmp_name']))
{
$file_type_arr=explode(“.”,$_FILES['data']['name']);
if($file_type_arr[1]==”xls”)
{
ini_set(‘session.gc_maxlifetime’,86400);
require_once ‘Excel/reader.php’;
// ExcelFile($filename, $encoding);
$data = new Spreadsheet_Excel_Reader();
// Set output Encoding.
$data->setOutputEncoding(‘CP1251′);
$data->read($_FILES['data']['tmp_name']);
//Do the rest work with excell data
}
}
?>
Download – reader.php the parsing file.