How to chance worksheet backcolor in c#

Question

1.00/5 (2 votes)

See more:

Link is there
Second link is there

What I have tried:

I want to change from blue to white color.Like in the pictures.

Posted 10-Feb-16 21:12pm

ibrahim-34

Updated 10-Feb-16 21:56pm

v2

Add a Solution

Comments

dan!sh 11-Feb-16 3:21am

You just said what you want in what you have tried. What have you tried? Anything?

Maciej Los 11-Feb-16 3:24am

Not a question at all!
What's the problem?

ibrahim-34 11-Feb-16 3:56am

I have two links up there.you can look at them.I want to change backcolorof worksheet ,ı tryed but i cant i need help on this.

4 solutions

Solution 1

Excel.Style style = Globals.ThisWorkbook.Styles.Add("NewStyle", missing);
style.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.White);
style.Interior.Pattern = Excel.XlPattern.xlPatternSolid;
Microsoft.Office.Tools.Excel.NamedRange rangeStyles = this.Controls.AddNamedRange(this.Range["A1", missing], "rangeStyles");
rangeStyles.Style = "NewStyle";
rangeStyles.Columns.AutoFit();

Using C# code to change the background color of an Excel spreadsheet range[^]

try below
.net - Change the background of Cells with C# - Stack Overflow[^]

Posted 10-Feb-16 21:23pm

Beginner Luck

Updated 10-Feb-16 22:01pm

v2

Comments

ibrahim-34 11-Feb-16 3:54am

Thank you ,all of them working but in the first link ı can change only font and in the second ı can change cells, i want change all backcolor worksheet not only one line.Like in the link of picture.How can i change Rows backcolor?

Solution 2

Start here:
How to: Programmatically Apply Color to Excel Ranges[^]
Adding Color to Excel 2007 Worksheets by Using the ColorIndex Property[^]

Posted 10-Feb-16 21:25pm

Maciej Los

Comments

ibrahim-34 11-Feb-16 3:55am

Thank you for answer, but i want change all backcolor worksheet ,or if it is possible to change Rows backcolor.Like in the link of picture.

Maciej Los 11-Feb-16 4:46am

Excel doesn't contain "Line" object! Don't be lazy! Try to adapt code to your needs.

Solution 3

I think Excel does not have any option to change a worksheet background color. There are 2 possible ways to archieve this I can think of:

- Select all Cells and change their Color
- Create in a graphics program a rectangle in the desired color, and then select it as the sheet background

Posted 10-Feb-16 22:34pm

Pikoh

Updated 10-Feb-16 22:37pm

v2

Comments

ibrahim-34 11-Feb-16 4:45am

Thank you for answer , but i try to do in the c#.I can changed cells but i try to change Rows and i get error.If i can change Rows backcolor , i think i can find solution.

Pikoh 11-Feb-16 4:51am

Ibrahim, you've been just told how to apply color to a range of cells, so you can change a Row backcolor.

Maciej Los 11-Feb-16 4:48am

First way is OK, but second may provide unexpected file growth - i do not recommend it.

Pikoh 11-Feb-16 4:51am

Well, i don't think it grows a lot. It's just a small jpg added and i think excel would just tile it, but i never tried it.

Maciej Los 11-Feb-16 4:54am

I didn't say that "file will grow", i said: "it may provide growth". It's not the same.

Pikoh 11-Feb-16 5:10am

Ok, it's just a slight difference, i'm not going to argue about it :)

Maciej Los 11-Feb-16 7:27am

Why? We should discuss about it. My opinion is based on my experience. We both are partially right. It might provide file growth, but does not have to.
Cheers,
Maciej
;)

Pikoh 11-Feb-16 9:22am

If you have experienced it, you are the one that is right of course ;) It's just i can't understand why it should be that way, unless MS implementation is poor, what wouldn´t surprise me at all

ibrahim-34 11-Feb-16 4:58am

I tryed to change backcolor of cells and i can,but when i tryed for Rows or Column i get error.If i can change Rows or Column Backcolor it will be more easy.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ibrahim-34 · Accepted Answer · 2016-02-11T00:40:00

Solution 4

Thank you everybody,I find the solution !

C#

range.EntireColumn.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red);

Posted 11-Feb-16 0:40am

ibrahim-34

Updated 11-Feb-16 3:34am

v2