Spinning, exploding Excel-driven web app: How or should it be?
January 9, 2013 8:45 AM Subscribe
Sometimes, I am a front-end web developer. Frequently, I meet new people at work who want to turn really complicated Excel documents into dazzlingly interactive web applications.
Besides Excel's "Save to Web App" or "Save to SharePoint" features
, such people ask if I can tap into an industry to support this -- perhaps scads of agencies and web-based or downloadable tools that make "websites" or at least customizable, interactive reports from Excel spreadsheets, data, and calculations.
I'm yet to find this an abundance of examples of this. Are there? If so, what do you call them?
posted by metajc to Computers & Internet (2 answers total) 8 users marked this as a favorite
If you use Google Analytics, MailChimp or Hootsuite, you are familiar with bouncing, cheerful report graphs and charts.
I know that those specific tools required teams and years worth of custom programming. I assume that these apps also derive their presentations from databases that are not Excel files. People seem to passionately believe, however, that there has got to be an easy way to pour Excel spreadsheets into a machine that spits out more simplistic but nonetheless animated pie charts, line charts, map charts, bar charts, etc. You can customize the colors and fonts! Click here to add your logo!
For the sake of specification, say I have an excel file with multiple tabs. Each tab has thousands of rows and nearly 50 columns. The existing Excel charts are based on calculations of those tabs. Is there a web or intranet-friendly tool that will eat that spaghetti and excrete more colorful, JQuery-powered whirligigs?
I don't mean to come off as sarcastic to the believers or naive to those who know. It just seems a tall order to me. Hopefully, I'm wrong.