Wiki Markup |
---|
{description} {excerpt}A [Cell|Cell] object represents a single cell in a worksheet. To return a {{Cell}} object use [Worksheet.Cells|Worksheet.Cells]. Specify the cell by 0\-based row and column indexes or by Excel\-style reference:{excerpt} {signature:C#} public sealed class Cell {signature}{signature:vb.net} Public NotInheritable Class Cell {signature} {example}{code:csharp|title=C#} //--- Get Cell by Excel-style reference ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Create(); Worksheet ws = wb.Worksheets[0]; Cell cellA1 = ws.Cells[0,0]; //--- Get Cell by Excel-style reference ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Create(); Worksheet ws = wb.Worksheets[0]; Cell cellA1 = ws.Cells["A1"]; {code} {code:vbnet|title=vb.net} '--- Get Cell by Excel-style reference Dim xla As New ExcelApplication() Dim wb As Workbook = xla.Create() Dim ws As Worksheet = wb.Worksheets(0) Dim cellA1 As Cell = ws.Cells(0, 0) '--- Get Cell by Excel-style reference Dim xla As New ExcelApplication() Dim wb As Workbook = xla.Create() Dim ws As Worksheet = wb.Worksheets(0) Dim cellA1 As Cell = ws.Cells("A1") {code} {example} {properties} ||Name||Description|| |[ColumnNumber|Cell.ColumnNumber]|{excerpt-include:Cell.ColumnNumber|nopanel=true}| |[Comment|Cell.Comment]|{excerpt-include:Cell.Comment|nopanel=true}| |[ConditionalFormat|Cell.ConditionalFormat]|{excerpt-include:Cell.ConditionalFormat|nopanel=true}| |[DataValidation|Cell.DataValidation]|{excerpt-include:Cell.DataValidation|nopanel=true}| |[Formula|Cell.Formula]|{excerpt-include:Cell.Formula|nopanel=true}| |[HasComment|Cell.HasComment]|{excerpt-include:Cell.HasComment|nopanel=true}| |[HasConditionalFormat|Cell.HasConditionalFormat]|{excerpt-include:Cell.HasConditionalFormat|nopanel=true}| |[HasDataValidation|Cell.HasDataValidation]|{excerpt-include:Cell.HasDataValidation|nopanel=true}| |[IsMerged|Cell.IsMerged]|{excerpt-include:Cell.IsMerged|nopanel=true}| |[Name|Cell.Name]|{excerpt-include:Cell.Name|nopanel=true}| |[RowNumber|Cell.RowNumber]|{excerpt-include:Cell.RowNumber|nopanel=true}| |[Style|Cell.Style]|{excerpt-include:Cell.Style|nopanel=true}| |[Value|Cell.Value]|{excerpt-include:Cell.Value|nopanel=true}| |[ValueType|Cell.ValueType]|{excerpt-include:Cell.ValueType|nopanel=true}| {methods} ||Name||Description|| |[ApplyStyle(Style)|Cell.ApplyStyle(Style)]|{excerpt-include:Cell.ApplyStyle(Style)|nopanel=true}| |[ClearContent()|Cell.ClearContent()]|{excerpt-include:Cell.ClearContent()|nopanel=true}| |[ClearRichTextFormatting()|Cell.ClearRichTextFormatting()]|{excerpt-include:Cell.ClearRichTextFormatting()|nopanel=true}| |[CreateAnchor(Int32, Int32)|Cell.CreateAnchor(Int32, Int32)]|{excerpt-include:Cell.CreateAnchor(Int32, Int32)|nopanel=true}| |[CreateHyperlink(String)|Cell.CreateHyperlink(String)]|{excerpt-include:Cell.CreateHyperlink(String)|nopanel=true}| |[GetCharacters(Int32)|Cell.GetCharacters(Int32)]|{excerpt-include:Cell.GetCharacters(Int32)|nopanel=true}| |[GetCharacters(Int32, Int32)|Cell.GetCharacters(Int32, Int32)]|{excerpt-include:Cell.GetCharacters(Int32, Int32)|nopanel=true}| |[RemoveComment()|Cell.RemoveComment()]|{excerpt-include:Cell.RemoveComment()|nopanel=true}| |[RemoveConditionalFormat()|Cell.RemoveConditionalFormat()]|{excerpt-include:Cell.RemoveConditionalFormat()|nopanel=true}| |[RemoveDataValidation()|Cell.RemoveDataValidation()]|{excerpt-include:Cell.RemoveDataValidation()|nopanel=true}| |[SetConditionalFormat(ConditionalFormat)|Cell.SetConditionalFormat(ConditionalFormat)]|{excerpt-include:Cell.SetConditionalFormat(ConditionalFormat)|nopanel=true}| |[ToString()|Cell.ToString()]|{excerpt-include:Cell.ToString()|nopanel=true}| |[Unmerge()|Cell.Unmerge()]|{excerpt-include:Cell.Unmerge()|nopanel=true}| {classes} ||Name||Description|| |[CellValueType|Cell.CellValueType]|{excerpt-include:Cell.CellValueType|nopanel=true}| {scrollbar} |
Page History
Overview
Content Tools