In This Topic ▼

Leadtools.Document.SheetEditor Namespace

Inheritance Hierarchy

Summary

Overview and description of Leadtools Document SheetEditor classes, and enumerations.

Classes

Class Description
Class Cell Defines a fundamental component in Excel document manipulation, providing a range of methods and properties to manage the content and appearance of individual cells.Includes methods to get and set cell values, formulas, and styles, as well as properties that give information about the cell's content and location in a worksheet.
Class CellBorder Manages the border style and color of a cell in an Excel worksheet, allowing the customization of their aesthetic and visual structure.
Class CellRange Represents a range of cells within a spreadsheet that encapsulates the coordinates of a rectangular cell range, defined by its first and last rows and columns.
Class CellRangeSortOptions Encapsulates data sorting options for a range of cells within a sheet, allowing to sort in either ascending or descending order.
Class CellStyle Encapsulates the styling and formatting options for a cell in a sheet to allow customization of aspects such as font, background color, alignment, and cell borders.
Class Font Represents the font attributes for text in a spreadsheet's cell. It encapsulates font properties such as name, size, style, and color, allowing for detailed customization of text appearance.
Class Hyperlink Represents a hyperlink. It encapsulates the essential properties of a hyperlink, including its destination address, a tooltip for additional information, and the hyperlink type.
Class LEADWorkbook Represents a workbook in Excel that encapsulates a collection of sheets along with operations to manipulate them.It offers functionalities to add, remove, or modify sheets, and handle workbook saving operations.Additionally, it provides methods to customize fonts, cell styles, and hyperlinks that enhance the interactivity of the workbook content.
Class MergedCellRegions Encapsulates functionality for managing merged cell regions within an Excel sheet. It provides methods to add, remove, and retrieve merged cell regions.
Class Row Represents a single row within an Excel sheet, providing properties and methods to access and manipulate cells within the row. Facilitates row-specific operations such as creating new cells or retrieving existing ones, enhancing the ability to programmatically interact with sheet data at the row level.
Class SearchResult Represents the result of a search performed on a sheet in the SheetEditor. It provides details about the location of the content, including the sheet order, row, and column where the content is located.
Class SearchResults Represents a collection of SearchResult elements generated by a search performed on the SheetEditor. It provides functionality to navigate, replace, or perform actions on the search results, and handling content across one or multiple sheets in a workbook.
Class Sheet Encapsulates the functionalities of a single sheet within an Excel workbook, providing properties and methods to access and manipulate rows, columns, cell contents, and embedded elements like images and merged cell regions.It serves as a foundational component for building and modifying spreadsheet documents.
Class SheetEditor Represents an editor for manipulating spreadsheet data.
Class SheetEditorClipboard Represents the clipboard operations management within the SheetEditor.It provides functionality to interact with the system clipboard, enabling users to transfer data to and from the SheetEditor.
Class SheetEditorCreateOptions Provides a configuration options for initializing a new instance of the SheetEditor.
Class SheetEditorFactory Serves as a factory for creating instances of the SheetEditor, providing a way to initialize and configure new editors with specific settings.
Class SheetEditorHistory Represents the user actions history manager of the SheetEditor.
Class SheetEditorInteractiveEventArgs Defines the base class for all the interactive events.It encapsulates data related to the specific part of the sheet being interacted with, the nature of the interaction, and its location within the workbook.
Class SheetEditorInteractiveService Defines the service to translate mouse and touch events to common user interface interactions.
Class SheetEditorSearch Represents the search operations manager within the SheetEditor.It enables users to find specific content across one or all sheets in a workbook, supporting both simple text or regular expression searches.
Class SheetEditorSelectionChangedEventArgs SheetEditorSelectionChangedEventArgs is an event data class that captures details about changes in cell or range selection within the SheetEditor.
Class SheetImage Represents an image embedded in an Excel sheet, providing access to the image itself, its display bounds within the sheet, and the cell range over which the image is placed.It facilitates the manipulation and analysis of images within sheets, enhancing the ability to programmatically interact with sheet content.
Class SheetImages Represents a collection of images embedded within an Excel sheet.It provides methods to add images to the sheet and properties to access these images, facilitating dynamic management of visual content in spreadsheet documents.

Enumerations

Enumeration Description
Enumeration BorderStyle Defines a set of styles that can be applied to the borders of cells.The supported border styles range from very basic to more complex patterns, resulting in an extensive set of visual presentation options.
Enumeration BorderType Defines the cell's left, top, right, and bottom, border types.
Enumeration CellRangeSortType Defines the sorting order types applied to a range of cells within a sheet, whether the data should be sorted in ascending or descending order.
Enumeration CellType Defines the types of cell content within a spreadsheet categorized based on their data content.
Enumeration FontStyle Defines constants that specify style information applied to text.
Enumeration HorizontalAlignment Defines constants that specify the horizontal alignment of content within a container, such as a cell in a spreadsheet or a text block in a document.Allows developers to precisely control how content is positioned horizontally, enhancing the layout and readability of the content.
Enumeration HyperlinkType Categorizes the type of hyperlink based on its destination, such as referring to within the same document, to an external website, or file.
Enumeration RangeBorderType Defines the types of borders that can be applied to cell ranges within an Excel sheet.Allows developers to specify the borders of a cell range should be styled or modified, offering a range of options from individual borders to comprehensive sets.
Enumeration SheetEditorItemPart Defines a part of an item in the SheetEditor.
Enumeration TextWrap Defines the text wrapping behavior for cells within an Excel sheet.
Enumeration VerticalAlignment Specifies the vertical alignment of content within cells in an Excel sheet.

See Also

Leadtools.Document.Sheeteditor Assembly

Introduction
Getting Started

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.