Need advice on creating a program to manipulate word and excel document

Im in need of creating a program which could get data on an excel file then automatically fill a table inside a word after that the table data would be processed with formula and used to create another conclusion table in a new page of the same file (so word and excel file as input and the output is word with conclusion table and filled table data),

which language should i use and is there any module/package to do this? any help/advice is really appreciated. Thankyou

Python can help, I think. Maybe you could benefit from this book:

If you need more basics, before that, you could do the python certificates in the freecodecamp curriculum

2 Likes

Visual Basic for Applications (VBA) would be the easiest to use to accomplish something like this.

1 Like

Thankyou very much, i do a little bit of research on python-docx which seems to be used for this but i still dont know if it could satisfy the need, since i need to write a text inside a specific table etc, i still havent found the way yet, can this module do that? thanks again

I have no experience with this