Aspose.Cells FOSS for PHP

API reference for Aspose.Cells FOSS for Php. 223 public types organized by module.

Core API

Class	Description
`AlignmentValue`	Class with 2 methods and 8 properties.
`AutoFilter`	Class with 4 methods and 2 properties.
`AutoFilterColorFilter`	AutoFilterColorFilter.Clear() clears any color‑based filter criteria applied to an auto‑filter column.
`AutoFilterColorFilterModel`	Class with 1 method and 3 properties.
`AutoFilterCustomFilter`	Class with 3 methods.
`AutoFilterCustomFilterCollection`	Class with 13 methods.
`AutoFilterCustomFilterModel`	Class with 2 properties.
`AutoFilterDynamicFilter`	Class with 4 methods.
`AutoFilterDynamicFilterModel`	AutoFilterDynamicFilterModel lets developers enable a dynamic filter, choose its type, and set single or range values via the Enabled, Type, Value, and MaxValue properties.
`AutoFilterModel`	Class with 3 methods and 3 properties.
`AutoFilterSortCondition`	Class with 3 methods.
`AutoFilterSortConditionCollection`	Class with 13 methods.
`AutoFilterSortConditionModel`	Class with 7 properties.
`AutoFilterSortState`	AutoFilterSortState.Clear() removes all sort conditions from a worksheet’s auto‑filter, resetting its sort state.
`AutoFilterSortStateModel`	Class with 3 methods and 5 properties.
`AutoFilterSupport`	AutoFilterSupport enables developers to normalize optional and required filter range strings, parse filter operators, and compare filter columns when configuring worksheet auto‑filters.
`AutoFilterTop10`	Class with 4 methods.
`AutoFilterTop10Model`	Class with 1 method and 5 properties.
`AutoShapeType`	Class with 39 methods.
`Border`	The Border.Clone() method returns a deep copy of a border, allowing independent modification of border styles on different cells.
`BorderSideValue`	Class with 2 methods and 2 properties.
`BorderStyle`	BorderStyle provides a set of predefined border styles—Thin, Medium, Thick, Dotted, Dashed, Double, Hair, MediumDashed, DashDot, MediumDashDot, DashDotDot, MediumDashDotDot, and SlantedDashDot—for cell formatting.
`BorderStyleType`	BorderStyleType provides a set of methods such as Thin, Medium, Thick, Dotted, Dashed, Double, and others to specify common cell border styles.
`Borders`	Class with 2 methods and 7 properties.
`BordersValue`	Class with 2 methods and 7 properties.
`CalculationProperties`	Class with 3 methods.
`CalculationPropertiesModel`	Class with 2 methods and 12 properties.
`Cell`	Cell styling—including fonts, fills, borders, alignment, and protection—can be configured via the properties of the CellFormatValue class (NumFmtId, FontId, FillId, BorderId, Alignment, Protection).
`CellAddress`	CellAddress.Parse(cellReference) converts a string like “B3” into a CellAddress object exposing RowIndex and ColumnIndex, and can be compared with Equals(other).
`CellArea`	Class with 6 methods and 4 properties.
`CellFormatValue`	Class with 1 method and 6 properties.
`CellRecord`	Class with 1 method and 5 properties.
`CellValueKind`	Class with 7 methods.
`CellValueType`	CellValueType offers methods like IsNumeric() and IsDateTime() so code can safely branch based on a cell’s runtime data type.
`Cells`	Class with 8 methods and 2 properties.
`CellsException`	Class with 1 method.
`Chart`	Class with 3 methods.
`ChartCollection`	Class with 9 methods.
`ChartCompanionFile`	Class with 4 properties.
`ChartModel`	Class with 1 method and 17 properties.
`ChartTarget`	ChartTarget objects expose a Uri property and an IsChartEx flag, allowing developers to reference external chart resources and identify chart extensions.
`ChartType`	Class with 26 methods.
`ChartXmlTemplates`	ChartXmlTemplates.Build(type, dataRange, chartTitle) creates an XML template for a chart of the specified type, using the given data range and title.
`Color`	Class with 8 methods and 4 properties.
`ColorValue`	Class with 4 methods and 7 properties.
`Column`	Class with 3 methods.
`ColumnCollection`	Class with 5 methods.
`ColumnRangeModel`	Class with 5 properties.
`Comment`	Class with 3 methods.
`CommentCollection`	Class with 10 methods.
`CommentModel`	Class with 1 method and 8 properties.
`ConditionalFormattingCollection`	Class with 12 methods.
`ConditionalFormattingModel`	Class with 1 method and 2 properties.
`CoreDocumentProperties`	Class with 3 methods.
`CoreDocumentPropertiesModel`	Class with 2 methods and 11 properties.
`CultureInfo`	Minimal CultureInfo shim.
`DateSerialConverter`	Class with 3 methods.
`DateSystem`	DateSystem provides static helpers Windows1900() and Mac1904() to select the workbook’s date system.
`DateTimeFormatInfo`	Minimal DateTimeFormatInfo shim carrying date and time names and patterns.
`DefinedName`	Class with 3 methods.
`DefinedNameCollection`	Class with 12 methods.
`DefinedNameModel`	Class with 5 properties.
`DefinedNameUtility`	Class with 8 methods.
`DiagnosticBag`	Class with 4 methods.
`DiagnosticEntry`	Class with 1 method and 5 properties.
`DiagnosticSeverity`	Class with 4 methods.
`DisplayFormatSectionInfo`	Class with 4 properties.
`DisplayTextDateFormatSupport`	Class with 8 methods.
`DisplayTextFormatter`	Class with 2 methods.
`DisplayTextFormatterSupport`	Class with 16 methods.
`DisplayTextLocaleSupport`	Class with 1 method.
`DisplayTextNumberSupport`	Emulates .NET custom numeric format strings for native PHP int/float values.
`DocumentProperties`	Class with 3 methods.
`DocumentPropertiesModel`	Class with 3 methods and 2 properties.
`ExtendedDocumentProperties`	Class with 3 methods.
`ExtendedDocumentPropertiesModel`	Class with 2 methods and 9 properties.
`ExternalLinkModel`	Class with 2 properties.
`FillPattern`	Class with 18 methods.
`FillPatternKind`	Class with 18 methods.
`FillValue`	Class with 1 method and 3 properties.
`FilterColumn`	Class with 4 methods and 5 properties.
`FilterColumnCollection`	Class with 13 methods.
`FilterColumnModel`	Class with 3 methods and 8 properties.
`FilterOperatorType`	FilterOperatorType provides static methods such as Equal() and GreaterThan() to specify comparison operators when building filter conditions.
`FilterValueCollection`	Class with 13 methods.
`Font`	Font.Clone() creates a deep copy of a Font object, preserving its name, size, style, and color settings.
`FontUnderlineType`	Class with 20 methods.
`FontValue`	Class with 2 methods and 7 properties.
`FormatCondition`	Class with 4 methods.
`FormatConditionCollection`	Class with 17 methods.
`FormatConditionModel`	Class with 1 method and 26 properties.
`FormatConditionType`	Class with 16 methods.
`FormulaException`	Class with 2 methods.
`HeaderFooterModel`	HeaderFooterModel lets developers set worksheet headers and footers via its LeftHeader, CenterHeader, RightHeader, LeftFooter, CenterFooter, and RightFooter properties.
`HorizontalAlignment`	Class with 8 methods.
`HorizontalAlignmentType`	Class with 8 methods.
`HyperlinkModel`	Class with 8 properties.
`ImageType`	Class with 5 methods.
`InvalidFileFormatException`	Class with 1 method.
`ListColumn`	Class with 5 methods.
`ListColumnCollection`	Class with 8 methods.
`ListColumnModel`	Class with 1 method and 5 properties.
`ListObject`	Class with 7 methods and 1 property.
`ListObjectCollection`	ListObjectCollection implements PHP’s array‑access and countable interfaces, allowing tables (list objects) to be added, removed, enumerated, and accessed by index directly from a worksheet.
`ListObjectModel`	Class with 1 method and 16 properties.
`ListObjectSupport`	Class with 10 methods.
`LoadDiagnostics`	LoadDiagnostics captures issues encountered while loading workbooks, helping developers identify data‑loss risks during import.
`LoadFormat`	Class with 2 methods.
`LoadIssue`	Class with 1 method and 9 properties.
`LoadOptions`	LoadOptions lets developers enable package‑level and XML‑level repair by setting `TryRepairPackage` and `TryRepairXml` to true before loading a workbook.
`MergeRegion`	Class with 1 method and 4 properties.
`NumberFormat`	Class with 4 methods.
`NumberFormatInfo`	Minimal NumberFormatInfo shim carrying the invariant culture’s numeric separators, group sizes and sign symbols.
`NumberFormatValue`	Class with 1 method and 2 properties.
`OperatorType`	Class with 9 methods.
`PageMarginsModel`	Class with 6 properties.
`PageOrientation`	Class with 3 methods.
`PageOrientationType`	PageOrientationType.Portrait() returns the enum value representing portrait orientation for worksheet page setup.
`PageSetup`	PageSetup.AddHorizontalPageBreak(rowIndex) inserts a page break before the given row, enabling custom print pagination.
`PageSetupModel`	Class with 1 method and 14 properties.
`PaperSizeType`	Class with 11 methods.
`Picture`	Picture.ImageTypeFromExtension(extension) returns the internal image type enum for a given file extension, enabling correct handling of picture data.
`PictureCollection`	PictureCollection.Add(upperLeftRow, upperLeftColumn, lowerRightRow, lowerRightColumn, imageDataOrStreamOrFileName) inserts an image into a worksheet at the specified cell range.
`PictureModel`	Class with 1 method and 14 properties.
`PrintOptionsModel`	Class with 4 properties.
`ProtectionValue`	Class with 2 methods and 2 properties.
`Row`	Class with 3 methods.
`RowCollection`	Class with 5 methods.
`RowModel`	Class with 3 properties.
`SaveFormat`	Class with 1 method.
`SaveOptions`	SaveOptions controls workbook saving behavior; properties include SaveFormat, UseSharedStrings, ValidateBeforeSave, CompactStyles, and PreserveRecoveryMetadata.
`Shape`	Class with 5 methods.
`ShapeCollection`	ShapeCollection enables adding geometric shapes to a worksheet with Add(upperLeftRow, upperLeftColumn, lowerRightRow, lowerRightColumn, shapeType) and removing them via RemoveAt(index).
`ShapeImageModel`	Class with 3 properties.
`ShapeModel`	ShapeModel provides properties such as UpperLeftRow, UpperLeftColumn, and ExtentCx to position and size shapes precisely on a worksheet.
`SharedStringRepository`	Class with 6 methods.
`SheetVisibility`	Class with 3 methods.
`Style`	The Style class provides methods to copy, clone, compare, and convert styles, and exposes Font, Borders, Pattern, colors, number format, and alignment properties for full cell styling.
`StyleException`	Class with 2 methods.
`StyleFlag`	Class with 29 properties.
`StyleRepository`	Class with 1 method.
`StyleValue`	StyleValue provides full styling control, exposing Font, Pattern, ForegroundColor, BackgroundColor, Borders, Alignment, Protection, NumberFormat, and QuotePrefix properties.
`StyleValueSanitizer`	Class with 3 methods.
`StylesheetLoadContext`	Class with 1 method and 4 properties.
`StylesheetSaveContext`	Class with 3 methods and 3 properties.
`TableStyleType`	Class with 62 methods.
`TargetModeType`	TargetModeType.External() creates a target mode indicating that a hyperlink points to an external resource.
`TotalsCalculation`	Class with 10 methods.
`UnsupportedFeatureException`	Class with 2 methods.
`Validation`	Class with 5 methods.
`ValidationAlertType`	Class with 3 methods.
`ValidationCollection`	ValidationCollection.Add(area) creates a data validation rule for the specified cell range, and the collection provides methods to retrieve, remove, and compare validation areas.
`ValidationModel`	Class with 1 method and 14 properties.
`ValidationType`	Class with 8 methods.
`VerticalAlignment`	Class with 5 methods.
`VerticalAlignmentType`	Class with 5 methods.
`VisibilityType`	Class with 3 methods.
`WarningInfo`	Class with 8 properties.
`Workbook`	Workbook.Save(fileName, options) writes the current workbook to the specified .xlsx file.
`WorkbookLoadException`	Class with 1 method.
`WorkbookModel`	WorkbookModel.Properties provides access to workbook‑level settings such as CodeName, ShowObjects, and BackupFile via the WorkbookPropertiesModel class.
`WorkbookProperties`	Class with 3 methods.
`WorkbookPropertiesModel`	Class with 3 methods and 13 properties.
`WorkbookPropertySupport`	WorkbookPropertySupport normalizes workbook settings such as ShowObjects, UpdateLinks, Visibility, CalculationMode, and ReferenceMode to ensure valid values before saving.
`WorkbookProtection`	Class with 3 methods.
`WorkbookProtectionModel`	Class with 2 methods and 5 properties.
`WorkbookSaveException`	Class with 1 method.
`WorkbookSettings`	Class with 3 methods.
`WorkbookSettingsModel`	Class with 1 method and 2 properties.
`WorkbookView`	Class with 3 methods.
`WorkbookViewModel`	Class with 2 methods and 12 properties.
`Worksheet`	Class with 5 methods.
`WorksheetCollection`	WorksheetCollection.Add(sheetName) creates a new worksheet with the given name and adds it to the workbook.
`WorksheetDefinedNamesState`	Class with 3 properties.
`WorksheetModel`	Class with 1 method and 20 properties.
`WorksheetProtection`	Class with 4 methods.
`WorksheetProtectionModel`	WorksheetProtectionModel lets developers configure protection flags such as IsProtected, Objects, Scenarios, FormatCells, FormatColumns, FormatRows, InsertColumns, InsertRows, InsertHyperlinks, and DeleteColumns.
`WorksheetViewModel`	Class with 5 properties.
`XlsxDocumentProperties`	Class with 8 methods.
`XlsxWorkbookArchiveHelpers`	Class with 20 methods.
`XlsxWorkbookAutoFilter`	Class with 2 methods.
`XlsxWorkbookComments`	Class with 10 methods.
`XlsxWorkbookCommentsLoader`	Class with 1 method.
`XlsxWorkbookConditionalFormatting`	Class with 2 methods.
`XlsxWorkbookDefinedNames`	Class with 2 methods.
`XlsxWorkbookPageSetup`	Class with 11 methods.
`XlsxWorkbookPictures`	Class with 20 methods.
`XlsxWorkbookPicturesLoader`	Class with 4 methods.
`XlsxWorkbookProperties`	Class with 5 methods.
`XlsxWorkbookSerializer`	Class with 2 methods.
`XlsxWorkbookSerializerCommon`	Provides shared serialization helpers for the XLSX workbook writer.
`XlsxWorkbookStyles`	Class with 5 methods.
`XlsxWorkbookStylesValueHelpers`	Class with 8 methods.
`XlsxWorkbookStylesXml`	XlsxWorkbookStylesXml contains methods to read and build style components, including `ReadFontValues`, `BuildFontElements`, `ReadFillValues`, `BuildFillElements`, `ReadBordersValues`, and `BuildBorderElements`.
`XlsxWorkbookTables`	Class with 7 methods.
`XlsxWorkbookValidations`	Class with 2 methods.
`XlsxWorkbookWorksheetLoader`	Class with 2 methods.
`XlsxWorkbookWorksheetProtection`	Class with 2 methods.
`XlsxWorkbookWorksheetViews`	Class with 3 methods.
`XlsxWorkbookWorksheetWriter`	Class with 12 methods.

Interfaces

Interface	Description
`IListObjectOwner`	Interface with 3 methods.
`IWarningCallback`	Interface with 1 method.

Navigation

Class	Description
`Hyperlink`	Class with 6 methods.
`HyperlinkCollection`	Class with 11 methods.
`XlsxWorkbookHyperlinks`	XlsxWorkbookHyperlinks provides methods such as `BuildHyperlinksElement`, `LoadHyperlinks`, and `GetOrderedHyperlinks` to create, read, and order hyperlink relationships in a worksheet.

Packaging

Class	Description
`MissingPartException`	Class with 1 method.
`PackageLoadContext`	Class with 1 method and 2 properties.
`PackageModel`	Class with 3 properties.
`PackagePartDescriptor`	Class with 3 properties.
`PackageStructureException`	Class with 1 method.
`PackagingConventions`	PackagingConventions.WorkbookPart() returns the standard part name for the workbook XML within an Open XML package.
`RelationshipDescriptor`	Class with 4 properties.
`RelationshipResolutionException`	Class with 1 method.

Interfaces

Interface	Description
`IPackageReader`	Interface with 1 method.
`IPackageWriter`	IPackageWriter.Write(stream, packageModel) serializes a workbook’s package model to the provided stream, enabling custom save destinations.

Validation

Class	Description
`ValidationMessage`	Class with 3 properties.
`ValidationMessageSeverity`	Class with 3 methods.
`WorkbookValidator`	WorkbookValidator.ValidateForSave(workbookModel, packageModel) runs validation checks on a workbook before it is saved, ensuring the generated OpenXML package meets specification requirements.

Xml

Class	Description
`SharedStringTableXmlMapper`	Class with 2 methods.
`StylesheetXmlMapper`	Class with 2 methods.
`WorkbookXmlMapper`	Class with 2 methods.
`WorksheetXmlMapper`	Class with 2 methods.
`XmlParsingException`	Class with 1 method.

Aspose.Cells FOSS for PHP

Core API

Interfaces

Navigation

Packaging

Interfaces

Validation

Xml

See Also