PHP code for uploading Excel sheet

Question

scorpionz 1 Junior Poster

16 Years Ago

Hi this is scorpionz
I am uploading an excel sheet file using PHP
Now the file code is working fine for gif files but not working if i provive xls extension

Here is the php main code

<?php
	// include 'config.php'
	include 'uploadcode.php';
	
	if(isset($_POST['upload_file']))
	{
		$user_file			=	$_FILES["car_info_file"]["name"];
		upload_files($_FILES["car_info_file"]["name"]);
		
	}
	
?>

<body>
<form name="uploadfile" action="" method="post" enctype="multipart/form-data">
	<div class="upload-box">
		<div style='border-left-width:0px;border-right-width:0px;border-top-width:0px;border-bottom-width:1px;border-color:#C0C0C0;border-style: solid; background-color:#669900;text-align:center; width:'>
			<a href="#">Upload File </a></div>
		</div>
		<div>
			<table class="bodyBg" bgcolor="#333333">
				<tr>
					<td width="94" align><span class="style1">Upload Your Display </span></td>
		      		<td width="246"><input type="file" name="car_info_file" id="car_info_file" style="height: 19px; width:100px; font-size:87%;"/></td>
				</tr>
				<tr>
			 	 	<td colspan="2" align><input type="submit" name="upload_file" value="Upload" /></td>
	  			</tr>
			</table>
		</div>
	</div>
</form>
</body>

The above is the main file and in PHP block i am calling a PHP function with name upload_files.... and below is that php function code

function upload_files($fil)
{

if((!empty($_FILES["car_info_file"])) && ($_FILES['car_info_file']['error'] == 0)) {
  //Check if the file is JPEG image and it's size is less than 350Kb
  $filename = basename($_FILES['car_info_file']['name']);
  $ext = substr($filename, strrpos($filename, '.') + 1);
  //echo $ext;
  if (($ext == "xls") && ($_FILES["car_info_file"]["type"] == "text/xls" ) && ($_FILES["car_info_file"]["size"] < 2000000)) {
    //Determine the path to which we want to save this file
	 // $newname = 'C:\xampp\htdocs\online_shopping\uploaded_images\$filename';
	  $newname = 'C:\xampp\htdocs\hblcars\file_folder\\'.$filename;
     // echo $newname;
	  //Check if the file with the same name is already exists on the server
      if (!file_exists($newname)) {
        //Attempt to move the uploaded file to it's new place
        if ((move_uploaded_file($_FILES['car_info_file']['tmp_name'],$newname))) {
          // echo "It's done! The file has been saved and Uploaded as: ".$newname;
		   echo "<div style='background-color:#C0C0C0;color:#0099CC;font-weight:bold;text-align:center;'>It's done! The file has been saved and Uploaded</div>";
        } else {
           echo "Error: A problem occurred during file upload!";
        }
      } else {
         echo "Error: File ".$_FILES["car_info_file"]["name"]." already exists";
      }
  } else {
     echo "Error: Only .XLS files under 200000Kb are accepted for upload";
  }
} else {
 echo "Error: No file uploaded";
}
}

I think the Problem is here
if (($ext == "xls") && ($_FILES["car_info_file"]["type"] == "text/xls" ) && ($_FILES["car_info_file"]["size"] < 2000000))
because i am getting this error: Error: Only .XLS files under 200000Kb are accepted for upload

Thanks and Regards
Scorpionz

file-system microsoft-office php

15 Contributors
21 Replies
13K Views
7 Years Discussion Span
Latest Post 9 Years Ago Latest Post by SuperGOAT

nav33n 472 Purple hazed!

16 Years Ago

The problem is,

if((!empty($_FILES["car_info_file"])) && ($_FILES ==

and all will not be accessible inside the function. Instead, pass $_FILES as parameter for the function.

upload_files($_FILES);

Then you can access it in your function like,
$fil and so on..

Btw, type is application/xls..

jay4smile 0 Newbie Poster

15 Years Ago

I got......
Error: Only .XLS files under 200000Kb are accepted for upload

Then I remove $_FILES["car_info_file"]["type"] == "text/xls" ) && ($_FILES["car_info_file"]["size"] < 2000000)
from if condition

now file is uploaded but I got error like....

File is already exists..... :-)

Bachu 45 Newbie Poster

13 Years Ago

You can also use ,

//Upload excel file:
$_FILES["car_info_file"]["type"] == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" ...

Edited 11 Years Ago by Dani because: Formatting fixed

sruthisru 0 Newbie Poster

11 Years Ago

after this uploading i have to store the datas into database..how it possible?

Bachu 45 Newbie Poster

11 Years Ago

Hai;

I think the below example will help you

<?php
if(isset($_FILES["txtFile"])) {
$allowedExts = array("doc", "docx", "txt", "pdf");
$extension = end(explode(".", $_FILES["txtFile"]["name"]));
$message = "";
if ((($_FILES["txtFile"]["type"] == "application/vnd.openxmlformats-officedocument.wordprocessingml.document")
|| ($_FILES["txtFile"]["type"] == "application/pdf")
|| ($_FILES["txtFile"]["type"] == "application/msword")
|| ($_FILES["txtFile"]["type"] == "text/plain"))
&& ($_FILES["txtFile"]["size"] < 2000000)
&& in_array($extension, $allowedExts))
  {
  if ($_FILES["txtFile"]["error"] > 0)
    {
    $message.= "Return Code: " . $_FILES["file"]["error"] . "<br>";
    }
  else
    {   
    $tempFile = $_FILES['txtFile']['tmp_name'];
    $targetPath = 'admin/images/uploads/CV/';
    $newFileName =$_FILES['txtFile']['name'];
    $targetFile =  str_replace('//','/', $targetPath) . $newFileName;

    $cpy=1;
    do {


        $targetFile =  str_replace('//','/',$targetPath) ."Copy".$cpy. $_FILES['txtFile']['name'];
            $fileName="Copy".$cpy. $_FILES['txtFile']['name'];
            $cpy++;
        }while(is_file($targetFile));

        move_uploaded_file($tempFile,$targetFile);

        //here you can call your database and set up your insert query..
        //in this example I use an oop's for insert data
        $myObject->insertDataFunction(addslashes($_REQUEST['txtname']),addslashes($_REQUEST['txtemail']),($_REQUEST['txtPhone']),addslashes($_REQUEST['txaComments']),$fileName,$_REQUEST['id']);
        }
        ?>

Edited 11 Years Ago by Bachu because: text correction

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

scorpionz 1 Junior Poster · Answer 1 · 2008-06-04T08:32:42+00:00

Thanks Naveen for Replying
But the things u told are not making any effect

in fact let me clear to you that if i use this line as image

if (($ext == "gif") && ($_FILES["car_info_file"]["type"] == "image/gif" ) && ($_FILES["car_info_file"]["size"] < 2000000))

It does work

but not working with this below

if (($ext == "xls") && ($_FILES["car_info_file"]["type"] == "application/xls" ) && ($_FILES["car_info_file"]["size"] < 2000000))

I use this

upload_files($_FILES);

But no benefit at all....

IF you have some better code send here in which it covers all type of files with Sizing issue i am also not comfortable with sizing issue

Thanks and Regards
Scorpionz

vaishnmd 0 Newbie Poster · Answer 2 · 2011-03-15T22:41:11+00:00

Hi,

I guess this might come late, but i just figured out what is wrong...

$_FILES["car_info_file"]["type"] == "application/xls"

should me changed by

$_FILES["car_info_file"]["type"] == "application/vnd.ms-excel"

I have been googling, and looks that is the problem, since a MS-excel document has a specific type of file.

Hope I've helped :)

Vaishali

nikleshpatel 0 Newbie Poster · Answer 3 · 2012-08-22T12:42:08+00:00

plz give me coding for only excel file accept in php......

plz help me.....

nikleshpatel 0 Newbie Poster · Answer 4 · 2012-08-22T12:42:44+00:00

nikleshpatel 0 Newbie Poster

12 Years Ago

plz help me ....

ThomasVI 0 Newbie Poster · Answer 5 · 2012-09-10T15:03:41+00:00

Are you trying to upload files of the extention of only xls, xlsx or both?

daddsdsd 0 Newbie Poster · Answer 6 · 2012-12-12T06:57:36+00:00

daddsdsd 0 Newbie Poster

11 Years Ago

dsa

Karandeep123 0 Newbie Poster · Answer 7 · 2012-12-24T06:08:56+00:00

how to set online path for above function..??

$newname = 'http://localhost/sirfpaisa-newone/admin//'.$filename;

instead of

$newname = 'D:\wamp-new\www\sirfpaisa-newone\admin\\'.$filename;

nandakishore22 0 Newbie Poster · Answer 8 · 2013-07-16T06:58:19+00:00

To anyone who had been wonderstruck about some files being easily uploaded and some not, it could be a size issue. I'm sharing this as I was stuck with my PHP code not uploading large files and I kept assuming it wasn't uploading any Excel files. So, if you are using PHP and you want to increase the file upload limit, go to the php.ini file and make the following modificatons:

upload_max_filesize = 2M

to be changed to

upload_max_filesize = 10M
post_max_size = 10M

or the size required. Then restart the Apache server and the upload will start magically working. Hope this will be of help to someone.

sruthisru 0 Newbie Poster · Answer 9 · 2013-09-27T06:53:44+00:00

okei thank u soo mchh..i'l work it and confirm..
by the way am having another doubt is that..how it is possible by accesing the database datas into excelsheet..
i need to download the excel sheet from the webpage itself.
plz help me

uttkarshsing 0 Newbie Poster · Answer 10 · 2013-09-27T11:28:22+00:00

uttkarshsing 0 Newbie Poster

11 Years Ago

Nice its working....

Bachu 45 Newbie Poster · Answer 11 · 2013-09-27T11:39:17+00:00

Hai;
@sruthisru
Check this link
Click Here

sruthisru 0 Newbie Poster · Answer 12 · 2013-09-27T15:50:39+00:00

sruthisru 0 Newbie Poster

11 Years Ago

i ddnt get this :(

sruthisru 0 Newbie Poster · Answer 13 · 2013-09-28T07:46:42+00:00

sruthisru 0 Newbie Poster

11 Years Ago

:(

diafol · Answer 14 · 2013-09-28T08:19:51+00:00

See Bachov's link and use his code or check the link in the last post

Mattias 0 Newbie Poster · Answer 15 · 2015-06-06T13:38:03+00:00

Here is an example

<?php 

if(isset($_POST["submit"])) {

    $target_path = "uploads/";
    $target_path = $target_path . basename( $_FILES['fileToUpload']['name']); 

    if ($_FILES["fileToUpload"]["type"] == "application/xls" or $_FILES["fileToUpload"]["type"] == "application/vnd.ms-excel" or $_FILES["fileToUpload"]["type"] == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"){
        if(move_uploaded_file($_FILES['fileToUpload']['tmp_name'], $target_path)) {
            echo "The file ".  basename( $_FILES['fileToUpload']['name']). 
            " has been uploaded";
        } else{
            echo "There was an error uploading the file, please try again!";
        }
    }else{
        echo "This is not an excel file, please try again!";
    }
}
// nexxoz.com
?>
<!DOCTYPE html>
<html>
<body>

<form action="" method="post" enctype="multipart/form-data">
    <p>Select excel to upload:</p>
    <input type="file" name="fileToUpload" id="fileToUpload">
    <input type="submit" value="Upload Image" name="submit">
</form>
</body>
</html>

SuperGOAT 0 Newbie Poster · Answer 16 · 2015-06-06T14:58:06+00:00

What PHP code for uploading Excel sheet ???? good anwer,..