Using the Set Formula Value Step
- 12 Mar 2021
- 1 Minute to read
- Print
- DarkLight
Using the Set Formula Value Step
- Updated on 12 Mar 2021
- 1 Minute to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Example Lab Article
While Example Lab projects are resources for public use, articles and assets are not actively maintained. Screenshots and features are from the specified version below. These references may become dated as new versions are released.
Overview
Example Lab Details | |
| Version | 6.10.2 |
| Root Folder | Example Lab-Using Set Formula Value Step |
| Modules | None |
| Dependencies | None |
This Example Lab project demonstrates how to use the Set Formula Value step to populate data in an excel spreadsheet using a formula.
Explanation
This Flow starts with the Create Data step. Create Data Step contains a file data variable that is set to a constant. An excel template is uploaded to this variable. The Set Formula Value step is used to add a value to a cell of the excel file using a formula. The inputs for this step are the following: Column, File Type, Input, New Value, Row, Worksheet Number. For this example we have set the Column to 1, File Type to Auto Select, Input to the uploaded file from the Create Data step, New Value is set to the formula of “1+4”, Row is set to 0 and Worksheet Number is set to 0. This will populate the value of 5 in the first cell of the excel file. The Update File With Data step is updating the excel file with the data that is modified with the Set Formula Value step. The Download Updated Excel Form takes in the output of the Update File With Data step as an input and is used to download the updated excel file.
Reference Articles
Project Download
The examples attached were developed to be instructional and were not developed as officially supported components. For more information or to engage our service team to develop fully supported, production quality solutions, please contact services@decisions.com. Import the project below to a Decisions environment on version 6.10.2 or later using our Importing/Exporting article.
Was this article helpful?
