Radzen.Documents.Spreadsheet Namespace

Represents a filter criterion that combines multiple criteria using a logical AND operation.

Represents an auto filter applied to a range in a spreadsheet.

Represents an axis in a spreadsheet, which can be used to manage the layout of rows or columns.

Conditional format rule that applies when the cell value is between two thresholds.

Represents a border style with color and line style.

Represents a cell in a spreadsheet.

Represents a cell anchor position for an image.

Filters to cells whose background or font color matches a target color.

Represents a value of a spreadsheet cell along with its type.

Represents a store for spreadsheet cells, allowing access and modification of cell values.

Represents a data point used to render spreadsheet charts via RadzenChart.

Resolves chart series data from cell range formulas.

Defines a data series within a spreadsheet chart.

Base class for conditional formatting rules.

Store for conditional formatting rules per ranges.

Represents a filter criterion that checks if a string value contains a specified value.

Options for CsvExportOptions).

Options for CsvImportOptions).

Represents a data validation rule that can be applied to a range of cells.

Represents a filter criterion that checks if a string value does not contain a specified value.

Represents a filter criterion that checks if a string value does not end with a specified value.

Represents a filter criterion that checks if a string value does not start with a specified value.

Filters using one of Excel's built-in dynamic predicates (above-average, today, this-month, etc.).

Represents a filter criterion that checks if a string value ends with a specified value.

Represents a filter criterion that checks for equality with a specified value.

Conditional format rule that applies when the cell value equals a specific value.

Represents a base class for filter criteria used in filtering rows of a spreadsheet.

Represents a base class for filter criteria that operate on a specific column in a spreadsheet.

Base implementation of IFilterCriterionVisitor with no-op defaults. Composite criteria (Or, And) recurse into their children by default. Override only the methods you need.

Represents a format that can be applied to cells in a spreadsheet.

Stateless one-shot formula evaluation. Internally creates a fresh FormulaEngine per call, so each call is independent.

Headless Excel-compatible formula engine. Use Formula for one-shot stateless evaluation, or instantiate FormulaEngine for a stateful mini-spreadsheet that recalculates dependents on change. Formula syntax matches Excel — leading = optional. Supports the full function library registered with the engine plus operators, ranges (=SUM(A1:A10)), and built-in functions (SUM, AVERAGE, IF, VLOOKUP, …).

Base class for formula functions that provides common functionality for evaluation.

Represents the arguments passed to a formula function, organized by parameter name.

Defines a parameter for a formula function.

Registry for spreadsheet formula functions.

Represents a filter criterion that checks for inequality with a specified value.

Represents a filter criterion that checks if the value is greater than or equal to a specified value.

Conditional format rule that applies when the cell value is greater than a threshold.

Represents a hyperlink in a spreadsheet cell.

Represents a filter criterion that checks if the value is in a predefined list of values.

Represents a filter criterion that matches only if the value is null.

Represents a filter criterion that checks if the value is less than a specified value.

Represents a filter criterion that checks if the value is less than or equal to a specified value.

Conditional format rule that applies when the cell value is less than a threshold.

Represents a store for merged cell ranges in a spreadsheet.

Represents a filter criterion that checks for inequality with a specified value.

Provides Excel-compatible number format code rendering.

Represents a validator that checks if the cell value is a number.

Represents a base class for filter criteria that operate on numeric values.

Represents a filter criterion that combines multiple criteria using a logical OR operation.

A class for managing the selection of cells or ranges in a spreadsheet.

Represents a floating chart on a spreadsheet sheet.

Represents a filter applied to a sheet, which includes a filter criterion and the range of rows that the filter applies to.

Represents a floating image on a spreadsheet sheet.

Represents sheet-level protection settings matching the XLSX sheetProtection element. When IsProtected is true, actions are blocked unless the corresponding Allow property is true.

Describes one sort level used by the multi-key SortKey[]) overload.

Represents a filter criterion that checks if a string value starts with a specified value.

Represents a base class for filter criteria that operate on string values.

Represents an Excel-style structured data table over a range of cells.

Represents a single column inside a Table.

Conditional format rule that applies when the cell value contains specified text.

Conditional format rule that applies when the cell value is in the top (or bottom) N distinct values of its range.

Filters to the top or bottom N items (or N percent) of a column.

Class that manages validation rules for cells in a spreadsheet.

Represents a workbook in a spreadsheet.

Represents workbook-level protection settings matching the XLSX workbookProtection element.

Represents a sheet in a spreadsheet.

Represents a reference to a cell in A1 notation e.g. "A1", "B2", etc. The row and column are zero-based indices, so "A1" corresponds to (0, 0) and "B2" corresponds to (1, 1). This struct is immutable and provides methods for parsing, comparing, and converting to string representation.

Represents a reference to a column in a spreadsheet.

Represents a range of cells in a spreadsheet.

Represents a reference to a specific row in a spreadsheet.

Represents a drawing on a spreadsheet sheet positioned through cell anchors, such as a SheetImage or a SheetChart.

Represents a validator for cell values in a spreadsheet.

Defines a visitor interface for filter criteria, allowing different operations to be performed on various types of filter criteria.

Represents the line style for a cell border.

Represents the type of value contained in a cell.

Represents errors that can occur during formula evaluation in a spreadsheet.

Specifies the legend position for a spreadsheet chart.

Controls how CSV writers quote individual fields.

Specifies the error style for data validation.

Specifies the comparison operator for data validation.

Specifies the type of data validation to apply.

Specifies the anchor mode for a sheet image.

Excel's dynamic filter operators. Map onto DynamicFilterType in OOXML.

Defines the type of a function parameter.

Enumerates the discrete actions that sheet protection can block.

Specifies the value the sort comparison runs against - the cell's stored value, its background color, or its font color.

Specifies the chart type for a spreadsheet chart.

Specifies the aggregation displayed in a TableColumn's totals-row cell.