Simple Read XLSX and CSV file in PHP

Simple Read XLSX and CSV file in PHP

November 25, 2020

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());