Select Range
Object to select a range of cells to be colored.
Last updated
Object to select a range of cells to be colored.
Last updated
Field
Descriptive
Title
Object Title
Select Main Object
Option to select an Excel sheet
Background
Opção para selecionar a cor de fundo da célula - Option to select the cell's background color
Font
Option to select the cell's font color
Select Range
Allows you to enter a range of cells
Starting Column
Initial column of the cell range that will be colored
Final Column
Final column of the cell range that will be colored. If none is set, the last column of the spreadsheet will be considered as the final one
Starting Row
Initial row of the cell range that will be colored
Final Row
Final row of the cell range that will be colored. If none is set, the last row of the spreadsheet will be considered as the final one
To colorize the cells of an Excel spreadsheet, you can select a range:
1 - Select the "Open Excel" object from the "Excel" menu and drag it to your working area.
First you must define a unique name for the object in the "Object Identifier Name" field, inform the complete directory containing the name and the extension of the file and then set a password if it is required.
2 - Then select the "Select Sheet" object from the "Excel" menu, select the main object defined when opening the Excel file and then define the name of the sheet you wish to select.
3 - Then you must select the "Colorize Cells" object in the "Excel" menu, select the main object, select the color for the cell's background and the color of the font to be used and click on the "Select Range" option. Finally, inform the columns and rows corresponding to the cells you wish to colorize.
