GemBox.Spreadsheet

ExcelRow.Cells Property

Gets cell range with row cells.

public CellRange Cells {get;}

Example

Look at following code for cell referencing examples:

[Visual Basic]
    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."
[C#]
    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.";

See Also

ExcelRow Class | GemBox.Spreadsheet Namespace | AllocatedCells | ExcelCell