Automation of report preparation in word

Question

Electronic accounting

Good afternoon, the question is, we are constantly preparing reports for clients on website promotion. The report contains graphs and diagrams, texts and conclusions. The previous manager, as it turned out, did everything manually. But, as far as I know, it is possible to simplify the work somewhat.

TE in the prepared document, fields for entering data are created, this data is entered once and displayed in reports, respectively, and graphs with diagrams are drawn automatically according to the specified parameters.

How can I do this in word or pdf? Who can you contact?

Answer 1

You can make a Word document, as you rightly said with the given fields, so to speak, a layout. Then in VBA, from the document itself, fill them in according to the program you want to write.
There is another way to write an application in .Net, there are providers for creating MS Office documents (with MS Office installed) from the application.

Answer 2

Yes, all this can be automated. Did something similar. A document template is created, the places for insertion are indicated by the corresponding tags. We introduced the following concepts: regular data, collections (whose data size is unknown in advance and is unloaded from the data and from xml) and various formulas (other formulas, various filters, etc. could be used as parameters inside the formulas). All this was done through ole-objects. Wrote in C++ in the embarcadero edition, there are corresponding components.
In order to understand how it all works, it is very convenient to use macros and VBA.

Answer 3

Word document can be created from PHP, Delphi, .NET, C++, VB, etc. and so on, you can, as correctly suggested by becks , do everything using Word and VBA. But for all this you need a programmer. Freelancer task.