Help with Decision about Searchable Table Viewer Tool

[tbruce]

Hi All,

I'm trying to figure out the best path to take here and I've had so many great responses to my excel questions, I thought I would reach out here to try and get started. What I'm trying to figure out is what is the best path to achieve the following:

Searchable Table Viewer Tool:

• Need to create a table viewer for already existing data that is stored in Excel worksheets. I am willing to move the Excel data into a DB of some sort
• Need to render the viewer on a WordPress site
• Need a drop-down to select the specific dataset (have 50+ different Excel worksheets that will amount to different datasets)
• The viewer will need to be in table format, where each column has a search feature that will render the search parameter after typing the value (render multiple rows with same value (e.g. all first names of Dave or a single unique row)
• Need to be able to sort each column value (lowest to highest and visa-versa)
• Need to be able to render as default 25 entries (results) per page or show more if desired (25, 100, 1000)
• Need to have the ability to select specific lines of data or ALL lines and export to CSV
• Show page count if more than the minimum entries
• First Previous Next Last buttons to scroll through the pages if more than 1 page

I'm just looking for the easiest way to get this up and running, with either a PHP generator tool or perhaps even a WordPress plug-in, or via Access if I can render the viewer in WordPress.

Attached is an example screen shot rendering of what I'm trying to create (sorry for the small size). I searched for several days looking for the right tool and direction here and just can't seem to get there. Any guidance, direction where to start would be much appreciated. If you are interested in building this for me I would love to talk with you.