|
|
|
อยากทราบวิธีการเปลี่ยน Font ใน Excel ครับ ไม่ทราบว่าเปลี่ยนยังไงโดยใช้ C# |
|
|
|
|
|
|
|
Code (C#)
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
sheet.Range["B1"].Text = "Font setting";
sheet.Range["B1"].Style.Font.IsBold = true;
sheet.Range["B3"].Text = "Arial";
sheet.Range["B3"].Style.Font.FontName = "Arial";
sheet.Range["B4"].Text = "Large size";
sheet.Range["B4"].Style.Font.Size = 20;
sheet.Range["B5"].Text = "Bold";
sheet.Range["B5"].Style.Font.IsBold = true;
sheet.Range["B6"].Text = "Italic";
sheet.Range["B6"].Style.Font.IsItalic = true;
sheet.Range["B7"].Text = "Superscript";
sheet.Range["B7"].Style.Font.IsSuperscript = true;
sheet.Range["B8"].Text = "Colored";
sheet.Range["B8"].Style.Font.Color = Color.FromArgb(255,125,125);
sheet.Range["B9"].Text = "Underline";
sheet.Range["B9"].Style.Font.Underline = FontUnderlineType.Single;
หลากหลายเทคนิค
|
|
|
|
|
Date :
2013-10-10 09:49:32 |
By :
mr.win |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Load balance : Server 00
|