Compile individual functions (or entire model) to python code

[vinci1it2000]

Compile individual functions (or entire model) to python code

[vinci1it2000]

I have implemented the solution that I mentioned above. Follows an example of usage:

import json
import formulas
xl_model = formulas.ExcelModel().loads('test/test_files/excel.xlsx').finish()
xl_json = json.dumps(xl_model.to_dict(), indent=True)

The JSON has the following format:

{
 "'[EXCEL.XLSX]DATA'!A1": "inputs",
 "'[EXCEL.XLSX]DATA'!B1": "Intermediate",
 "'[EXCEL.XLSX]DATA'!C1": "outputs",
 "'[EXCEL.XLSX]DATA'!D1": "defaults",
 "'[EXCEL.XLSX]DATA'!A2": 2,
 "'[EXCEL.XLSX]DATA'!D2": 1,
 "'[EXCEL.XLSX]DATA'!A3": 6,
 "'[EXCEL.XLSX]DATA'!A4": 5,
 "'[EXCEL.XLSX]DATA'!B2": "=('[EXCEL.XLSX]DATA'!A2 + '[EXCEL.XLSX]DATA'!A3)",
 "'[EXCEL.XLSX]DATA'!C2": "=(('[EXCEL.XLSX]DATA'!B2 / '[EXCEL.XLSX]DATA'!B3) + '[EXCEL.XLSX]DATA'!D2)",
 "'[EXCEL.XLSX]DATA'!B3": "=('[EXCEL.XLSX]DATA'!B2 - '[EXCEL.XLSX]DATA'!A3)",
 "'[EXCEL.XLSX]DATA'!C3": "=(('[EXCEL.XLSX]DATA'!C2 * '[EXCEL.XLSX]DATA'!A2) + '[EXCEL.XLSX]DATA'!D3)",
 "'[EXCEL.XLSX]DATA'!D3": "=(1 + '[EXCEL.XLSX]DATA'!D2)",
 "'[EXCEL.XLSX]DATA'!B4": "=MAX('[EXCEL.XLSX]DATA'!A3:A4, '[EXCEL.XLSX]DATA'!B2)",
 "'[EXCEL.XLSX]DATA'!C4": "=(('[EXCEL.XLSX]DATA'!B3 ^ '[EXCEL.XLSX]DATA'!C2) + '[EXCEL.XLSX]DATA'!D4)",
 "'[EXCEL.XLSX]DATA'!D4": "=(1 + '[EXCEL.XLSX]DATA'!D3)"
}

To retrieve the model:

xl_mdl = ExcelModel().from_dict(json.loads(xl_json))

[vinci1it2000]

The easiest solution and the most portable one is to dump the ExcelModel (i.e., the DAG) into a readable JSON format. In this way, you may "easily" maintain your code from the JSON, and afterward, you load it into the ExcelModel.

What do you think? Is it a suitable solution for your problem?

[allenlawrence94]

This is great - I ended up going in an altogether different direction with my project, but I think I'll try out this new feature as well. Thanks!