CreateFont Method

Summary

Creates a new Font object with specified attributes, allowing for detailed customization of text appearance in the workbook. Provides the ability to define fonts with specific names, sizes, styles, and colors, which can then be applied to cell styles.

Syntax

C++/CLI

Python

public Font CreateFont( 
   string fontName, 
   double size, 
   FontStyle fontStyle, 
   RasterColor color 
)

public:  
   Font^ CreateFont( 
      String^ fontName, 
      double size, 
      FontStyle^ fontStyle, 
      RasterColor^ color 
   )

def CreateFont(self,fontName,size,fontStyle,color):

Parameters

fontName

A string specifying the name of the font.

size

A double representing the font size in points.

fontStyle

A FontStyle enumeration value indicating the style of the font.

color

A RasterColor object specifying the color of the font.

Return Value

A new instance of the Font object configured with the specified font attributes.

Example

using Leadtools; 
using Leadtools.Document.LEADOffice.Sheet; 
 
 
public void CreateWorkbookFileExample() 
{ 
   // Initialize the workbook 
   var workbook = LEADWorkbookFactory.Create(); 
 
   // Add a new sheet named "Test" 
   var sheet = workbook.CreateSheet("Test"); 
 
   // Access the first cell (assuming 0-based indexing) 
   var cell = sheet.CreateRow(0).CreateCell(0); 
 
   // Update the cell's value 
   cell.SetCellValue("LEADTOOLS"); 
 
   // Style the cell 
   var cellStyle = workbook.CreateCellStyle(); 
   cellStyle.Font = workbook.CreateFont("Arial", 12, FontStyle.Bold, RasterColor.FromKnownColor(RasterKnownColor.Black)); 
   cellStyle.BackgroundColor = RasterColor.FromKnownColor(RasterKnownColor.Gray); 
   cellStyle.HorizontalAlignment = HorizontalAlignment.Center; 
   cellStyle.VerticalAlignment = VerticalAlignment.Center; 
   cellStyle.WrapText = TextWrap.Wrap; 
 
   // Apply the style to the cell 
   cell.SetStyle(cellStyle); 
 
   // Save the workbook to disk 
   var filePath = Path.Combine(LEAD_VARS.ImagesDir, @"WorkbookTest.xlsx"); 
   workbook.Save(filePath); 
} 
 
static class LEAD_VARS 
{ 
   public const string ImagesDir = @"C:\LEADTOOLS23\Resources\Images"; 
}

Requirements

Target Platforms