I would just like to know if it is possible to create an Activite that allows to format an Excel cell to a Style (Normal, Bad, Good) and not format it completely to certain values (such font, font color, font size, type, etc.), because I use the Style to sort my column.
Hello @Lusiiky, try this:
- First, create the styles in your Excel file manually. Open the Excel file, select the cell or range of cells you want to format, and apply the desired formatting using the “Format Cells” dialog. Then, click the “New Style” button in the “Styles” section and give your style a name, such as “Normal,” “Bad,” or “Good.”
- Once you have created the styles in Excel, you can use UiPath to apply these styles to the cells dynamically. You can use the “Write Cell” or “Write Range” activity to write the cell values as usual, and then use the “Set Range Style” activity from the UiPath.Excel.Activities package to apply the desired style to the cells.
You can use the Format cell activity to format the range of cells in the excel file.
Note - The format cell activity has to be inside the Use excel file activity.
Hope it helps!!
Thanks for the reply, but I can’t seem to find “Set Range Style”… it doesn’t seem to exist for me…(?)
@Lusiiky If you are using modern design activities then use the format cells activity to format the font, color, size.
Precisely, I would like to use a precise Style, because I sort it thanks to this.
If I apply a single format to each cell, I don’t think that’s going to help ^^'.