Aspose.Cells FOSS for Python

API reference for Aspose.Cells FOSS for Python v26.3.1. 130 public types organized by module.

Core API

ClassDescription
AgileEncryptionParametersParameters for Agile Encryption (ECMA-376 Part 2, Section 4).
AlignmentRepresents alignment settings for a cell or range of cells.
AutoFilterRepresents auto filters in a worksheet.
AutoFilterXMLLoaderHandles loading autofilter data from XML format for .xlsx files.
AutoFilterXMLWriterHandles writing autofilter data to XML format for .xlsx files.
BorderRepresents border settings for a single side of a cell or range of cells.
BordersRepresents border settings for all sides of a cell or range of cells.
CFBReaderReads encrypted XLSX from CFB format.
CFBWriterWrites CFB (Compound File Binary) files according to MS-CFB specification.
CFBWriterWrites encrypted XLSX to CFB format.
CSVHandlerHandles CSV import and export operations for workbooks.
CSVLoadOptionsOptions for loading CSV files.
CSVSaveOptionsOptions for saving CSV files.
CalculationPropertiesRepresents calculation properties for the workbook.
CellRepresents a single cell in a worksheet.
CellValueHandlerHandles cell value import and export operations according to ECMA-376 specification.
CellsRepresents a collection of cells in a worksheet.
ChartRepresents a chart in a worksheet.
ChartAxisRepresents a chart axis (category, value, or series).
ChartCollectionCollection of charts in a worksheet.
ChartErrorBarsRepresents error bars attached to a chart series.
ChartSeriesRepresents a single chart series.
ChartView3DRepresents chart-level 3D view settings.
ChartXmlLoaderLoads worksheet chart settings from drawing/chart XML parts.
ChartXmlSaverHandles writing chart-related XLSX parts:.
CommentXMLReaderHandles reading comment data from XML format.
CommentXMLWriterHandles writing comment data to XML format.
ConditionalFormatRepresents a single conditional formatting rule applied to a cell range.
ConditionalFormatCollectionRepresents a collection of conditional formats for a worksheet.
ConditionalFormatXMLLoaderHandles loading conditional formatting data from XML format for .xlsx files.
ConditionalFormatXMLWriterHandles writing conditional formatting data to XML format for .xlsx files.
CorePropertiesRepresents core document properties stored in docProps/core.xml.
DataValidationRepresents data validation settings for a range of cells.
DataValidationCollectionRepresents a collection of DataValidation objects for a worksheet.
DataValidationXmlLoaderLoads DataValidation objects from ECMA-376 SpreadsheetML XML format.
DataValidationXmlSaverSaves DataValidation objects to ECMA-376 SpreadsheetML XML format.
DefinedNameRepresents a defined name in the workbook.
DefinedNameCollectionCollection of defined names in the workbook.
DocumentPropertiesContainer for all document-level properties.
EncryptionParametersBase class for encryption parameters.
EncryptionVerifierEncryption verifier generation and validation.
ExtendedPropertiesRepresents extended/application properties stored in docProps/app.xml.
FileVersionRepresents file version information for the workbook.
FillRepresents fill settings for a cell or range of cells.
FilterColumnRepresents a filter column in an auto filter.
FontRepresents font settings for a cell or range of cells.
FormulaEvaluatorBasic formula evaluator for xlsx cells without cached values.
HeaderFooterRepresents header and footer settings.
HorizontalPageBreakCollectionCollection of manual horizontal page breaks (row breaks).
HyperlinkRepresents a hyperlink in a worksheet.
HyperlinkRelationshipWriterWrites hyperlink relationships to _rels files.
HyperlinkXMLLoaderLoads hyperlinks from worksheet XML and relationship files.
HyperlinkXMLSaverSaves hyperlinks to worksheet XML and relationship files.
HyperlinksCollection of hyperlinks in a worksheet.
JsonHandlerHandles JSON export operations for workbooks.
JsonSaveOptionsOptions for saving JSON files.
MarkdownHandlerHandles Markdown export operations for workbooks.
MarkdownSaveOptionsOptions for saving Markdown files.
MinimalCFBWriterMinimal CFB file writer for encrypted Office documents.
MsoFillFormatFill format properties for a shape.
MsoLineFormatBorder/outline format properties for a shape.
NSeriesCollection of series for a chart.
NumberFormatRepresents number format settings for a cell or range of cells.
PackageEncryptionPackage data encryption and decryption.
PageMarginsRepresents page margins.
PageSetupRepresents page setup settings.
PaneRepresents pane (freeze/split) settings.
PasswordDerivationPassword derivation helpers for Agile encryption.
PictureRepresents a worksheet picture anchored to cells.
PictureCollectionCollection of pictures in a worksheet.
PictureXmlLoaderLoads pictures from worksheet drawing parts.
PictureXmlSaverHandles writing picture-related drawing/media XML payloads.
PrintOptionsRepresents print options.
ProtectionRepresents protection settings for a cell or range of cells.
SelectionRepresents cell selection in a sheet view.
ShapeRepresents a drawing shape (rectangle, oval, text box, arrow, etc.) on a worksheet.
ShapeCollectionCollection of Shape objects on a worksheet.
ShapeFontFont properties for text inside a shape.
ShapeXmlLoaderLoads xdr:sp shape elements from a drawing XML part.
ShapeXmlSaverGenerates drawing XML and relationship XML for worksheet shapes.
SharedStringTableManages the Shared String Table for XLSX files according to ECMA-376 specification.
SheetFormatPropertiesRepresents sheet format properties.
SheetProtectionRepresents sheet protection settings.
SheetProtectionDictWrapperDictionary-like wrapper around SheetProtection for backward compatibility.
SheetViewRepresents a sheet view configuration.
SparklineOne sparkline: a data source range paired with the cell where it appears.
SparklineGroupA group of sparklines that share the same visual style.
SparklineGroupCollectionCollection of SparklineGroup objects (ws.sparkline_groups).
SparklineXmlLoaderLoads sparkline group data from the in a worksheet XML root.
SparklineXmlSaverSerialises SparklineGroupCollection to XML.
StandardEncryptionParametersParameters for Standard Encryption (ECMA-376 Part 2, Section 3).
StyleRepresents formatting settings for a cell or range of cells.
TableRepresents an Excel structured table (ECMA-376 §18.5).
TableCollectionCollection of Table objects belonging to a worksheet (ws.tables).
TableColumnSettings for a single table column.
TableStyleInfoVisual style settings for an Excel table.
TableXmlLoaderLoads table definitions from an XLSX ZIP archive into a worksheet.
TableXmlSaverSerialises Table objects to ECMA-376 table XML.
VerticalPageBreakCollectionCollection of manual vertical page breaks (column breaks).
WorkbookRepresents an Excel workbook.
WorkbookPrRepresents workbook properties (workbookPr element).
WorkbookPropertiesContainer for all workbook-level properties.
WorkbookPropertiesXMLLoaderHandles loading workbook properties from XML format for .xlsx files.
WorkbookPropertiesXMLWriterHandles writing workbook properties to XML format for .xlsx files.
WorkbookProtectionRepresents workbook protection settings.
WorkbookViewRepresents a workbook view configuration.
WorksheetRepresents a single worksheet in an Excel workbook.
WorksheetPropertiesContainer for all worksheet-level properties.
WorksheetPropertiesXMLLoaderHandles loading worksheet properties from XML format for .xlsx files.
WorksheetPropertiesXMLWriterHandles writing worksheet properties to XML format for .xlsx files.
XLSXDecryptorHandles decryption of XLSX files.
XLSXEncryptorHandles encryption of XLSX files.
XMLLoaderHandles loading of Excel workbook XML files.
XMLSaverHandles saving workbook data to XML format for .xlsx files.

Enumerations

EnumerationDescription
ChartTypeSupported chart types.
CipherAlgorithmCipher algorithm enumeration.
DataValidationAlertStyleSpecifies the style of the error alert displayed when invalid data is entered.
DataValidationImeModeSpecifies the Input Method Editor (IME) mode for CJK language input.
DataValidationOperatorSpecifies the comparison operator for data validation.
DataValidationTypeSpecifies the type of data validation.
EncryptionTypeEncryption type enumeration.
FillTypeShape fill type (ECMA-376 a:spPr fill child elements).
HashAlgorithmHash algorithm enumeration.
MsoDrawingTypeShape preset geometry types (maps to ECMA-376 a:prstGeom prst attributes).
MsoLineDashStyleShape border/line dash style (ECMA-376 a:prstDash val attribute).
SaveFormatSpecifies the format for saving a workbook.
SparklineEmptyCellsSparklineEmptyCells.ZERO represents treating empty cells as zero values in a sparkline.
SparklineTypeSparklineType.LINE represents a line sparkline type, displaying data as a continuous line.
TextAlignmentTypeHorizontal text alignment inside a shape (ECMA-376 a:pPr algn attribute).
TextAnchorTypeVertical text anchor inside a shape (ECMA-376 a:bodyPr anchor attribute).

See Also

 English