Free Support Forum - aspose.com

Pb making borders of a range selection

Hi,

I’m trying to set the borders of a range selection.

My code looks like this :

Aspose.Excel.Range range = sheet.Cells.CreateRange(“A1”,"A10);
range.Style.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;

But, it seems that range.Style.Borders is null : I get a null pointer exception.
It works ok when I set a single cell border type.

Where am I wrong ?
Thanks,
Laurent.

Hi Laurent,

Please refer to http://www.aspose.com/Products/Aspose.Excel/Api/Aspose.Excel.Range.Style.html and http://www.aspose.com/Products/Aspose.Excel/Api/Aspose.Excel.Range.SetOutlineBorder.html.

If you want to set the outline border of a range, please user SetOutlineBorder method. If you want to set borders for each cell of a range, please try the following code:

int styleIndex = excel.Styles.Add();
Aspose.Excel.Style style = excel.Styles[styleIndex];
style.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;
range.Style = style;