Summary:

I am trying to create a Dockerized Flask web application that allows users to upload an Excel file, process it using a predefined formula in another Excel file, and then download the processed file. The application relies on xlwings to handle the Excel file operations.

Goal:

User uploads an Excel file containing a column named Input.
Process the uploaded file by applying a formula from a predefined Excel file (formula_file.xlsx).
Save the results in a new column named Answers in the uploaded file.
Allow the user to download the processed file.

Key Components:

Flask: To create the web interface for file upload and download.

xlwings: To interact with Excel files and apply formulas.

Docker: To containerize (Windows Container) the application.

Question:

Is it technically possible to accomplish? I have tried many times with many ways, but without any result. Maybe someone of you have already went through something similar and can share some advice?