You usually have either a harness that mainly works with a code interpreter that is able to execute Python, and does all the necessary data extraction from sources + the creation of office documents via your typical libraries, or you additionally enhance it with specific tools for each major office file format.

Source: Building a "harness" for organizations with deep MS Office suite integration at https://github.com/EratoLab/erato