Connect HomeMarketplaceComponentsSopra Steria - Format Font Style in Excel

Sopra Steria - Format Font Style in Excel

Snippet

Snippet

Updated: September 24th, 2020

Published: March 13th, 2020

Downloads: 1

Industry: finance-and-insurance

Language compatibility: Visual Basic

Community Support

Sopra Steria - Format Font Style in Excel

Snippet

Summary: 

Format font style in Excel cells as Bold, Italic or Underline

This activity allows you to add the font style in your specified Excel cells as Bold, Italic and Underline as per your requirement. It executes a VBA script to apply font on cells.
To use this activity the user just needs to specify the Excel file name, sheet name, cell range and font style which the user wants to apply on a cell.

Please ensure to check "Trust access to the VBA project object model" in Excel Trust Center options before using this activity.

Details

Benefits

Format the font style as Bold, Italic and Underline by updating the file path, sheet name and cell range. You can also use the font style separately as Bold, Italic or Underline.

Compatibility

UiPath 2020.4 onwards

Dependencies

UiPath.UIAutomation.Activities: 20.4.1
UiPath.System.Activities: 20.4.0
UiPath.Excel.Activities: 2.8.5
Please ensure to check "Trust access to the VBA project object model" in Excel Trust Center options before using this activity.

Licensing

By clicking download you agree to the following license.