HTML Table analysis
25/08/2012
This has to be one of the most interesting plugins for a web browser I’ve seen in a long time… perhaps since the advent of Flash!
This fantastic plugin takes an HTML table, allows you to analyse the data, & save the results in an xls format.
Mind blown!
Excel is my first weapon of choice at work; I may need to source data via SQL, but reporting happens & is distributed via this gem of MS office.
Now this javascript gives us the ability to extract & manipulate data straight from the web, mind buzzing at application possibilities.
Thinking MYSQL generated tables via PHP, with this script added, gives many options… & then there’re Fusion tables
For now here’s a table of the most popular games currently & the user rating: Chart
[excel-interactive-view]
| Rank | Title | Platform | Rating |
| 1. | Diablo III | (PC) | 87.60% |
| 2. | Papo & Yo | (PS3) | 72.00% |
| 3. | Transformers: Fall of Cybertron | (X360) | 82.33% |
| 4. | The Last Story | (WII) | 78.61% |
| 5. | Sleeping Dogs | (PC) | 86.44% |
| 6. | Counter-Strike: Global Offensive | (PC) | 84.20% |
| 7. | Transformers: Fall of Cybertron | (PS3) | 75.50% |
| 8. | Darksiders II | (X360) | 84.65% |
| 9. | Darksiders II | (PS3) | 85.35% |
| 10 | . Minecraft: Xbox 360 Edition | (X360) | 83.42% |
This plugin enables you to add Excel Interactive View (Excel Button) to any table. Excel Interactive View creates charts and filters from any table.
wordpress plugin
ExcelMashup Homepage