Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class Program
- {
- static void Main(string[] args)
- {
- XLWorkbook workbook = new XLWorkbook();
- //增加 Sheet
- var sheet = workbook.Worksheets.Add("Site Tree");
- //給值
- sheet.Cell(1, 1).Value = "test";
- //範圍抓取
- var header = sheet.Range("A1:C1");
- //改格式
- header.Style.Fill.BackgroundColor = XLColor.Green;
- header.Style.Font.FontColor = XLColor.Yellow;
- header.Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
- //存檔
- workbook.SaveAs(System.AppDomain.CurrentDomain.BaseDirectory+"test.xlsx");
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement