Set row border in excel using C#

Question

0.00/5 (No votes)

See more:

this is my code for set the border for each row.

Excel.Range BorderRAnge;
BorderRAnge = xlsheet.get_Range("A","E");
BorderRAnge.Font.Bold = true;
BorderRAnge.BorderAround(Excel.XlLineStyle.xlContinuous,       Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, Excel.XlColorIndex.xlColorIndexAutomatic);

when i run error shows as follows;
Cannot implicitly convert type 'Microsoft.Office.Interop.Excel.Range' to 'Excel.Range'. An explicit conversion exists (are you missing a cast?)

the above error shows in BorderRAnge = xlsheet.get_Range("A","E"); (this line).

please help me. what is the mistake in my code. i tried but it is not working.

Posted 4-Feb-13 23:09pm

Member 8054539

Updated 14-Jun-20 6:42am

Joezer BH

v3

Add a Solution

Comments

CHill60 5-Feb-13 5:15am

what's your declaration of "Excel" and "xlsheet"?

Zoltán Zörgő 5-Feb-13 5:46am

Repost on: http://www.codeproject.com/Answers/540513/howplustoplussetplusborderplusinplusexcelplusforpl
What is with that one? Don't you think it is rude not reacting to the answers?

1 solution

Add a Solution

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

Jameel VM · Answer 1 · 2013-02-04T23:23:00

Solution 1

try to set border individually like below

C#

BorderRAnge.Borders[Excel.XlBordersIndex.xlEdgeBottom]
BorderRAnge.Borders[Excel.XlBordersIndex.xlEdgeRight]
BorderRAnge.Borders[Excel.XlBordersIndex.xlEdgeLeft]
BorderRAnge.Borders[Excel.XlBordersIndex.xlEdgeTop]

hope this helps

Posted 4-Feb-13 23:23pm

Jameel VM

Set row border in excel using C#

1 solution

Solution 1

Add your solution here

Preview 0

Set row border in excel using C#

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us