Arnout Arnout - 1 year ago 83
C# Question

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?

Answer Source

You need to individually set these

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download