SAPUI5 Export Excel Formulas

[Pedro]

Hello Dear SAPUI5 Experts.

I have a requirement about export a JSON containing data resultant from some calculations in the backend to a spreadsheet in xls format where some columns must be the excel formulas corresponding to the calculations.

Example:

JSON to be exported:

{
	results:{
		{
			A: 1,
			B: 2,
			C: '=A1 + B1'
		},
		{
			A: 3,
			B: 4,
			C: '=A2 + B2'
		}
	}
}<br>

Expected result:

I'm using sap/ui/export/Spreadsheet library but the problem I'm facing is that the formula's string isn't getting interpreted by the Excel as a formula, but just like a simple string:

I'm using this configuration for the C column:

{ label: 'C', property: 'C', type: "string" }

I'm afraid that there is no way to do this with the sapui5 standard library... so I'm looking for a better strategy to deal with this.

What the best approach you guys would kindly suggest to me to accomplish this requirement?

Regards