CreateCellStyle Method

Summary

Creates and returns a new CellStyle object, allowing for the customization of cell appearance within the workbook.

Syntax

C++/CLI

Python

public CellStyle CreateCellStyle()

public:  
   CellStyle^ CreateCellStyle()

def CreateCellStyle(self):

Return Value

A new instance of the CellStyle object, which can be customized and then applied to cells within the workbook.

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