Read data from excel sheet in php

Question

I am using this code for reading data from any file but if i want to read data from excel sheet then what should i do?

<?php if(isset($_POST['submit'])){ $cir="certificate"; if(!is_dir($cir)){ mkdir($cir); } $image1=$_FILES['cir']['name']; $image=$_FILES['cir']['tmp_name']; $server_path=$cir.'/'.basename($_FILES['cir']['name']); $s=move_uploaded_file($image,$server_path); if($s){ //echo "successfully uploaded."; $file_open=fopen("$cir/$image1","r"); $file_read=fread($file_open,filesize("$cir/$image1")); echo $file_read; //$data = substr(strrchr("$cir/$file_read", ","),5 ); echo $file_read; }else{ echo "problem in uploading."; } } ?> <html> <body> <form name="form" method="post" enctype="multipart/form-data"> <input type="file" name="cir" /><br /> <input type="submit" name="submit" value="submit" /> </form> </body> </html>

Excel sheet containing various shells like Name-XYZ, s.no-123 etc. I want that xyz should be put on a variable and 123 should be on another variable. What will be code in PHP?

Varinder Singh · Accepted Answer · 2013-01-16 07:11:30Z

2

You can use PHPExcel library for same.

answered Jan 16, 2013 at 7:11

Varinder Singh

1,6201 gold badge12 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dennis · Accepted Answer · 2017-11-21 14:47:32Z

1

If your site involves reading excel files extensively then go for a library like https://github.com/PHPOffice/PHPExcel . It supports both xls and xlsx types.

edited Nov 21, 2017 at 14:47

Dennis

8,15112 gold badges75 silver badges121 bronze badges

answered Jan 16, 2013 at 6:57

SachinGutte

7,0655 gold badges38 silver badges59 bronze badges

2 Comments

Néstor Over a year ago

actually it doesn't read/write xslx file types. for those types is better PHPExcel

SachinGutte Over a year ago

Yes (as I said). For reading purpose mentioned lib is good as PHPExcel is heavier just for reading purpose. :)

Collectives™ on Stack Overflow

Read data from excel sheet in php

2 Answers 2

Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Related