Advertisement
Guest User

Untitled

a guest
Apr 25th, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.72 KB | None | 0 0
  1.     class Program
  2.     {
  3.         static void Main(string[] args)
  4.         {
  5.             XLWorkbook workbook = new XLWorkbook();
  6.  
  7.             //增加 Sheet
  8.             var sheet = workbook.Worksheets.Add("Site Tree");
  9.  
  10.             //給值
  11.             sheet.Cell(1, 1).Value = "test";
  12.  
  13.             //範圍抓取
  14.             var header = sheet.Range("A1:C1");
  15.  
  16.             //改格式
  17.             header.Style.Fill.BackgroundColor = XLColor.Green;
  18.             header.Style.Font.FontColor = XLColor.Yellow;
  19.             header.Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
  20.  
  21.             //存檔
  22.             workbook.SaveAs(System.AppDomain.CurrentDomain.BaseDirectory+"test.xlsx");
  23.         }
  24.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement