Sheet Class

Summary

Encapsulates the functionalities of a single sheet within an Excel workbook, providing properties and methods to access and manipulate rows, columns, cell contents, and embedded elements like images and merged cell regions. It serves as a foundational component for building and modifying spreadsheet documents.

Syntax

C++/CLI

Python

public class Sheet

public: 
   ref class Sheet

class Sheet:

Remarks

The Sheet class is central to manipulating and navigating the contents of an Excel sheet. It provides a high level of abstraction for dealing with spreadsheet elements, enabling developers to create, modify, and analyze sheet data efficiently.

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