Connect HomeMarketplaceComponentsSopra Steria - Add Cell Borders in Excel

Sopra Steria - Add Cell Borders in Excel

Snippet

Snippet

Updated: October 27th, 2020

Published: February 29th, 2020

Downloads: 18

Industry: cross-industry

Language compatibility: Visual Basic

Community Support

Sopra Steria - Add Cell Borders in Excel

Snippet

Summary: 

Easily add borders in Excel

The bot executes an embedded VBA script to add borders in specified cells in Excel. If the cell addresses are dynamic/unknown, then leave starting and ending cell entry blank and the activity will add borders to all updated cells in conjuction with cell A1.
Please ensure to check "Trust access to the VBA project obejct model" in Excel trust center options before using this activity.

Details

Benefits

Easily add borders in Excel by just updating the path of workbook, sheet name, starting and ending cell to add borders.

Compatibility

UiPath 2018.4 onwards

Dependencies

UiPath.Excel.Activities: 2.5.3
UiPath.System.Activities: 18.4.1
UiPath.UIAutomation.Activities: 18.4.2

Licensing

By clicking download you agree to the following license.