Forms Data to Excel spreadsheets

Forms Data to Excel spreadsheets

Hello,

I try to to implement Creator to get rid of excel spreadsheets in our everyday business workflows. However, we still need to deliver some documents in Excel format to some customers.

I used another "low-code forms application" (DoForms) which allowed me to populate a "preformated" excel file, with forms data.
This by upoading an xls template with the "data name", (or "link_name" in zoho) prepopulated to certain cells. This would give me in return an xls corresponding to the record, with data populated to dedicated cells (even with images).

Is there a way I can do this "easily" with Creator ?
the reports "xls download" option does not fit this need.

Do you have any ideas ?

Some ways of exploration maybe :

- through direct ODBC connection to excel ? is this available ?
- through a SQL server to which I connect in ODBC ? (cumbersome, I want low-code !)
- through some API magic ? (need to learn)

Many thanks for your answers !