Click or drag to resize

Spire.Xls.Core.Spreadsheet Namespace

Classes
Class Description
Public class AddtionalFormatWrapper
The base style class.
Public class CellBaseStyle
Represents the base style for the cell.
Public class CellValueChangedEventArgs
Provides data for the CellValueChanged event.
Public class ColorConditionValue
Represents condition value for colorset condition.
Public class CommonWrapper
Represents a common wrapper class .
Public class FontArrayWrapper
Class that is created when user accesses the font in a multicell range. Redirects all calls to the fonts of the individual cells.
Public class FontWrapper
Represents a wrapper class for handling font properties . This class inherits from CommonWrapper and implements interfaces for font functionality. It provides a structured way to manage font attributes such as font name, size, style, and color.
Public class GradientArrayWrapper
Summary description for GradientArrayWrapper.
Public class HTMLOptions
Represents options for HTML rendering.
Public class InteriorArrayWrapper
Class that is created when user accesses the interior in a multicell range. Redirects all calls to the interiors of the individual cells.
Public class LOGFONT
Represents LogFont structure that defines the attributes of a font.
Public class RangeRichTextString
Represents a rich text string with range-based formatting.
Public class RichTextShape
Represents a shape that can contain rich text content.
Public class RichTextString
Represents a string that supports rich text formatting.
Public class RTFCommentArray
Represents an array of RTF comments in an Excel document.
Public class RTFStringArray
Represents an array of RTF (Rich Text Format) strings within an Excel object.
Public class RtfTextWriter
Rtf text writer used for converting rtf string into rtf format.
Public class StyleArrayWrapper
A object contain all styles that are used by range.
Public class UtilityMethods
This class contains utility methods, that cannot be logically placed in any other class.
Public class WriteProtection
Represents a class that manages write protection settings for a resource.
Public class XlsAddInFunction
Represents a single add-in, either installed or not installed.
Public class XlsBorder
Represents the border style and properties for a cell in an Excel worksheet.
Public class XlsBorderArrayWrapper
This class represents border for multicell range.
Public class XlsConditionalFormat
Contains a condition and the formatting for cells.
Public class XlsDataValidationTable
Table of all data validations in the worksheet.
Public class XlsEventArgs
Class used as message sender on Property value change. Class provides old and new values which allow user to create advanced logic.
Public class XlsFill
Summary description for XlsFill.
Public class XlsFont
Represents a font style used in Excel documents, encapsulating properties such as font name, size, color, and style attributes like bold or italic.
Public class XlsFontStyle
Represents the font style for Excel cells, allowing customization of font attributes such as font name, size, color, and style (bold, italic, underline, etc.).
Public class XlsGradient
Represents a gradient used in Excel for filling cells with a smooth transition between two or more colors.
Public class XlsHPageBreak
Represents a horizontal page break in an Excel worksheet.
Public class XlsHyperLink
Represents a hyperlink.
Public class XlsName
Represents named range in the excel.
Public class XlsObject
Represents an Excel application object that implements the IExcelApplication interface and provide some operation about parent
Public class XlsPageSetup
Represents the page setup settings for an Excel worksheet.
Public class XlsPageSetupBase
Summary description for PageSetupBaseImpl.
Public class XlsPageSetupBase PaperSizeEntry
This class contains size of the paper.
Public class XlsRange
Represents a range of cells in an Excel worksheet.
Public class XlsStyle
Represents a style for cells in an Excel worksheet, inheriting from AddtionalFormatWrapper and implementing interfaces for comparison, styling, and named object functionality.
Public class XlsValidation
Represents data validation for a worksheet range.
Public class XlsValidationWrapper
Represents a wrapper class for Excel validation.
Public class XlsVPageBreak
Represents a vertical page break.
Public class XlsWorkbook
Represents a workbook.
Public class XlsWorkbook StringUtil
Provides a collection of utility methods for string manipulation.
Public class XlsWorksheet
Represents a worksheet. The Worksheet object is a member of the Worksheets collection. The Worksheets collection contains all the Worksheet objects in a workbook.
Public class XlsWorksheetBase
Represents the base class for Excel worksheet operations.
Interfaces
Interface Description
Public interface ISparkline
Defines the contract for a sparkline, which is a small embedded chart typically used to display trends over a small number of data points.
Public interface ISparklineGroup
Represents a group of sparklines, providing functionality to manage a collection of sparkline objects.
Public interface ISparklines
Represents a collection of sparklines, implementing the IList interface to manage a list of ISparkline objects.
Delegates
Delegate Description
Public delegate XlsEventHandler
Delegate which can be used for Property Changed events declarations.
Public delegate XlsRange CellValueChangedEventHandler
Represents the method that will handle the CellValueChanged event of a control.
Enumerations
Enumeration Description
Public enumeration HTMLOptions GetText
Represents the type input text mode.
Public enumeration HTMLOptions ImageLocationTypes
Enum representing different types of image location.
Public enumeration HTMLOptions StyleDefineType
Represents different types of style definitions.
Public enumeration RtfTags
Elements order is very important.
Public enumeration StrikeThroughStyle
Elements order is very important.
Public enumeration UnderlineStyle
\ul Continuous underline. \ul0 turns off all underlining. \ulcN Underline color \uld Dotted underline. \uldash Dash underline. \uldashd Dash dot underline. \uldashdd Dash dot dot underline. \uldb Double underline. \ulhwave Heavy wave underline \ulldashLong dash underline \ulnone Stops all underlining. \ulth Thick underline \ulthd Thick dotted underline \ulthdashThick dash underline \ulthdashdThick dash dot underline \ulthdashddThick dash dot dot underline \ulthldashThick long dash underline \ululdbwave Double wave underline \ulw Word underline. \ulwave Wave underline. Elements order is very important.
Public enumeration XlsWorksheet TRangeValueType
Represents range value type.