Software to represent multiple excel spreadsheet tables

[Razor88]

Hi guys

My cousin works for an NGO, and deals with thousands of spreadsheets. She was wondering if there was any existing software that allows you to represent excels tables in bar graphs etc. A web-based solution would be best (reading the sheets from a web-server and displaying it in a webpage)

And if not, what would the cost of developing something like this be?

I know this is a bit of a wishy-washy spec, but just trying to get a feeling about what's out there.

 

[XennoX]

Microsoft PowerBI.

It has an enormous selection of potential endpoints to connect to, one of them being a direct interface with with Excel spreadsheets. It is also pretty easy to work with, and she will feel right at home with its charting capabilities. If she has ever used Microsoft's Excel add-in, PowerQuery she will pick it up almost instantly. The software is free for personal use. If you want to natively publish the visualisations to the web, you need to pay. Microsoft does offer a 14 or 30 day trial for this service though - I cannot remember which.

 

[cyberbob1979]

Have you looked at Google Fusion Tables?

https://sites.google.com/site/fusiontablestalks/stories

https://www.google.com/fusiontables/

 

[scud]

Appsheets.com can read from sql, google sheets etc, and combine into a dashboard view on phones , otherwise something like jasperreports

 

[Oppiekoffie]

But can PowerBI etc read 1000s of sheets at one time? Might read one at a time, and user would still need to go through all? You get an excel OLE ? to develop, read and write to excel. Loop thorugh files, read rows column by column. Put in SQL or whicever db and create graphs/dashboard.