How to read the values from excel sheet in PHP and store them in variables or arrays?

Question

I want to take excel sheet from user through HTML form and then in PHP read the excel sheet and store its value in an array. Please explain me how to do so. Also I tried using PHPExcel and SimpleXLSX but it gave no result and I also tried using phpspreadsheet or phpexcelmaker but it gives result only for .xls files and not for .xlsx files. I want the code to give result for both .xls and .xlsx files.

Answer 1

Better use csv format instead. It is in text format. Convert excel to csv...

Answer 2

mir

Answer 3

hossin