Set border on a range

Apr 28, 2010 at 11:39 AM

Hi,

Great job on the EPPlus library Jan.

 

I've been trying to set border on an ExcelRange, but I'm probably doing something wrong.

Should this work? If not, how could this be done?

using (ExcelRange range = ws.Cells[rowIndex, 1, rowCount, 57])
{
    range.Style.Border.Top.Color.SetColor(System.Drawing.Color.Black);
    range.Style.Border.Top.Style = ExcelBorderStyle.Thin;
}

Any help appreciated.

Frode

Apr 28, 2010 at 12:06 PM

After a little more testing this works fine:

ws.Cells["A1:A10"].Style.Border.Top.Style = ExcelBorderStyle.Thin;

 Frode


Coordinator
Apr 28, 2010 at 12:10 PM

Have a look at sample 6.

Something like this...

            //Set a border around
            ws.Cells["A1:A43"].Style.Border.Left.Style = ExcelBorderStyle.Thin;
            ws.Cells["A1:O1"].Style.Border.Top.Style = ExcelBorderStyle.Thin;
            ws.Cells["O1:O43"].Style.Border.Right.Style = ExcelBorderStyle.Thin;
            ws.Cells["A43:O43"].Style.Border.Bottom.Style = ExcelBorderStyle.Thin;

Jan

Apr 28, 2010 at 12:16 PM

Thanks Jan. Found sample 6 :)

Frode