CellRange Constructor

Summary

Initializes a new instance of CellRange.

Syntax

C++/CLI

Python

public CellRange( 
   int firstRow, 
   int lastRow, 
   int firstColumn, 
   int lastColumn 
)

public:  
   CellRange(Int32 firstRow, Int32 lastRow, Int32 firstColumn, Int32 lastColumn)

__init__(self,firstRow,lastRow,firstColumn,lastColumn) # Overloaded constructor

Parameters

firstRow

Zero-based index of the first row in the cell range.

lastRow

Zero-based index of the last row in the cell range.

firstColumn

Zero-based index of the first column in the cell range.

lastColumn

Zero-based index of the last column in the cell range.

Remarks

The CellRange constructor initializes a new CellRange object with the specified boundaries. The boundaries define a rectangle of cells in a spreadsheet, starting from the firstRow and firstColumn to the lastRow and lastColumn.

This constructor does not perform any operations on the cells within the range itself. It merely defines the range, which can then be used in conjunction with spreadsheet manipulation methods.

Example

using Leadtools; 
using Leadtools.Document.LEADOffice.Sheet; 
 
 
public void MergeCellsAndSaveExample() 
{ 
   // Load an Excel workbook from a file 
   var workbook = LEADWorkbookFactory.Create(); 
 
   // Add a new sheet named "MergeExample" or access an existing sheet 
   var sheet = workbook.CreateSheet("MergeExample"); 
 
   // Define the cell range to merge (e.g., A1:B1) 
   var mergeRange = new CellRange(0, 0, 0, 1); // This assumes 0-based indexing for rows and columns 
 
   // Perform the merge operation on the specified cell range 
   sheet.MergedRegions.AddRegion(mergeRange); 
 
   // Optionally, set a value for the merged cells 
   var cell = sheet.CreateRow(0).CreateCell(0); // Access the first cell in the merge range 
   cell.SetCellValue("Merged Cell"); 
 
   // Save the workbook to disk 
   var filePath = Path.Combine(LEAD_VARS.ImagesDir, @"MergedCells.xlsx"); 
   workbook.Save(filePath); 
 
   Console.WriteLine($"Workbook saved with merged cells to {filePath}"); 
} 
 
static class LEAD_VARS 
{ 
   public const string ImagesDir = @"C:\LEADTOOLS23\Resources\Images"; 
}

Requirements

Target Platforms