Read an Excel file from PHP?

Thank you itsbobbs for the info. I did manage to setup phpExcelReader, and it worked perfectly. Nevertheless, the only issue that I have with this is that when it displays the table, it still uses the row and column headers (i.e. A, B, C, ... and 1, 2, 3, ....). Now I am not very familiar with PHP or coding in general, but my intended target is to treat my first row as the header for the table. Is there a way to do that? any suggestions?

 

Thanks it is really helpful,before that I tried too many ways to do the same thing and found no way better than this. I want to commit that I am Lucky to find the best solution.

 

i just download the code, i will share soon

 

The code provided here works fine, but I am having problem with getting number of rows present in excel sheet.
When I am working with the given code the maximum number of rows shown was 83. But the excel file has more the 83 rows and other rows are not shown.
Please help..

 

I am not able to read a excel file with an extension .xlsx . I am using the same library file. Please help me . I am waiting for you reply.

Thanks in advance

 

You'll need a library that has excel 2007 support, you can try http://www.codeplex.com/PHPExcel

 

Hi all

The excel file reader is great and its working for me as I was expected.

The only problem I am facing is that My excel file is in multiple languages. column D to R represent the text translation of text present in column c (in English). I want to read the correct text in to foreign language and insert it in to mysql DB.

When I try to change the character set the excel reader is only able to read few column for others its printing empty.

How can I fix this problem??

any help is much appreciated.

Thanks in advance
KK

 

Hi all
i had downloaded phpExcelReader and opened the file up. All seem to work fine except receiving this error:
Deprecated: Assigning the return value of new by reference is deprecated in C:\Program Files\www\Excel\reader.php on line 124.
I had no idea how to fix this problem. Also when i view the ExcelRead.php, only 5 rows were shown. How am i suppose to increase the number of rows if i needed? Please advise..

thank you.

 

HI to all,
I used the files for importing the excel file...i need to know about how to store the excel records to mysql database from front end....please help me in that..

 

I have the same problem, when i was working with excel, but thanks to php classes , i found a class (Native php class), by using that it solved my problem..you can try that it will help you out..

visit here: http://www.phpclasses.org/package/6235-PHP-Parse-and-access-binary-Excel-files-in-pure-PHP.html
Thanks

 

I have the same problem but i deleted character "&" on line 124. Then, all seem to work fine.

 

<?
include 'Excel/reader.php';
$excel = new Spreadsheet_Excel_Reader();
$excel->read('clientlistnew.xls');
$x=2;
?>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="5">
<?
$k=1;

while($x<=$excel->sheets[0]['numRows']) {
$y=1;

$cell = isset($excel->sheets[0]['cells'][$x][$y+0]) ? $excel->sheets[0]['cells'][$x][$y+0] : '';
$cel2 = isset($excel->sheets[0]['cells'][$x][$y+5]) ? $excel->sheets[0]['cells'][$x][$y+5] : '';





$sql1 ="update globe_clientmaster set ref_area ='".$cel2."' where clientid = '".$cell."'" ;
echo $sql1."<br>";
// echo $sql1."<br>";
//$res =mysql_query($sql1) or die("Error in Table".mysql_error());
//$cid = mysql_insert_id();




?>

YOu will get reader.php file from google its common class

 

it read only word "xls" 97-2003 format do something for word 2007 or xlsx format

 

All solutions is good only for small files.
If you want to read more than 10 000 rows without "out of memory" you can try to use XLS API parser
See documentation. http://noxls.net/documentation its easy.

 

He specifically asked IN php... You gave him an answer which requires learning a completely new language.

 

you can use https://phpexcel.codeplex.com/ is this too hard
you can convert as 'csv' and read it
that it easy