Cells Property

ExcelWorksheet Cells Property

GemBox.Spreadsheet Help

Gets CellRange with all the cells (ExcelCell) in the worksheet.

Namespace: GemBox.Spreadsheet
Assembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 37.3.30.1069

Syntax

public CellRange Cells { get; }

public CellRange Cells { get; }

Public ReadOnly Property Cells As CellRange 
	Get

Public ReadOnly Property Cells As CellRange 
	Get

Examples

Look at following code for cell referencing examples:

Copy to Clipboard Print

ExcelWorksheet ws = excelFile.Worksheets.ActiveWorksheet;

ws.Cells["B2"].Value = "Cell B2.";
ws.Cells[6, 0].Value = "Cell in row 7 and column A.";

ws.Rows[2].Cells[0].Value = "Cell in row 3 and column A.";
ws.Rows["4"].Cells["B"].Value = "Cell in row 4 and column B.";

ws.Columns[2].Cells[4].Value = "Cell in column C and row 5.";
ws.Columns["AA"].Cells["6"].Value = "Cell in AA column and row 6.";

ExcelWorksheet ws = excelFile.Worksheets.ActiveWorksheet;

ws.Cells["B2"].Value = "Cell B2.";
ws.Cells[6, 0].Value = "Cell in row 7 and column A.";

ws.Rows[2].Cells[0].Value = "Cell in row 3 and column A.";
ws.Rows["4"].Cells["B"].Value = "Cell in row 4 and column B.";

ws.Columns[2].Cells[4].Value = "Cell in column C and row 5.";
ws.Columns["AA"].Cells["6"].Value = "Cell in AA column and row 6.";

Dim ws As ExcelWorksheet = excelFile.Worksheets.ActiveWorksheet

ws.Cells("B2").Value = "Cell B2."
ws.Cells(6, 0).Value = "Cell in row 7 and column A."

ws.Rows(2).Cells(0).Value = "Cell in row 3 and column A."
ws.Rows("4").Cells("B").Value = "Cell in row 4 and column B."

ws.Columns(2).Cells(4).Value = "Cell in column C and row 5."
ws.Columns("AA").Cells("6").Value = "Cell in AA column and row 6."

Dim ws As ExcelWorksheet = excelFile.Worksheets.ActiveWorksheet

ws.Cells("B2").Value = "Cell B2."
ws.Cells(6, 0).Value = "Cell in row 7 and column A."

ws.Rows(2).Cells(0).Value = "Cell in row 3 and column A."
ws.Rows("4").Cells("B").Value = "Cell in row 4 and column B."

ws.Columns(2).Cells(4).Value = "Cell in column C and row 5."
ws.Columns("AA").Cells("6").Value = "Cell in AA column and row 6."