I
I
Ivan Eliseev2018-10-23 14:10:28
excel
Ivan Eliseev, 2018-10-23 14:10:28

How to automatically create an Excel spreadsheet from a completed form?

Hello!
The task is to speed up the process of filling out the TOR.
Already made the script of filling.
1. Indication of the first parameters. Either yes/no, or number.
2. Indication of the second parameters. Title + space occupied (in numbers)
3. Fill in the main parameters, based on the first.
Scenario:
1. Horns yes/no (yes indicated)
2. Hooves count (three hooves)
3. Horns are selected
4. How many hooves to assign to horns is selected
Next, about what should be the output.
So far, there is only a manually created table.
But it just became uncomfortable, constantly redoing it. So I want to make the filling process automated.

Answer the question

In order to leave comments, you need to log in

4 answer(s)
A
Alexander, 2018-10-23
@NeiroNx

You can create a file in python, the xlwt library.

I
idShura, 2018-10-23
@idShura

Freelancing here

S
Saboteur, 2018-10-23
@saboteur_kiev

1. Learn any (well, almost any) programming language and write a script for autocomplete and export to Excel.
2. Write your wish for freelancing, pay, they will write to you.

E
Eugene Kuznetsov, 2018-10-26
@KEugene

If you need a form for entering data and there is no desire to learn a language or pay, then you can use Access, where you can create an input form (well, you have to read a little). If the use of Excel is important, then you can then connect to this database from it in a couple of clicks.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question