Question

Capgemini
IN
Last activity: 16 Jun 2016 9:18 EDT
Template Excel File with formula
Hi,
We have a requirement to provide the users with an option to download data in an excel format, then allow them to modify the data and then upload it back again.
For this, we have used MSOGenerateExcelFile to download an excel file containing the data from the application.
This is working fine.
However, one of the column values in the excel file needs to have a formula associated with it.
e.g. we have 3 columns and have property references as mentioned below:
Now, Total (column C) column needs to have a formula so that Total = Price A + Price B
However, if we write this formula in the template excel file, the property reference cannot be used and the existing property value cannot be fetched and displayed in the excel file.
If we do not write the formula, the problem is that end users do not get to see the correct Total price in the excel (this gets handled in the application though using R-D-E).
Any suggestions on how this can be handled?
Thanks
Sudit
Message was edited by: Lochan to add Category