[PHP Tutorial] Read Excel File with PHP The Easiest Way to Read Excel Files Through PHP

Tech Village

7 лет назад

24,337 Просмотров

Скачать видео

Комментарии:

@Abhishekverma-cr8qf - 05.07.2022 10:13

not working on live please help facing issue : PHPExcel_Reader_Excel2007->canRead('/tmp/php5fjarY')

Ответить

@Ariel_Fernandez - 26.02.2021 07:38

Thanks friend, your audio is terrible, nothing is understood, thanks anyway

Ответить

@Tr-Sherlock - 08.10.2020 03:21

Thanks for sharing.
Convert from Excel to Html Table with Ajax

html page:
add Jquery
<input id="excelFile" type="file" name="excelFile" />
<button id="upload">Tablo Oluştur/Table Create</button>

Ответить

@Niltonufcg2009 - 24.09.2020 05:07

Great!!! Thanks!

Ответить

@mukeshcodelearn - 11.06.2020 10:22

Useful and simple thank you

Ответить

@ahmedabobaker8701 - 11.07.2019 10:06

how can I use it to read Arabic characters

Ответить

@ahmadlone - 11.05.2019 19:18

Thank you dear its working fine, but i have multiple sheets in excel file, how can i get data of all sheets

Ответить

@HoodCoderMan - 12.03.2019 17:07

Can you please take me off speakerphone?

Ответить

@DidikMulatoRFP - 03.11.2018 17:35

help me, this script not running on new VPS. on my old server running well.

Ответить

@ashwanibhardwaj2581 - 22.10.2018 19:55

please help me

Ответить

@ashwanibhardwaj2581 - 22.10.2018 19:55

no display of json data

Ответить

@ashwanibhardwaj2581 - 22.10.2018 19:54

this is my code

<?php
require_once 'Classes/PHPExcel/IOFactory.php';
if(isset($_FILES['excelFile']) && !empty($_FILES['excelFile']['tmp_name'])){

$excelobject = PHPExcel_IOFactory::load($_FILES['excelFile']['tmp_name']);
$getSheet = $excelobject->getActiveSheet()->toArray(null);

echo '<pre>';
echo json_decode($getSheet);
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Excel Reader</title>
</head>
<body>
<form action="" method="POST" enctype="multipart/form-data">
<input type="file" name="excelFile">
<input type="submit" value="Submit">
</form>
</body>
</html>