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]

RankTitlePlatformRating
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