How to connect Excel with PHP

[smchauhan]

I am working as a web developer, I want to know how to connect any excel sheet with php to show records from the spredsheet.

[ak1dnar]

Moving Thread from PHP Articles – Ajaxrand

[ak1dnar]

Hi there,

Welcome to TSDN.

for now you can refer to these links.
Class: MS-Excel Stream Handler
Class: Excel Reader

If you are not in a rush I might be able to find out more solutions for you.

Thanks!
-Ajaxrand

[Rhishabh07]

my code

<?
//include("../mysqlconnect.php");
$link = mysql_connect("localhost","root","")
or die("Could not connect: " . mysql_error());
mysql_select_db("suma");
 
include("include/upload.inc.php");
if(isset($_POST['upload']))
{
$deli=$_POST['delimeter'];
 
$userfile=$_FILES['userfile']['name'];
$userfile_tmp=$_FILES['userfile']['tmp_name'];
$userfile_type=$_FILES['userfile']['type'];
$userfile_size=$_FILES['userfile']['size'];
$dir="upload";
$filename=basename($userfile);
move_uploaded_file("$userfile_tmp","$dir/$filename");
$row= 1;
$fp = fopen("$dir/$userfile", "r");
$s="";
$s1="";
$s2="";
 
while (($data = fgetcsv($fp, 100000, "$deli")) !== FALSE) 
{
$num = count($data);
$row++;
if($row==2)
{
for ($c=0; $c < $num; $c++) 
{
$s.=$data[$c]." VARCHAR (200) not null,";
$s2.=$data[$c].",";
$s1.="'$data[$c]',";
}
echo $sql="create table temp1(id int(20) not null auto_increment,".$s."extra varchar(200) not null, primary key(id))";
mysql_query($sql)or die("could not create");
 
$sql1="insert into temp1 (".$s2."extra) values (".$s1."'choose')";
mysql_query($sql1)or die("could not insert");
}
 
if($row > 2)
{
$s1="";
for ($c=0; $c < $num; $c++) 
{
$s1.="'$data[$c]',";
}
$sql2="insert into temp1 (".$s2."extra) values (".$s1."'choose')";
mysql_query($sql2)or die("could not insert");
} 
}
 
fclose($fp);
}
 
?>
 
<table>
 
<form action="" method="post" enctype="multipart/form-data" name="form3" id="manu">
 
<tr class="greyBG"> 
<td width="60%" height="33"> <div align="left">Please Enter the delimeter 
</div></td>
<td width="40%"><input type="text" name="delimeter"> </td>
</tr>
<tr><td>Upload CSV file</td><td><input name="userfile" type="file"></td>
 
 
 
 
</tr>
<tr><td colspan="2"> <input type="submit" name="upload" value="upload"></td></tr>
</form>
</table>
 

[ak1dnar]

Hi,
from your Original post you have asked about "showing records from Spreadsheets".

I am working as a web developer, I want to know how to connect any excel sheet with php to show records from the spredsheet.

Now What is this php script?