How to update cell value

Overview

[highlight txt=’Update cell value’] excel instruction allows to update values in excel file in single cell address or range of cells. [highlight txt=’Update cell value’] instruction allows to link multiple excel files, which means instruction can update the values in multiple excel files.

[message type=”warning”]For the purpose of this article we are going to use a simple and fictitious example of a excel file name. You will want to replace excel file with the file name of your own.[/message]

Steps

1. Expand the folder from left on the screen and double click on a process to open a process.

2. Click on file manipulation step to open it.

3. Click on [highlight txt=’Click here to select an instruction’], select [highlight txt=’Update cell value’] instruction from Excel group.

4. In instruction detail, click on [highlight txt=’Link’] button on the target workbook to link an excel file. You may link multiple excel files by repeating this step-4.

5. Worksheet names from the linked excel file will be populated in the drop down list. Click on worksheet drop down list and select the excel worksheet.

6. Enter a single cell address OR select Advanced range from the drop down option, and enter the range address that you like to update.

There are 2 options to get the value to update in excel file(s) :

(1) Literal – You can choose and enter value in this field.
(2) Input\Output of another step – This option retrieves the value from properties of the data step.

[highlight txt=’To use Literal’]

7. Click on relevant type of input option from available options of String, Date, Number, Decimal or True/False.

[highlight txt=’Input\Output of another step’]

8. Click on [highlight txt=’Input\Output of another step’] option. Step property searcher will open.

9. Click on a data step from the result list that contains property you want to link in this instruction. Once you click on a data step, properties with the values will appear within the step searcher.

10. Select the property from the opened popup within searcher.

11. Click on [highlight txt=’Choose the selected property’].

12. Click on [highlight txt=’Save’] button the save the step details.

13.Click on [highlight txt=’Run’] button to run the step.

Completely configured [highlight txt=’Update cell value’] excel instruction will look like as shown in below image. After running the instruction, cell address / range of cells will be updated with the selected value.

Recent Posts

Leave a Comment

Contact Us

To learn more about SolveXia, please use the form below to send us an email. One of our team members will contact you.

Not readable? Change text. captcha txt

Start typing and press Enter to search