uipath technical infomation for everyone

Change the sheet name


Change the sheet name using Excel’s shortcut.
※ There is no activity at 2018/4/19.

Procedure

1 Use the “Excel Application Scope” activity to launch an Excel file. Use the Select Range activity on the sheet you want to change to activate the sheet.

 

2 Place a Send hotKey activity.

The shortcut key to change the sheet in Excel is “Alt”, “o”, “h”, “r” in order.

Using the Send hotkey activity:

 

Uncheck the SpecialKey property of the Send hotKey activity.

When the shortcut key is executed, the sheet name can be changed as follows.

3 Use the Set to clipboard activity and enter a sheet name.

The type Into activity can not be used, but depending on the input mode, it may be entered in capital letters unintentionally, so here copy the string to the clipboard with the “Set to clipboard” activity, and then “Send hotkey” Paste in activity (Ctrl + v).

 

Uncheck the SpecialKey property of the Send hotKey activity.

 

4 Confirm with “enter” key.

 

Check the SpecialKey property of the Send hotKey activity.