Beginner trying to create a program to prompt user for data and then save to excel
I have been working on coding for about 2 months now, I started with some free online tools and then got the Python Crash Course by Eric Matthes. My long term goal is to set up a program that will prompt the user with preset questions, take the answers and save them to an Excel spreadsheet that I have already filled out with other information. So basically I want to fill out a form on a spreadsheet but have the interface ask me each question.
I'm not asking exactly how to do this, but I am trying to figure out what programs I will need to make this happen. I'm sure I will need Pyexcel, but i'm not sure about what to use for an interface. Or would it be easier/more efficient to make a web app?
Any information on this would be great and I thank you already for taking the time to take a look at my project idea.
Comments
Hi Wilson,
You have to start we something simpler, read some more / watch some youtube - then write down the requirements - split it up in simpler tasks - each step closer to the final result.
This is the simplest way to do Proof Of Concept programs - when you write them for "real" you need to consider a lot more.
The best to learn from is "Uncle Bob" https://blog.cleancoder.com
Whenever you write a program - remember that the path of "dirty" programming is not your path - you will use more time in the beginning on simpler tasks - but people will recognise your skills later on!
I forgot!
Happy programming!