Question

7
Replies
4920
Views
SuditSNG Member since 2013 19 posts
Capgemini
Posted: 4 years ago
Last activity: 4 years 3 months ago
Closed
Solved

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:

Untitled.png

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

Data Integration System Administration
Moderation Team has archived post
Share this page LinkedIn