|
|
Write data into a table
When you work with tables, you might want to enter data.
Let's say you have gone through a process in your application that results in an ID number. Now you want to write this ID number into a specific cell in your table.
To write data into a table, you work with ActionMode Input.
Formats in Microsoft Excel
If you work with Microsoft Excel tables, pay close attention to formatting:
-
What are the Region settings in the Windows system settings of the workstation that contains the Excel file?
-
Do the settings of the Excel file match the Region settings of the workstation?
-
If they do, does the date and number format in RPA Studio match those settings?
If they don't match, you need to define a different date and number format in RPA Studio.
-
How are the cells in the Excel table formatted?
For instance, if you try to enter date values into a cell that's been formatted as text, you will run into problems with your Excel file.
Enter a value into a cell
To write data into a cell in your table, follow the steps below:
-
In your
Table element, identify the respective cell as described in "Define which cell to steer". -
Fill out the Value field of the cell. You can enter any text, date, number, or Value Expression.
-
Select the ActionMode Input.
-
Choose an appropriate DataType. For instance, to enter text, select String from the drop-down menu.
Select a data type
In this example, you use a Date Expression to generate a current date and time value at run-time.
The Bot writes this value into the cell in the last row of the column named Processed.
Enter a timestamp into a cell
In this example, you want to re-use a value that you have previously saved to a Buffer named Salary.
At run-time, the Bot limits the search for the cell to certain parameters. It looks for any row that has the value Sylvia in the First Name column and Jones in the Last Name column.
The Bot then writes the value into the last cell of the row.
Enter a previously saved value into a cell