UiPath.Excel.Activities.Business.WriteCellX
Enters a text or a formula in a cell.
To learn how to use this activity, see:
- Tutorial: Saving, Renaming, and Moving Attachments.
- Tutorial: Comparing Excel Files and Emailing Reconciliation Errors.
In the Body of the Activity
- What to write - Click on the right side of the field and then, from the menu, select what to enter in the cell:
- Data from an application added to a card in the project or from the Excel Workspace. For example, select a cell in an Excel file to copy the value from that cell, or a field from the email selected in Outlook at the moment the project is executed to copy its contents.
- Use Saved Value - Select a value that you previously saved for later use in the project.
- Text - Enter a text in the Text Builder. If you enter an Excel formula, for example
=A2+B2
, the formula is entered in the cell. - Number - Enter a numeric value.
- Open in Advanced Editor - Enter a VB expression.
- Where to write - Click on the right side of the field and then, from the menu, select an Excel file and a named cell where to enter the data, or select Indicate in Excel to indicate directly from the file. Alternatively, you can select Custom Input to enter a cell address manually, or Open in Advanced Editor to enter a VB expression.
Properties
Common
- Display Name - The name displayed for the activity in the Designer panel.
Destination
- See Where to write in the body of the activity.
Input
- See What to write in the body of the activity.
Misc
- Private - If selected, the data used in the activity is not logged by StudioX.
Updated 2 years ago