Free Support Forum -

BorderType in Aspose cells

Hi all,

i want to set border for my cells.
i used

ws.Cells[0, 0].Style.Borders.SetStyle(Aspose.Cells.CellBorderType.Hair);

and result

but i want result

Please help me!!


Please refer to the following code for your need:

Workbook workbook = new Workbook();
Cells cells = workbook.Worksheets[0].Cells;

//apply style to a range of cells.
Range range = cells.CreateRange(“B2”, “D4”);
Style stl = workbook.Styles[workbook.Styles.Add()];
stl.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Hair;
stl.Borders[BorderType.TopBorder].Color = Color.Blue;
stl.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Hair;
stl.Borders[BorderType.LeftBorder].Color = Color.Blue;
stl.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Hair;
stl.Borders[BorderType.BottomBorder].Color = Color.Blue;
stl.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Hair;
stl.Borders[BorderType.RightBorder].Color = Color.Blue;
StyleFlag flg = new StyleFlag();
flg.Borders = true;

range.ApplyStyle(stl, flg);

//Applying border to a single cell.
//Accessing the “A1” cell from the worksheet
Aspose.Cells.Cell cell = cells[“A1”];
//Adding some value to the “A1” cell
cell.PutValue(“Visit Aspose!”);
//Setting the line style of the top border
cell.Style.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Hair;
//Setting the color of the top border
cell.Style.Borders[BorderType.TopBorder].Color = Color.Red;
//Setting the line style of the bottom border
cell.Style.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Hair;
//Setting the color of the bottom border
cell.Style.Borders[BorderType.BottomBorder].Color = Color.Green;
//Setting the line style of the left border
cell.Style.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Hair;
//Setting the color of the left border
cell.Style.Borders[BorderType.LeftBorder].Color = Color.Blue;
//Setting the line style of the right border
cell.Style.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Hair;
//Setting the color of the right border
cell.Style.Borders[BorderType.RightBorder].Color = Color.Yellow;



For further details, see the documents:

Thank you.

Work good! ^^
Thanks so much