How to display top 3 results from excel file in wordpress page?

Question

excel

Hello. There is a site on wordpress and there is an excel table with a rating of leaders.
Tell me how you can display the names of 3 winners from the file on the page based on the result of the maximum value in the column? Are there ready-made plugins or functionality for this?

Answer 1

The task is really individual...
1) You need to somehow "read" the excel table on the server, ie. you need to parse the data into columns. Look for libraries for this.
2) You need to get the data (results), compare them and find the 3 max values ​​and their corresponding names.
3) we make the whole thing into a plugin .. you can not bother much and create a mu-plugin.
4) test the result.
As for the "invisible table" etc. you mentioned, not immediately. Those. in fact, you need to give the excel table to the client side, then parse the table with js, and then display the result ... This is not it.
phpexcel instruction - https://www.youtube.com/watch?v=eprwBD9RT-Q
Google php excel reader and you will find a bunch of libraries:
https://github.com/nuovo/spreadsheet-reader
https://github.com/Janson-Leung/PHPExcel
https://code.google.com/archive/p /php-excel-reader/

Answer 2

Too individual task to write a plugin
Look towards phpExcel (google is rich in links)
Open the file and display what you need