Home General

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

  • Michael_ThomsenMichael_Thomsen See you at https://www.mirandapartners.com or contact me at [email protected]

    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!

  • Michael_ThomsenMichael_Thomsen See you at https://www.mirandapartners.com or contact me at [email protected]

    I forgot!

    Happy programming!

Sign In or Register to comment.