Hartkeye
Coder
Hello, i've come up with an idea for my very first project in python, and have some questions about formatting the data in an efficient way prior to writing the code for it. I want to be able to take data from tables i've created in an Excel file, and based on those data points, create a word document that implements the data in the correct place. Think of this as an interactive ad-lib book.
Example: one data table has subject information (Name, DOB, Address, etc.) The program would pull that information, insert it into a pre-written paragraph, and enter it into the word file. Another table has vehicle information, and would take data from the table and put it into a different pre-written paragraph. This would continue until the full report is completed.
My question: In writing the pre-written paragraphs, I've started to think about how annoying it would be to pre-write several different full report templates, and instead have the program be able to determine if a paragraph is put into the report based on whether or not a table exists for that section at all.
-would it be more efficient to have the program find the correct doc based on the data available and fill it in, or would it be more feasable to have the pre-written paragraph in the program itself to avoid searching several documents, and just print based on the data available within the program itself?
Example: one data table has subject information (Name, DOB, Address, etc.) The program would pull that information, insert it into a pre-written paragraph, and enter it into the word file. Another table has vehicle information, and would take data from the table and put it into a different pre-written paragraph. This would continue until the full report is completed.
My question: In writing the pre-written paragraphs, I've started to think about how annoying it would be to pre-write several different full report templates, and instead have the program be able to determine if a paragraph is put into the report based on whether or not a table exists for that section at all.
-would it be more efficient to have the program find the correct doc based on the data available and fill it in, or would it be more feasable to have the pre-written paragraph in the program itself to avoid searching several documents, and just print based on the data available within the program itself?