In This Topic ▼
Leadtools.Document.LEADOffice.Sheet Namespace
Summary
Overview and description of Leadtools Document LEADOffice Sheet classes, and enumerations.
Classes
| Class | Description | |
|---|---|---|
 |
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. |
|
CellBorder | Manages the border style and color of a cell in an Excel worksheet, allowing the customization of their aesthetic and visual structure. |
|
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. |
|
CellRangeSortOptions | Encapsulates data sorting options for a range of cells within a sheet, allowing to sort in either ascending or descending order. |
|
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. |
|
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. |
|
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. |
|
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. |
|
LEADWorkbookFactory | Provides factory methods for creating new instances of LEADWorkbook or loading them from either files or streams. |
|
LoadWorkbookOptions | Encapsulates options for loading a LEADWorkbook, including settings for password protection and opening a workbook in read-only mode.This class provides control over how workbooks are accessed and manipulated during the loading process. |
|
MergedCellRegions | Encapsulates functionality for managing merged cell regions within an Excel sheet. It provides methods to add, remove, and retrieve merged cell regions. |
|
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. |
|
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. |
|
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.Facilitates the manipulation and analysis of images within sheets, enhancing the ability to programmatically interact with sheet content. |
|
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 | |
|---|---|---|
 |
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. |
|
BorderType | Defines the cell's left, top, right, and bottom, border types. |
|
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. |
|
CellType | Defines the types of cell content within a spreadsheet categorized based on their data content. |
|
FontStyle | Defines constants that specify style information applied to text. |
|
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. |
|
HyperlinkType | Categorizes the type of hyperlink based on its destination, such as referring to within the same document, to an external website, or file. |
|
TextWrap | Defines the text wrapping behavior for cells within an Excel sheet. |
|
VerticalAlignment | Specifies the vertical alignment of content within cells in an Excel sheet. |
