Simple Read XLSX and CSV file in PHP

 here is the code and the library file is attached below.

Library File is here:- Download from here

https://drive.google.com/file/d/1fNXtQQbmnII5P7_CZ4EUulaazoPfuz-b/view

To Read CSV: 

$FileURL = 'testfile.xlsx';

require_once "lib/parsecsv.lib.php";

$csv = new parseCSV($FileURL);

echo "test<pre>";

print_r($csv->data);

To Read XLSX: 

$FileURL = 'testfile.xlsx';

require_once "lib/SimpleXLSX.php"

$xlsx = SimpleXLSX::parse($FileURL);

echo "test<pre>";

print_r($xlsx->rows());

Popular posts from this blog

How to open cPanel using WHM access.

Image
Login into your WHM Page Click on Account Information in Dashboard Click on List Accounts Now here you will see your listed website. Click on cPanel icon  on which cPanel you want to open your site.It will redirect to your site cPanel Page without login information. That's it Enjoy!!!
Read more

Cant use dump() function in twig files or how to enable debug in opencart twig or print_r alternate use dump() in opencart 3.0

if you are facing the following problem. Cant use dump() function in twig files  or  how to enable debug in opencart twig  or  print_r alternate use dump() in opencart 3.0 for fixing this problem follow these steps You can activate dump() function for twig environment by following these steps in opencart 3.0 : Go to system/library/template/Twig/Environment.php Here in the constructor function, you can find $options array . Set 'debug' option to 'true' . Now we need to include debug extension, so add $this->addExtension(new Twig_Extension_Debug()); below. Now you can use  {{ dump(your_variable_name) }} as print_r variable in php That's all 😅😆😛
Read more