Articles → UIPATH → Set The Column Width Of The Excel Using Uipath

Set The Column Width Of The Excel Using Uipath

In this article, we will set the column width of the excel using Uipath.

Sample Excel

For this example, I am using the blank excel file.

Implementation Steps

To open the dialog for changing the column width, the shortcut of opening the column width dialog is "ALT + O + C + W". To change that, we will follow the following steps.

Set the focus on the excel using the click activity.
Use the "Send Hotkey" activity to enter "ALT + O".
Use the "Send Hotkey" activity to enter "C".
Use the "Send Hotkey" activity to enter "W".
Use the "Type Into" activity to enter the column width i.e. "20".
Use the "Send Hotkey" activity to press enter.

Picture showing the complete sequential flow of UiPath for setting the column width in excel

Click to Enlarge

Save and run the bot.

Output

Picture showing the excel file after the column width is set to 20

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Wednesday, April 7, 2021

Query/Feedback

Your Email Id

Subject

Query/Feedback	Characters remaining 250