CODEWITHSUNDEEP
phpphpexcel
Faizan Tanveer
Faizan Tanveer

Reputation: 335

cant upload file using phpexcel issue with file path

i am currently using phpexcel library to read my excel file which is to be uploaded by user . but i cannot at this moment :(

i am using this code, i cannot get the file path right at this moment and if some one could tell me , how to over ride existing file and renaming the input file.

file is being transferred to folder , but i cant get the path name correct in this line $objPHPExcel = $objReader->load('upload/'.$test);can any one help me ?

move_uploaded_file($_FILES["file"]["tmp_name"],
"upload/" . $_FILES["file"]["name"]);
$test= $_FILES["file"]["name"];
echo "Stored in: " . "upload/" . $_FILES["file"]["name"];
require_once('classes/phpexcel.php');
$objReader = PHPExcel_IOFactory::createReader('Excel2007');
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load('upload/'.$test);
$objWorksheet = $objPHPExcel->setActiveSheetIndex('0') ;

kindly help and thanks in advance

Upvotes: 3

Views: 2293

Answers (1)

JellyBelly
JellyBelly

Reputation: 2431

I suggest you use another solution like this for example:

$objPHPExcel = PHPExcel_IOFactory::load("/upload/" . $_FILES["file"]["name"]);
$objPHPExcel->setActiveSheetIndex(0);

Upvotes: 0

Related Questions