Support Portal

for ProcessRobot and WinAutomation

Start a new topic

Excel Color Cells

If possible, it would be very nice with the possibility to color cells directly through a ProcessRobot/WinAutomation actions.


Right now it takes several UI actions to change the color (for example: red for a bad value, and green for a good value) and this can take a long time in a spreadsheet with hundreds of rows.


I have encountered these process steps in several projects now. People generally like indicator colors in their end product Excel Sheets.



1 person likes this idea

ADMIN

Hello Henrik,


While the Excel file is open, feel free to use the "Run VBScript" Action and run the following code:


Set objExcel = GetObject("%Excel%").Application
objExcel.Application.Visible = True

Set objSheet = objExcel.Sheets("%Worksheet%")

objSheet.Range("A1:A1").Cells.Interior.ColorIndex = 40


%Excel% is the Excel file path

%Worksheet% is the name of the worksheet

ColorIndex is the color number. Feel free to check the available numbers on the internet.


1 person likes this

Thanks, that's great info! 

ADMIN

You are welcome Henrik!

Login or Signup to post a comment