Update Cell color in datatable

Help
1

Hi… Is it possible to update the cell colour in a datatable before writing to excel?

2

impossible.

3

Hi @VanithaRajakumar,

you can store the value like below. Check the link.

System.Drawing.Color c = System.Drawing.Color.FromArgb(int);

int x = c.ToArgb();

Regards
Balamurugan.S

4

@VanithaRajakumar

We have activities to set color for the range or cell in excel but not in the data table .

5

Thank you all for response. @balupad14… I will check this as well.

1 Like
6

Vanitha, there is an alternate way I have found, Please check this demo and let me know if it helps:

7

Hi all,

1)I want to set color to certain Columns in Gsheet. Kindly guide if anyone knows about it?

2)Is it possible to move the sheet with in a Gsheet from one position to other.
eg: Aug,Oct,Sep here oct should be placed after Sep (Aug,Sep,Oct).Quick help needed!!