Skip to main content

What can we help you with?

Search

How to modify Excel cells format

Maria Victoria Bruera
  • Updated

Description

Applying formatting and styles of cells in our Excel workbooks is important to maintain a clean and clear format. In this article, you will learn how to format cells in an Excel file. 

 

Instructions

Here’s how to do it in a few easy steps:

  1. Create the VBS script with the instructions needed

  2. Save the VBS file in the root folder of the project

  3. Use Execute Macro activity and set the parameters

image-20221228-213608.png

3.1. Set the Excel file path using the picker button or using the Calculate a value option following the JS methods for handling strings

3.2. Set the VBS script path using the picker button or using the Calculate a value option following the JS methods for handling strings

 
Caution: Be careful with Javascript escape characters when working with strings.

image-20221228-214436.png

3.3. Enter the name of the function without the parentheses. For example, if a Sub Testing() function is created, just enter Testing

image-20221228-215018.png

3.4 Run the workflow.
The expected result is saved within the Excel file. To validate it, it is necessary to open the file.

For example, to change the background color of a cell or group of cells, use the "ColorIndex" property. To do so, declare the color-index in a variable and then pass it using the "Input arguments" field of the Execute Macro activity.


image-20230105-213553.png

 
Tip: In cases where the script returns a value, you need to use the Assign value to variable activity to save the result.
When creating the VBS script, try to use the Late Binding methodology.

For a Project Example, check out the attached file.

 

Related articles