How to change the font color in the excel cell

@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

@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

@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

@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

@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

Hi @supermanPunch ,

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

Regards
Balamurugan.S

1 Like

@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 ?

@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

@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 ?

@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?

@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.

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

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

2 Likes

@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

@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

@supermanPunch Thank you :raised_hands: :blush:

1 Like

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