Search code examples
c#excelborder

How can a border be set around multiple cells in excel using C#

I am working on a project that creates excel files.

I am having trouble placing a border on multiple cells to organize the excel file.

Let's say I want a border from cell B5 to B10. There shouldn't be borders between B5, B6, B7,...

Currently, I have this code: 

workSheet_range = worksheet.get_Range("B5", "B10");
workSheet_range.Borders.Color = System.Drawing.Color.Black.ToArgb();

It makes the borders, however it places a border around every cell instead of one big border for all cells.

How can I accomplish this?

Solution

  • You need to individually set these

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