Strategy for building an application to replace a large spreadsheet

Posted by Dan Walmsley on Programmers See other posts from Programmers or by Dan Walmsley
Published on 2012-01-18T00:17:45Z Indexed on 2012/03/31 11:41 UTC
Read the original article Hit count: 299

Filed under:
|

I'm working on an application that is going to replace a rather large spreadsheet. The spreadsheet is used to budget purchases and things like that. It is the largest spreadsheet I have ever seen, and it required a lot of manual data entry, so this application is going to automate much of that.

But as I'm working on this I've noticed its slow going. And I got to thinking this must be a common thing to do many companies will start with something like a spreadsheet, then when they get too big to maintain that, they will get a custom application built. So is there anything out there ( a framework or similar ) that does this sort of thing, migrating a spreadsheet to a custom application.

I've had a quick Google but not really seen the kind of thing that I'm looking for.

It's too late for this project, but I thought it would be worth having a look for next time.

How do you guys tackle this problem?

© Programmers or respective owner

Related posts about frameworks

Related posts about spreadsheet