How to change the font color in the excel cell

Help Studio
, ,
19

@Vrushali_Gave What value are you passing to the columnName variable in Invoke VBA ?

I guess it is Empty, Can you check on that and revert back ?

20

@supermanPunch Yes right, I have modified it.

image

But same output as previous.

colIndex is today date and that is the column name

21

@Vrushali_Gave colIndex refers to the Index of the Column and not the column name, According to the Workflow that you have provided you need to use Now.ToString(“dd”) as the column name for identification of the column to be updated in the DT.
But to Change the Color of the Updated value in the Excel you would need to have the column names of the Excel i.e A, B, C, …

I have recognised that you have not used the Number To Letter workflow for retrieving the Column Name of the excel dynamically, but it is very much needed if the Column name is not known.

Note that, The Column Names of the Datatable are different and the Column Name that we need to identify for Changing the Font Color is different.

Can you just execute the below workflow and let me know if it worked. The Test Excel file should have the values under the Column “Update” in red color after the execution.

Excel_Automation.zip (16.5 KB)

Then accordingly, you could use your Input file and Column Name, by only changing the values present in the First two Assign Activities and then Execute for your Inputs.

Let us know if you are still facing issues.

22

@supermanPunch Yes sir. it’s worked perfectly for a normal excel sheet. for example: For Calibri, Arial, etc. font. Thank you so much.

But sir in my case I have another format of sheet. The font is Symbol. The color doesn’t change here.

Could you please check for this format? I have attached the sheet
Book1.xlsx (8.9 KB)

Thank you

23

@Vrushali_Gave I was able to Change the Color of the Value that was written, But since the Font format was Symbol, the value “C” had changed to X.

image

24

@supermanPunch Sir, see

image

I have attached the original sheet.
Could you please check for the attached sheet3?

Book1.xlsx (12.1 KB)

Best Regards,
Vrushali

25

@Vrushali_Gave I am able to perform the operation for that sheet as well.

image

Can you provide the entire workflow ? Maybe there is some correction needed in the logic :sweat_smile:

Or there may be a shift in Sheets maybe from one sheet to another, so it doesn’t update in the right sheet.

1 Like
26

@supermanPunch
Yes, I have to change text color for three sheets. In my workflow it execute one by one
I have attached the workflow

Demo26.xaml (20.4 KB)

Thanks in advanced

27

Hi @supermanPunch ,

Have you checked this one to change the style of the font with more features.

Regards
Balamurugan.S

1 Like
28

@Vrushali_Gave You have provided an Excel file with two sheets in it, Sheet1 and Sheet3. The Sheet2 is missing or it shouldn’t be included in the SheetNames argument.

Also can you tell why have you used “B1” and “B4” and “B5” as the starting range while using Write Range or Read Range at some places ?

I think the differences in the ranges can cause the differences in Changing the font color. Maybe you can provide a more detailed explanation as to what you are performing ?

29

@supermanPunch Sir, could you please try with the following attached excel file.
The file has three sheets.

Steps of the workflow:

  1. I’m adding today’s date as a column name
  2. Writing data in today’s column using row index
  3. Now, I want to change the column text color to red

Excel sheet : Book1.xlsx (14.1 KB)

Workflow : Demo26.xaml (20.4 KB)

I want to write in excel from the B5 row column and also want to change the color of text written from B5 to below

Thanks in advanced

30

@Vrushali_Gave As I have understood your Workflow, You would want to use the same logic for all the 3 Sheets in the Excel file. But I think the 3 sheets do not hold a common update point and hence we would need to use separate logic for 3 of those sheets.

Also Do you want to update all the 3 sheets from B5 position ?

31

@supermanPunch B5 is fixed position for all the 3 sheets. Bot adding “C” for every column in the 3 sheets

Why the sheets are not holding a common update point?

32

@Vrushali_Gave The first Excel file that you had provided were not having the same template in all 3 sheets :sweat_smile: But this new file has the same template in all 3 sheets. Maybe I have got the output that you required. Can you just check the Output Excel below and verify if that’s the output that you require ?

Book1.xlsx (14.8 KB)

If it is not the required output, Can you provide us the Expected Output, then we can be more clear as to what we need to do.

33

@supermanPunch Yes sir, right. This is what I want

34

@Vrushali_Gave Can you Check this Workflow :
Excel_Automation.zip (16.3 KB)

2 Likes
35

@supermanPunch Thank you so much sir, It’s worked perfectly as I expected.

Sir can you elaborate the below line?
Enumerable.Range(3,ColumnReadingDT.Rows.Count-3)

Best Regards,
Vrushali

1 Like
36

@Vrushali_Gave Check the Below Link for more clear explanation on Enumerable.Range() :

I have used it to only update the rows of the Datatable starting from the row index 3 and updating TotalRows-3 from the 3rd Index.

The example should be clearer to understand. Let me know if you still need clarifications.

1 Like
37

@supermanPunch Thank you :raised_hands: :blush:

1 Like
38

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.