Tripredacus Posted November 25, 2020 Share Posted November 25, 2020 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. Twitter | MSFN | VGCollect Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted November 25, 2020 Moderators Share Posted November 25, 2020 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). TheDcoder and Tripredacus 2 "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! Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now