在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
  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值