Cell Class Members

Summary

The following tables list the members exposed by Cell.

Public Methods

Name Description
Public Method GetDisplayStringValue Retrieves the text representation of a cell's value as it is displayed in sheet processing applications.Useful for obtaining the formatted output of a cell, regardless of the cell's actual data type or value.
Public Method GetStyle Retrieves the CellStyle object that encapsulates various styling details, such as font and border settings of a cell.
Public Method SetCellBooleanValue Assigns a boolean value to a specific cell within a sheet.
Public Method SetCellDateValue Sets a cell's content to a DateTime value within an Excel sheet. Allows for the direct assignment of date and time information to a cell.
Public Method SetCellFormula Sets the cell formula value.
Public Method SetCellNumericValue Sets a cell's content to a numeric value of type double within a sheet. Enables the direct input of numbers into a cell, facilitating numerical data handling in applications.
Public Method SetCellStringValue Assigns a string value to a specific cell within a sheet, used for populating cells with text data.
Public Method SetStyle Applies a specific style as defined by a CellStyle object to a cell within a sheet.Thus, enabling the customization of cell appearance, including aspects like font, alignment, and border settings.

Public Properties

Name Description
Public Property BoolCellValue Gets the value of the cell that is expected to be a boolean.This property is designed to access the logical value contained within the cell and it is useful in logical operations, condition checks, or representing binary states.
Public Property CellFormula Gets the formula for a cell.
Public Property CellType Gets the cell type.
Public Property ColumnIndex Gets the column index of a cell within the sheet.
Public Property DateCellValue Gets the value of a cell as a date. This property is relevant for cells that are formatted as dates or contain date information.
Public Property Hyperlink Gets or sets a hyperlink associated with a cell. This property enables the embedding of URLs or links to other resources within a cell, facilitating navigation and referencing.
Public Property NumericCellValue Retrieves the numerical value of a cell such as formatted numbers and dates.
Public Property RowIndex Gets the index of the row in which the cell is located within a sheet.
Public Property StringCellValue Gets the text content of a cell within a sheet.

See Also

Cell Class

Leadtools.Document.SheetEditor Namespace

Help Version 23.0.2024.5.29
Products | Support | Contact Us | Intellectual Property Notices
© 1991-2024 LEAD Technologies, Inc. All Rights Reserved.

Leadtools.Document.SheetEditor Assembly
Products | Support | Contact Us | Intellectual Property Notices
© 1991-2023 LEAD Technologies, Inc. All Rights Reserved.