原創|其它|編輯:郝浩|2012-10-17 14:03:37.000|閱讀 5440 次
概述:本文介紹了如何在Aspose.Cells的單元格中加上邊框。
# 界面/圖表報表/文檔/IDE等千款熱門軟控件火熱銷售中 >>
本文介紹了如何在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");
本站文章除注明轉載外,均為本站原創或翻譯。歡迎任何形式的轉載,但請務必注明出處、不得修改原文相關鏈接,如果存在內容上的異議請郵件反饋至chenjj@fc6vip.cn
文章轉載自:行游客的專欄-CSDN