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