Jump to content

What to look into to replace a relative spreadsheet?

Recommended Posts

I am working on a project where files are rebuilt but the process is dependent on manual intervention in a spreadsheet. I want to be able to complete this complex task without having a spreadsheet and without having to have a copy of Office or some other program installed. The primary reason is that the files that are being manipulated are for a DOS program, and already I am imposing a limitation by building a 32bit AutoIT exe to handle it.

The part I am not sure about is what methods I should be looking at to replicate what the spreadsheet does, such as the fact that it uses the formula bar to calculate results based on relative cells on other sheets. What are some good alternatives that I can use instead? Such as using CSV, XML or something else, and more importantly I would also like to see a link to any specific implentation or breakdown of how to use it. For example, I am already familiar with using XML, but not as a way to make the data relational.

Share this post

Link to post
Share on other sites

What about a small sqlite db? I have moved a number of scripts away from using spreadsheets to sqlite, and am able to do calculations pretty easily (depending on their complexity of course).


"Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball

How to get your question answered on this forum!

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...