PHPExcel Tutorial - Read an Excel File (.xlsx)

How to use PHPExcel to read xlsx (or xls) file on the server and display the data on the webpage

[amysemanek]

It is so nice to have a simple clear explanation on how to do this stuff. Thank you!

[alikhanbaidussenov]

Yo, one of the most helpful and clear videos I've seen on this platform. Many thanks!

[andystath]

So much simpler than other methods I have seen. Thank you.

[sztolaz]

thank you for this video! I was searching for this informations around 2 months :D

[IsaSoandso]

Seriously wish I had this when I first started using PHP Excel, well done, great handle as well, lol

[cesarparra]

gracias parcero por los videos, muy buenos todos.

[Ariel_Fernandez]

Thanks but, you must zoom to the code, nothing of your code can be seen, I needed just this but I could see the code.

[asiaC]

If your excel file doesn't have this structure, how can you do it? Because an excel file does not always have that database type structure, sometimes there are reports ...

[asrinivasareddy]

Thank you so much for this tutorial It help me a lot

[excption]

Hello, I use a drop-down list on Excel and I would like to be able to retrieve the values ​​and not the keys of it. Can you help me? for example
1 = drop-down
2 = list
I would like to retrieve the "drop-down" or "list" values. Thank you.

[carlosgodinez]

This course has helped me a lot, but I would like to know how can I read filtered data (NOT ALL THE DATA) from the Excel File, for example: You have 20 registers in the Excel File:

Code | Product Name
1 | Fish
1 | Notebook
1 | Wine
1 | Juice
1 | Pen
1 | Book
...
2 | Computer
2 | Wallet
...

NOTE: (Code and Product Name are columns...)

And you know you can filter by something in the Excel file, and I'm filtering by CODE and I will get all the registers with CODE = 1, imagine that the registers that have CODE = 1 are 10.
So...

There's any way to get just the registers that have the CODE = 1 and ignore the other ones with CODE = 2 from the Excel file? DON'T CONFUSE WITH THIS CONDITION:

!= 2) {...

I'M REFERING TO THE FILTERS INTO EXCEL, WHERE YOU CAN DISPLAY SOME DATA THROUGH BY FILTERS....

[valiantcolumnar]

thank you this is amazing!!! and is it also possible to open and launched the specify excel file instead doing that way?

[Mr.Smith_]

It doesnt work. I dont have the PHPExcel.php because the project is deprecated. Can someone send me pls?

[PinoMancinelli]

how can I add up an entire column?
I would like the sum of this column
echo

Thanks

[anushagadepalli]

does it require configuration file shows that it cannot open the file

[rubykanima]

what is require_once "Classes/PHPExcel.php"; standing for

[jatinsapariya]

This Example is not working live server...pls help...me

[adityagaikwad]

this thing is not working, does it requires anything more related to configuration.

[anagila]

Hi, Implement this code and read the .xls, but the .xlsx does not read it, does it require some configuration on the server (IIS) for php?

[ksureshnair]

Just one doubt..I have a cell which is having a user defined function. Can i get the calculated value on my web page? I have an excel add-in. The function is defined in that add-in. Is it let me know..