在Aspose.Cells的儲存格中加上邊框

 

//Instantiating a Workbook object

Workbook workbook =
new
Workbook();

 

//Obtaining the reference of the first (default) worksheet by passing its sheet index

Worksheet worksheet = workbook.Worksheets[0];

 

//Accessing the "A1" cell from the worksheet

Aspose.Cells.Cell
cell = worksheet.Cells["A1"];

 

//Adding some value to the "A1" cell

cell.PutValue("Visit Aspose!");

           

//Create a style object

Style style = cell.GetStyle();

 

//Setting the line style of the top border

style.Borders[BorderType.TopBorder].LineStyle
= CellBorderType.Thick;

 

//Setting the color of the top border

style.Borders[BorderType.TopBorder].Color
= Color.Black;

 

//Setting the line style of the bottom border

style.Borders[BorderType.BottomBorder].LineStyle
= CellBorderType.Thick;

 

//Setting the color of the bottom border

style.Borders[BorderType.BottomBorder].Color
= Color.Black;

 

//Setting the line style of the left border

style.Borders[BorderType.LeftBorder].LineStyle
= CellBorderType.Thick;

 

//Setting the color of the left border

style.Borders[BorderType.LeftBorder].Color
= Color.Black;

 

//Setting the line style of the right border

style.Borders[BorderType.RightBorder].LineStyle
= CellBorderType.Thick;

 

//Setting the color of the right border

style.Borders[BorderType.RightBorder].Color
= Color.Black;

 

//Apply the border styles to the cell

cell.SetStyle(style);

 

//Saving the Excel file

workbook.Save("C:\\book1.xls");

資訊來自：http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/adding-borders-to-cells.html