Specification

Aspose.Cells Cloud API Operation

• PostAnalyzeExcel : Perform business analysis of data in Excel files.
• GetWorksheetAutoFilter : Retrieve the description of auto filters from a worksheet.
• PutWorksheetDateFilter : Apply a date filter in the worksheet.
• PutWorksheetFilter : Add a filter for a column in the worksheet.
• PutWorksheetIconFilter : Add an icon filter in the worksheet.
• PutWorksheetCustomFilter : Filter a list with custom criteria in the worksheet.
• PutWorksheetDynamicFilter : Add a dynamic filter in the worksheet.
• PutWorksheetFilterTop10 : Filter the top 10 items in the list in the worksheet.
• PutWorksheetColorFilter : Add a color filter in the worksheet.
• PostWorksheetMatchBlanks : Match all blank cells in the list.
• PostWorksheetMatchNonBlanks : Match all not blank cells in the list.
• PostWorksheetAutoFilterRefresh : Refresh auto filters in the worksheet.
• DeleteWorksheetDateFilter : Remove a date filter in the worksheet.
• DeleteWorksheetFilter : Delete a filter for a column in the worksheet.
• GetWorksheetAutoshapes : Get autoshapes description in worksheet.
• GetWorksheetAutoshapeWithFormat : Get autoshape description in some format.
• PostBatchConvert : Batch converting files that meet specific matching conditions.
• PostBatchProtect : Batch protecting files that meet specific matching conditions.
• PostBatchLock : Batch locking files that meet specific matching conditions.
• PostBatchUnlock : Batch unlocking files that meet specific matching conditions.
• PostBatchSplit : Batch splitting files that meet specific matching conditions.
• PostClearContents : Clear cell area contents in the worksheet.
• PostClearFormats : Clear cell formats in the worksheet.
• PostUpdateWorksheetRangeStyle : Update cell range styles in the worksheet.
• PostWorksheetMerge : Merge cells in the worksheet.
• PostWorksheetUnmerge : Unmerge cells in the worksheet.
• GetWorksheetCells : Retrieve cell descriptions in a specified format.
• GetWorksheetCell : Retrieve cell data using either cell reference or method name in the worksheet.
• GetWorksheetCellStyle : Retrieve cell style descriptions in the worksheet.
• PostWorksheetCellSetValue : Set cell value using cell name in the worksheet.
• PostUpdateWorksheetCellStyle : Set cell style using cell name in the worksheet.
• PostSetCellRangeValue : Set the value of the range in the worksheet.
• PostCopyCellIntoCell : Copy data from a source cell to a destination cell in the worksheet.
• GetCellHtmlString : Retrieve the HTML string containing data and specific formats in this cell.
• PostSetCellHtmlString : Set the HTML string containing data and specific formats in this cell.
• PostCellCalculate : Calculate cell formula in the worksheet.
• PostCellCharacters : Set cell characters in the worksheet.
• GetWorksheetColumns : Retrieve descriptions of worksheet columns.
• PostSetWorksheetColumnWidth : Set worksheet column width.
• GetWorksheetColumn : Retrieve worksheet column data by column index.
• PutInsertWorksheetColumns : Insert worksheet columns in the worksheet.
• DeleteWorksheetColumns : Delete worksheet columns in the worksheet.
• PostHideWorksheetColumns : Hide worksheet columns in the worksheet.
• PostUnhideWorksheetColumns : Unhide worksheet columns in the worksheet.
• PostGroupWorksheetColumns : Group worksheet columns in the worksheet.
• PostUngroupWorksheetColumns : Ungroup worksheet columns.
• PostCopyWorksheetColumns : Copy data from source columns to destination columns in the worksheet.
• PostColumnStyle : Set column style in the worksheet.
• GetWorksheetRows : Retrieve descriptions of rows in the worksheet.
• GetWorksheetRow : Retrieve row data by the row’s index in the worksheet.
• DeleteWorksheetRow : Delete a row in the worksheet.
• DeleteWorksheetRows : Delete several rows in the worksheet.
• PutInsertWorksheetRows : Insert several new rows in the worksheet.
• PutInsertWorksheetRow : Insert a new row in the worksheet.
• PostUpdateWorksheetRow : Update height of rows in the worksheet.
• PostHideWorksheetRows : Hide rows in worksheet.
• PostUnhideWorksheetRows : Unhide rows in the worksheet.
• PostGroupWorksheetRows : Group rows in the worksheet.
• PostUngroupWorksheetRows : Ungroup rows in the worksheet.
• PostCopyWorksheetRows : Copy data and formats from specific entire rows in the worksheet.
• PostRowStyle : Apply formats to an entire row in the worksheet.
• GetCellsCloudServicesHealthCheck : Retrieve cell descriptions in a specified format.
• GetCellsCloudServiceStatus : Aspose.Cells Cloud service health status check.
• GetChartArea : Retrieve chart area description in the worksheet.
• GetChartAreaFillFormat : Retrieve chart area fill format description in the worksheet.
• GetChartAreaBorder : Retrieve chart area border description.
• GetWorksheetCharts : Retrieve descriptions of charts in the worksheet.
• GetWorksheetChart : Retrieve the chart in a specified format.
• PutWorksheetChart : Add a new chart in the worksheet.
• DeleteWorksheetChart : Delete a chart by index in the worksheet.
• PostWorksheetChart : Update chart properties in the worksheet.
• GetWorksheetChartLegend : Retrieve chart legend description in the worksheet.
• PostWorksheetChartLegend : Update chart legend in the worksheet.
• PutWorksheetChartLegend : Show chart legend in the worksheet.
• DeleteWorksheetChartLegend : Hides chart legend in the worksheet.
• DeleteWorksheetCharts : Clear the charts in the worksheets.
• GetWorksheetChartTitle : Retrieve chart title description in the worksheet.
• PostWorksheetChartTitle : Update chart title in the worksheet.
• PutWorksheetChartTitle : Set chart title in the worksheet.
• DeleteWorksheetChartTitle : Hide chart title in the worksheet.
• GetChartSeriesAxis : Retrieve descriptions of chart seriesaxis in the chart.
• GetChartCategoryAxis : Retrieve descriptions of chart series axis in the chart.
• GetChartValueAxis : Retrieve chart value axis in the chart.
• GetChartSecondCategoryAxis : Retrieve chart second category axis in the chart
• GetChartSecondValueAxis : Retrieve chart second value axis in the chart.
• PostChartSeriesAxis : Update chart series axis in the chart.
• PostChartCategoryAxis : Update chart category axis in the chart.
• PostChartValueAxis : Update chart value axis in the chart.
• PostChartSecondCategoryAxis : Update chart sencond category axis in the chart.
• PostChartSecondValueAxis : Update chart sencond value axis in the chart.
• GetWorksheetConditionalFormattings : Retrieve descriptions of conditional formattings in a worksheet.
• GetWorksheetConditionalFormatting : Retrieve conditional formatting descriptions in the worksheet.
• PutWorksheetConditionalFormatting : Add conditional formatting in the worksheet.
• PutWorksheetFormatCondition : Add a format condition in the worksheet.
• PutWorksheetFormatConditionArea : Add a cell area for the format condition in the worksheet.
• PutWorksheetFormatConditionCondition : Add a condition for the format condition in the worksheet.
• DeleteWorksheetConditionalFormattings : Clear all conditional formattings in the worksheet.
• DeleteWorksheetConditionalFormatting : Remove a conditional formatting.
• DeleteWorksheetConditionalFormattingArea : Remove cell area from conditional formatting.
• GetWorkbook : Retrieve workbooks in various formats.
• PutConvertWorkbook : Convert the workbook from the requested content into files in different formats.
• PostWorkbookSaveAs : Save an Excel file in various formats.
• PostConvertWorkbookToPDF : Convert Excel file to PDF files.
• PostConvertWorkbookToPNG : Convert Excel file to PNG files.
• PostConvertWorkbookToDocx : Convert Excel file to Docx files.
• PostConvertWorkbookToPptx : Convert Excel file to Pptx files.
• PostConvertWorkbookToHtml : Convert Excel file to HTML files.
• PostConvertWorkbookToMarkdown : Convert Excel file to Markdown files.
• PostConvertWorkbookToJson : Convert Excel file to Json files.
• PostConvertWorkbookToSQL : Convert Excel file to SQL Script files.
• PostConvertWorkbookToCSV : Convert Excel file to Csv files.
• PostExport : Export Excel internal elements or the workbook itself to various format files.
• PostWorkbookExportXML : Export XML data from an Excel file.When there are XML Maps in an Excel file, export XML data. When there is no XML map in the Excel file, convert the Excel file to an XML file.
• PostWorkbookImportJson : Import a JSON data file into the workbook. The JSON data file can either be a cloud file or data from an HTTP URI.
• PostWorkbookImportXML : Import an XML data file into an Excel file. The XML data file can either be a cloud file or data from an HTTP URI.
• PostImportData : Import data into the Excel file.
• PostWorkbookDataCleansing : Data cleaning of spreadsheet files is a data management process used to identify, correct, and remove errors, incompleteness, duplicates, or inaccuracies in tables and ranges.
• PostDataCleansing : Data cleansing of spreadsheet files is a data management process used to identify, correct, and remove errors, incompleteness, duplicates, or inaccuracies in tables and ranges.
• PostWorkbookDataDeduplication : Data deduplication of spreadsheet files is mainly used to eliminate duplicate data in tables and ranges.
• PostDataDeduplication : Data deduplication of spreadsheet files is mainly used to eliminate duplicate data in tables and ranges.
• PostWorkbookDataFill : Data filling for spreadsheet files is primarily used to fill empty data in tables and ranges.
• PostDataFill : Data filling for spreadsheet files is primarily used to fill empty data in tables and ranges.
• PostDeleteIncompleteRows : Deleting incomplete rows of spreadsheet files is mainly used to eliminate incomplete rows in tables and ranges.
• PostDataTransformation : Transform spreadsheet data is mainly used to pivot columns, unpivot columns.
• GetWorksheetHyperlinks : Retrieve descriptions of hyperlinks in the worksheet.
• GetWorksheetHyperlink : Retrieve hyperlink description by index in the worksheet.
• DeleteWorksheetHyperlink : Delete hyperlink by index in the worksheet.
• PostWorksheetHyperlink : Update hyperlink by index in the worksheet.
• PutWorksheetHyperlink : Add hyperlink in the worksheet.
• DeleteWorksheetHyperlinks : Delete all hyperlinks in the worksheet.
• PostAssemble : Assemble data files with template files to generate files in various formats.
• PostCompress : Compress files and generate target files in various formats, supported file formats are include Xls, Xlsx, Xlsm, Xlsb, Ods and more.
• PostMerge : Merge cells in the worksheet.
• PostSplit : Split Excel spreadsheet files based on worksheets and create output files in various formats.
• PostSearch : Search for specified text within Excel files.
• PostReplace : Replace specified text with new text in Excel files.
• PostImport : Import data into an Excel file and generate output files in various formats.
• PostWatermark : Add Text Watermark to Excel files and generate output files in various formats.
• PostClearObjects : Clear internal elements in Excel files and generate output files in various formats.
• PostReverse : Reverse rows or columns in Excel files and create output files in various formats.
• PostRepair : Repair abnormal files and generate files in various formats.
• PostRotate : Rotate rows, columns, or other objects in Excel files and save them in various formats.
• PostMetadata : Update document properties in Excel file, and save them is various formats.
• GetMetadata : Get cells document properties.
• DeleteMetadata : Delete cells document properties in Excel file, and save them is various formats.
• GetWorksheetListObjects : Retrieve descriptions of ListObjects in the worksheet.
• GetWorksheetListObject : Retrieve list object description by index in the worksheet.
• PutWorksheetListObject : Add a ListObject in the worksheet.
• DeleteWorksheetListObjects : Delete ListObjects in the worksheet.
• DeleteWorksheetListObject : Delete list object by index in the worksheet.
• PostWorksheetListObject : Update list object by index in the worksheet.
• PostWorksheetListObjectConvertToRange : Convert list object to range in the worksheet.
• PostWorksheetListObjectSummarizeWithPivotTable : Create a pivot table with a list object in the worksheet.
• PostWorksheetListObjectSortTable : Sort list object in the worksheet.
• PostWorksheetListObjectRemoveDuplicates : Remove duplicates in list object.
• PostWorksheetListObjectInsertSlicer : Insert slicer for list object.
• PostWorksheetListColumn : Update list column in list object.
• PostWorksheetListColumnsTotal : Update total of list columns in the table.
• GetWorksheetOleObjects : Retrieve descriptions of OLE objects in the worksheet.
• GetWorksheetOleObject : Retrieve the OLE object in a specified format in the worksheet.
• DeleteWorksheetOleObjects : Delete all OLE objects in the worksheet.
• DeleteWorksheetOleObject : Delete an OLE object in the worksheet.
• PostUpdateWorksheetOleObject : Update an OLE object in worksheet.
• PutWorksheetOleObject : Add an OLE object in the worksheet.
• GetVerticalPageBreaks : Retrieve descriptions of vertical page breaks in the worksheet.
• GetHorizontalPageBreaks : Retrieve descriptions of horizontal page breaks in the worksheet.
• GetVerticalPageBreak : Retrieve a vertical page break description in the worksheet.
• GetHorizontalPageBreak : Retrieve a horizontal page break descripton in the worksheet.
• PutVerticalPageBreak : Add a vertical page break in the worksheet.
• PutHorizontalPageBreak : Add a horizontal page breaks in the worksheet.
• DeleteVerticalPageBreaks : Delete vertical page breaks in the worksheet.
• DeleteHorizontalPageBreaks : Delete horizontal page breaks in the worksheet.
• DeleteVerticalPageBreak : Delete a vertical page break in the worksheet.
• DeleteHorizontalPageBreak : Delete a horizontal page break in the worksheet.
• GetPageSetup : Retrieve page setup description in the worksheet.
• PostPageSetup : Update page setup in the worksheet.
• DeleteHeaderFooter : Clear header and footer in the worksheet.
• GetHeader : Retrieve page header description in the worksheet.
• PostHeader : Update page header in the worksheet.
• GetFooter : Retrieve page footer description in the worksheet.
• PostFooter : Update page footer in the worksheet.
• PostFitWideToPages : Set the scale at which the page will fit wide when printed on the sheet.
• PostFitTallToPages : Set the scale at which the page will fit tall when printed on the sheet.
• GetWorksheetPictures : Retrieve descriptions of pictures in the worksheet.
• GetWorksheetPictureWithFormat : Retrieve a picture by number in the worksheet.
• PutWorksheetAddPicture : Add a new picture in the worksheet.
• PostWorksheetPicture : Update a picture by index in the worksheet.
• DeleteWorksheetPicture : Delete a picture object by index in the worksheet.
• DeleteWorksheetPictures : Delete all pictures in the worksheet.
• GetWorksheetPivotTables : Retrieve descriptions of pivottables in the worksheet.
• GetWorksheetPivotTable : Retrieve PivotTable information by index in the worksheet.
• GetPivotTableField : Retrieve descriptions of pivot fields in the PivotTable.
• GetWorksheetPivotTableFilters : Gets PivotTable filters in worksheet.
• GetWorksheetPivotTableFilter : Retrieve PivotTable filters in the worksheet.
• PutWorksheetPivotTable : Add a PivotTable in the worksheet.
• PutPivotTableField : Add a pivot field in the PivotTable.
• PutWorksheetPivotTableFilter : Add a pivot filter to the PivotTable.
• PostPivotTableFieldHideItem : Hide a pivot field item in the PivotTable.
• PostPivotTableFieldMoveTo : Move a pivot field in the PivotTable.
• PostPivotTableCellStyle : Update cell style in the PivotTable.
• PostPivotTableStyle : Update style in the PivotTable.
• PostPivotTableUpdatePivotFields : Update pivot fields in the PivotTable.
• PostPivotTableUpdatePivotField : Update pivot field in the PivotTable.
• PostWorksheetPivotTableCalculate : Calculate pivottable’s data to cells.
• PostWorksheetPivotTableMove : Move PivotTable in the worksheet.
• DeleteWorksheetPivotTables : Delete PivotTables in the worksheet.
• DeleteWorksheetPivotTable : Delete PivotTable by index in the worksheet.
• DeletePivotTableField : Delete a pivot field in the PivotTable.
• DeleteWorksheetPivotTableFilters : Delete all pivot filters in the PivotTable.
• DeleteWorksheetPivotTableFilter : Delete a pivot filter in the PivotTable.
• GetDocumentProperties : Retrieve descriptions of Excel file properties.
• PutDocumentProperty : Set or add an Excel property.
• GetDocumentProperty : Get Excel property by name.
• DeleteDocumentProperty : Delete an Excel property.
• DeleteDocumentProperties : Delete all custom document properties and reset built-in ones.
• PostDigitalSignature : Excel file digital signature.
• PostEncryptWorkbook : Excel Encryption.
• DeleteDecryptWorkbook : Excel files decryption.
• PostProtectWorkbook : Excel protection.
• DeleteUnProtectWorkbook : Excel unprotection.
• PutDocumentProtectFromChanges : Excel file write protection.
• DeleteDocumentUnProtectFromChanges : Excel file cancel write protection.
• PostUnlock : Unlock Excel files.
• PostLock : Lock Excel files.
• PostProtect : Excel files encryption.
• PostWorksheetCellsRangesCopy : Copy content from the source range to the destination range in the worksheet.
• PostWorksheetCellsRangeMerge : Merge a range of cells into a single cell.
• PostWorksheetCellsRangeUnMerge : Unmerge merged cells within this range.
• PostWorksheetCellsRangeStyle : Set the style for the specified range.
• GetWorksheetCellsRangeValue : Retrieve the values of cells within the specified range.
• PostWorksheetCellsRangeValue : Assign a value to the range; if necessary, the value will be converted to another data type, and the cell’s number format will be reset.
• PostWorksheetCellsRangeMoveTo : Move the current range to the destination range.
• PostWorksheetCellsRangeSort : Perform data sorting around a range of cells.
• PostWorksheetCellsRangeOutlineBorder : Apply an outline border around a range of cells.
• PostWorksheetCellsRangeColumnWidth : Set the column width of the specified range.
• PostWorksheetCellsRangeRowHeight : Sets row height of range.
• PutWorksheetCellsRange : Insert a range of cells and shift existing cells based on the specified shift option.
• DeleteWorksheetCellsRange : Delete a range of cells and shift existing cells based on the specified shift option.
• GetWorksheetShapes : Retrieve descriptions of shapes in the worksheet.
• GetWorksheetShape : Retrieve description of shape in the worksheet.
• PutWorksheetShape : Add a shape in the worksheet.
• DeleteWorksheetShapes : Delete all shapes in the worksheet.
• DeleteWorksheetShape : Delete a shape in the worksheet.
• PostWorksheetShape : Update a shape in the worksheet.
• PostWorksheetGroupShape : Group shapes in the worksheet.
• PostWorksheetUngroupShape : Ungroup shapes in the worksheet.
• GetWorksheetSparklineGroups : Retrieve descriptions of sparkline groups in the worksheet.
• GetWorksheetSparklineGroup : Retrieve description of a sparkline group in the worksheet.
• DeleteWorksheetSparklineGroups : Delete sparkline groups in the worksheet.
• DeleteWorksheetSparklineGroup : Delete a sparkline group in the worksheet.
• PutWorksheetSparklineGroup : Add a sparkline group in the worksheet.
• PostWorksheetSparklineGroup : Update a sparkline group in the worksheet.
• PostRunTask : Run tasks.
• GetWorkbookDefaultStyle : Retrieve the description of the default style for the workbook.
• GetWorkbookTextItems : Retrieve text items in the workbook.
• GetWorkbookNames : Retrieve named ranges in the workbook.
• PutWorkbookName : Define a new name in the workbook.
• GetWorkbookName : Retrieve description of a named range in the workbook.
• PostWorkbookName : Update a named range in the workbook.
• GetWorkbookNameValue : Retrieve the value of a named range in the workbook.
• DeleteWorkbookNames : Delete all named ranges in the workbook.
• DeleteWorkbookName : Delete a named range in the workbook.
• PostWorkbooksMerge : Merge a workbook into the existing workbook.
• PostWorkbooksTextSearch : Search for text in the workbook.
• PostWorkbookTextReplace : Replace text in the workbook.
• PostWorkbookGetSmartMarkerResult : Smart marker processing.
• PutWorkbookCreate : Create a new workbook using different methods.
• PostWorkbookSplit : Split the workbook with a specific format.
• PostWorkbookCalculateFormula : Calculate all formulas in the workbook.
• PostAutofitWorkbookRows : Autofit rows in the workbook.
• PostAutofitWorkbookColumns : Autofit columns in the workbook.
• GetWorkbookSettings : Retrieve descriptions of workbook settings.
• PostWorkbookSettings : Update setting in the workbook.
• PutWorkbookBackground : Set background in the workbook.
• DeleteWorkbookBackground : Delete background in the workbook.
• PutWorkbookWaterMarker : Set water marker in the workbook.
• GetPageCount : Get page count in the workbook.
• GetWorksheets : Retrieve the description of worksheets from a workbook.
• GetWorksheetWithFormat : Retrieve the worksheet in a specified format from the workbook.
• PutChangeVisibilityWorksheet : Change worksheet visibility in the workbook.
• PutActiveWorksheet : Set active worksheet index in the workbook.
• PutInsertNewWorksheet : Insert a new worksheet in the workbook.
• PutAddNewWorksheet : Add a new worksheet in the workbook.
• DeleteWorksheet : Delete a worksheet in the workbook.
• DeleteWorksheets : Delete matched worksheets in the workbook.
• PostMoveWorksheet : Move worksheet in the workbook.
• PutProtectWorksheet : Protect worksheet.
• DeleteUnprotectWorksheet : Unprotect worksheet.
• GetWorksheetTextItems : Retrieve text items in the worksheet.
• GetWorksheetComments : Retrieve the description of comments in the worksheet.
• GetWorksheetComment : Retrieve the description of comment in the worksheet.
• PutWorksheetComment : Add cell comment in the worksheet.
• PostWorksheetComment : Update cell comment in the worksheet.
• DeleteWorksheetComment : Delete cell comment in the worksheet.
• DeleteWorksheetComments : Delete all comments in the worksheet.
• GetWorksheetMergedCells : Get worksheet merged cells.
• GetWorksheetMergedCell : Retrieve description of a merged cell by its index in the worksheet.
• GetWorksheetCalculateFormula : Calculate formula in the worksheet.
• PostWorksheetCalculateFormula : Calculate formula in the worksheet.
• PostWorksheetTextSearch : Search for text in the worksheet.
• PostWorksheetTextReplace : Replace old text with new text in the worksheet.
• PostWorksheetRangeSort : Sort a range in the worksheet.
• PostAutofitWorksheetRow : Autofit a row in the worksheet.
• PostAutofitWorksheetRows : Autofit rows in the worksheet.
• PostAutofitWorksheetColumns : Autofit columns in the worksheet.
• PutWorksheetBackground : Set background image in the worksheet.
• DeleteWorksheetBackground : Delete background image in the worksheet.
• PutWorksheetFreezePanes : Set freeze panes in the worksheet.
• DeleteWorksheetFreezePanes : Unfreeze panes in worksheet.
• PostCopyWorksheet : Copy contents and formats from another worksheet.
• PostRenameWorksheet : Rename worksheet in the workbook.
• PostUpdateWorksheetProperty : Update worksheet properties in the workbook.
• GetNamedRanges : Retrieve descriptions of ranges in the worksheets.
• GetNamedRangeValue : Retrieve values in range.
• PostUpdateWorksheetZoom : Update the scaling percentage in the worksheet. It should be between 10 and 400.
• GetWorksheetPageCount : Get page count in the worksheet.
• GetWorksheetValidations : Retrieve descriptions of validations in the worksheet.
• GetWorksheetValidation : Retrieve a validation by its index in the worksheet.
• PutWorksheetValidation : Add a validation at index in the worksheet.
• PostWorksheetValidation : Update a validation by index in the worksheet.
• DeleteWorksheetValidation : Delete a validation by index in worksheet.
• DeleteWorksheetValidations : Delete all validations in the worksheet.

Aspose.Cells Cloud API Model

• ObjectExistsExtensions :
• FileVersion :
• StorageFile : File or folder information
• GoogleDriveStorageFile :
• AboveAverage : Describe the AboveAverage conditional formatting rule. This conditional formatting rule highlights cells that are above or below the average for all values in the range.
• AbstractCalculationEngine : Represents user’s custom calculation engine to extend the default calculation engine of Aspose.Cells.
• AbstractCalculationMonitor : Monitor for user to track the progress of formula calculation.
• AutoFilter : Represents autofiltering for the specified worksheet.
• AutoFitterOptions : Represents all auto fitter options.
• Border : Encapsulates the object that represents the cell border.
• CalculationOptions : Represents options for calculation.
• Cell : Encapsulates the object that represents a single Workbook cell.
• CellArea : Represent an area of cells.
• Cells : Encapsulates a collection of cell relevant objects, such as Aspose.Cells.Cell, Aspose.Cells.Row, …etc.
• CellsCloudFileInfo : Cells Cloud File information description.
• CellsColor : Represents all types of color.
• CellsDocumentProperties : Excel properties
• CellsDocumentProperty : Cells document property.
• Color : Color.
• ColorFilter : Color filter.
• ColorScale : Describe the ColorScale conditional formatting rule. This conditional formatting rule creates a gradated color scale on the cells.
• Column : Represents a single column in a worksheet.
• Columns : Columns
• Comment : Encapsulates the object that represents a cell comment.
• Comments : Encapsulates a collection of objects.
• ConditionalFormatting :
• ConditionalFormattingIcon : Represents the custom icon of conditional formatting rule.
• ConditionalFormattings : Encapsulates a collection of objects.
• ConditionalFormattingValue : Describes the values of the interpolation points in a gradient scale, dataBar or iconSet.
• CopyOptions : Represents the copy options.
• CriteriaMultipleFilter :
• CustomFilter : Represents the custom filter.
• DataBar : Describe the DataBar conditional formatting rule. This conditional formatting rule displays a gradated data bar in the range of cells.
• DataBarBorder : Represents the border of the data bars specified by a conditional formatting rule.
• DataCleansing : Represents data cleansing.
• DataColumnFillValue : Represents that the data column is populated with the specified value.
• DataFill : Represents data filling.
• DataFillValue : Represents that the data is populated with the specified value.
• DataItem : Represents data item.
• DataItemType : Represents data item type.
• DataSorter : Summary description for DataSorter.
• DataSorterKey : Represents the key of the data sorter.
• DataSource : Represents data source.
• DataSourceType : Represents data source type.
• DateTimeGroupItem : Represents the datetime’s group setting.
• DeduplicationRegion : Represents data deduplication region.
• DynamicFilter : Represents the dynamic filter.
• FileInfo : Represents file information.
• FileSource :
• FileSourceType :
• FilesResult :
• FilterColumn : Represents a filter for a single column. The Filter object is a member of the Filters collection
• Font : Encapsulates the font object used in a spreadsheet.
• FontSetting : Represents a range of characters within the cell text.
• FormatCondition : Represents conditional formatting condition.
• FormulaFormatCondition :
• FormulaSettings : Settings of formulas and calculation.
• GlobalizationSettings : Represents the globalization settings.
• HorizontalPageBreak : Encapsulates the object that represents a horizontal page break.
• HorizontalPageBreaks : Encapsulates a collection of objects.
• Hyperlink : Encapsulates the object that represents a hyperlink.
• Hyperlinks : Encapsulates a collection of objects.
• IconFilter : Represents icon filter.
• IconSet : Describe the IconSet conditional formatting rule. This conditional formatting rule applies icons to cells according to their values.
• Link :
• LinkElement :
• LoadOptions : Represents the options of loading the file.
• MergedCell :
• MergedCells :
• MultipleFilter :
• MultipleFilters : Represents the multiple filter collection.
• Name : Represents a defined name for a range of cells.
• Names : Represents a collection of all the objects in the spreadsheet.
• NegativeBarFormat : Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule.
• PageSection :
• PageSetup : excel print page setting
• PasteOptions : Represents the paste special options.
• PdfSecurityOptions : Options for encrypting and access permissions for a PDF document. PDF/A does not allow security setting.
• Protection : Represents the various types of protection options available for a worksheet.
• ProtectSheetParameter :
• Range : Encapsulates the object that represents a range of cells within a spreadsheet.
• Ranges : Encapsulates a collection of objects.
• Row : Represents a single row in a worksheet.
• Rows : Collects the objects that represent the individual rows in a worksheet.
• SaveResult : Represents save result.
• PaginatedSaveOptions : Represents the options for pagination.
• SingleValue : Represents single value.
• SortKey : Represents sort key.
• SplitResult : Represents the result of the file split.
• Style : Represents display style of excel document,such as font,color,alignment,border,etc. The Style object contains all style attributes (font, number format, alignment, and so on) as properties.
• StyleFormatCondition : Represents style format condition.
• Styles : Represents data style collection.
• TextFormatCondition : Represents text format condition.
• TextItem : Represents text item.
• TextItems : Represents text item collection.
• TextOptions : Represents the text options.
• ThemeColor : Represents a theme color.
• TimePeriodFormatCondition : Represents time period format condition.
• Top10 : Describe the Top10 conditional formatting rule. This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified.
• Top10Filter : Represents the top 10 filter.
• Validation : Represents data validation.settings.
• Validations : Represents data validation collection.
• VerticalPageBreak : Encapsulates the object that represents a vertical page break.
• VerticalPageBreaks : Encapsulates a collection of objects.
• Workbook : Represents a root object to create an Excel spreadsheet.
• WorkbookSettings : Represents all settings of the workbook.
• Worksheet : Encapsulates the object that represents a single worksheet.
• Worksheets : Encapsulates a collection of objects.
• WriteProtection : Specifies write protection settings for a workbook.
• XmlDataBinding : Represents Xml Data Binding information.
• XmlMap : Represents Xml map information.
• CellsObjectOperateTaskParameter : Represents cells object operate task parameter.
• ConvertTaskParameter : Represents convert task parameter.
• ConvertWorksheetTaskParameter : Represents convert worksheet task parameter.
• ImportDataTaskParameter : Represents import data task parameter.
• ResultDestination : Represents result destination.
• ResultDestinationType : Represents result destination type.
• ResultSource : Represents result source type.
• SaveFilesToCloudResult : Represents save file to cloud result.
• SaveResultTaskParameter : Represents save result task parameter.
• SmartMarkerTaskParameter : Represents smart marker task parameter.
• SplitWorkbookTaskParameter : Represents split workbook task parameter.
• TaskData : Represents task data.
• TaskDescription : Represents task description.
• TaskParameter : Represents task parameter.
• TaskResultParameter : Represents task result parameter.
• TaskRunResult : Represents task run result.
• TaskType : Represents task type.
• ChartOperateParameter : Represents chart operate parameter.
• ListObjectOperateParameter : Represents list object operate parameter.
• OperateObject : Represents operate object.
• OperateObjectPosition : Represents operate object position.
• OperateObjectType : Represents operate object type.
• OperateParameter : Represents operate parameter.
• OperateType : Represents operate type.
• PageBreakOperateParameter : Represents page break operate parameter.
• PageSetupOperateParameter : Represents page setup operate parameter.
• PivotTableOperateParameter : Represents pivot table operate parameter.
• ShapeOperateParameter : Represents shape operate parameter.
• WorkbookOperateParameter : Represents workbook operate parameter.
• WorkbookSettingsOperateParameter : Represents workbook setting operate parameter.
• WorksheetOperateParameter : Represents worksheet operate parameter.
• ListColumn : Represents a column in a Table.
• ListObject : Represents a list object on a worksheet. The ListObject object is a member of the ListObjects collection. The ListObjects collection contains all the list objects on a worksheet.
• ListObjects : Represents a collection of objects in the worksheet.
• PivotGlobalizationSettings : Represents the globalization settings for pivot tables.
• DifSaveOptions : Represents the options of saving dif file.
• DocxSaveOptions : Represents options of saving .docx file.
• HtmlSaveOptions : Represents options of saving .html file.
• ImageSaveOptions : Represents options of saving image file.
• JsonSaveOptions : Represents options of saving .json file.
• MarkdownSaveOptions : Represents options of saving .md file.
• MHtmlSaveOptions : Represents options of saving .mhtml file.
• OdsSaveOptions : Represents options of saving .ods file.
• OoxmlSaveOptions : Represents options of saving ooxml file.
• PdfSaveOptions : Represents options of saving pdf file.
• PptxSaveOptions : Represents the options of saving pptx file.
• SaveOptions : Represents all save options
• SpreadsheetML2003SaveOptions : Represents the options of saving .xml file.
• SqlScriptSaveOptions : Represents the options of saving .sql file.
• SvgSaveOptions : Represents the options of saving .svg file.
• TxtSaveOptions : Represents the options of saving .txt file.
• XlsbSaveOptions : Represents the options of saving .xlsb file.
• XlsSaveOptions : Represents the options of saving .xls file.
• XpsSaveOptions : Represents the options of saving .xps file.
• ArcShapeResponse : Represents the ArcShape Response.
• AutoFilterResponse : Represents the AutoFilter Response.
• AutoShapeResponse : Represents the AutoShape Response.
• AutoShapesResponse : Represents the AutoShapes Response.
• AxisResponse : Represents the Axis Response.
• BorderResponse : Represents the Border Response.
• ButtonResponse : Represents the Button Response.
• CalculateFormulaResponse : Represents the CalculateFormula Response.
• CellResponse : Represents the Cell Response.
• CellsCloudFileInfoResponse : Represents the CellsCloudFileInfo Response.
• CellsCloudResponse : Represents the CellsCloud Response.
• CellsDocumentPropertiesResponse : Represents the CellsDocumentProperties Response.
• CellsDocumentPropertyResponse : Represents the CellsDocumentProperty Response.
• CellsDrawingResponse : Represents the CellsDrawing Response.
• CellsResponse : Represents the Cells Response.
• ChartAreaResponse : Represents the ChartArea Response.
• ChartDataTableResponse : Represents the ChartDataTable Response.
• ChartPointResponse : Represents the ChartPoint Response.
• ChartPointsResponse : Represents the ChartPoints Response.
• ChartResponse : Represents the Chart Response.
• ChartsResponse : Represents the Charts Response.
• CheckBoxResponse : Represents the CheckBox Response.
• ColumnResponse : Represents the Column Response.
• ColumnsResponse : Represents the Columns Response.
• ComboBoxResponse : Represents the ComboBox Response.
• CommentResponse : Represents the Comment Response.
• CommentShapeResponse : Represents the CommentShape Response.
• CommentsResponse : Represents the Comments Response.
• ConditionalFormattingResponse : Represents the ConditionalFormatting Response.
• ConditionalFormattingsResponse : Represents the ConditionalFormattings Response.
• DataLabelsResponse : Represents the DataLabels Response.
• DisplayUnitLabelResponse : Represents the DisplayUnitLabel Response.
• DropBarsResponse : Represents the DropBars Response.
• ErrorBarResponse : Represents the ErrorBar Response.
• FillFormatResponse : Represents the FillFormat Response.
• FindResponse : Represents the Find Response.
• FloorResponse : Represents the Floor Response.
• FormResponse : Represents the Form Response.
• FormsResponse : Represents the Forms Response.
• GroupBoxResponse : Represents the GroupBox Response.
• HorizontalPageBreakResponse : Represents the HorizontalPageBreak Response.
• HorizontalPageBreaksResponse : Represents the HorizontalPageBreaks Response.
• HyperlinkResponse : Represents the Hyperlink Response.
• HyperlinksResponse : Represents the Hyperlinks Response.
• LabelResponse : Represents the Label Response.
• LegendEntriesResponse : Represents the LegendEntries Response.
• LegendEntryResponse : Represents the LegendEntry Response.
• LegendResponse : Represents the Legend Response.
• LineResponse : Represents the Line Response.
• LineShapeResponse : Represents the LineShape Response.
• ListBoxResponse : Represents the ListBox Response.
• ListObjectResponse : Represents the ListObject Response.
• ListObjectsResponse : Represents the ListObjects Response.
• MergedCellResponse : Represents the MergedCell Response.
• MergedCellsResponse : Represents the MergedCells Response.
• NameResponse : Represents the Name Response.
• NamesResponse : Represents the Names Response.
• OleObjectResponse : Represents the OleObject Response.
• OleObjectsResponse : Represents the OleObjects Response.
• OvalResponse : Represents the Oval Response.
• PageSectionsResponse : Represents the PageSections Response.
• PageSetupResponse : Represents the PageSetup Response.
• PictureResponse : Represents the Picture Response.
• PicturesResponse : Represents the Pictures Response.
• PivotFieldResponse : Represents the PivotField Response.
• PivotFilterResponse : Represents the PivotFilter Response.
• PivotFiltersResponse : Represents the PivotFilters Response.
• PivotTableResponse : Represents the PivotTable Response.
• PivotTablesResponse : Represents the PivotTables Response.
• PlotAreaResponse : Represents the PlotArea Response.
• RadioButtonResponse : Represents the RadioButton Response.
• RangeResponse : Represents the Range Response.
• RangesResponse : Represents the Ranges Response.
• RangeValueResponse : Represents the RangeValue Response.
• RectangleShapeResponse : Represents the RectangleShape Response.
• RowResponse : Represents the Row Response.
• RowsResponse : Represents the Rows Response.
• SaveFilesToCloudResultResponse : Represents the SaveFilesToCloudResult Response.
• SaveResponse : Represents the Save Response.
• ScrollBarResponse : Represents the ScrollBar Response.
• SeriesesResponse : Represents the Serieses Response.
• SeriesResponse : Represents the Series Response.
• ShapeResponse : Represents the Shape Response.
• ShapesResponse : Represents the Shapes Response.
• SingleValueResponse : Represents the SingleValue Response.
• SparklineGroupResponse : Represents the SparklineGroup Response.
• SparklineGroupsResponse : Represents the SparklineGroups Response.
• SpinnerResponse : Represents the Spinner Response.
• SplitResultResponse : Represents the SplitResult Response.
• StyleResponse : Represents the Style Response.
• TaskRunResultResponse : Represents the TaskRunResult Response.
• TextBoxResponse : Represents the TextBox Response.
• TextItemResponse : Represents the TextItem Response.
• TextItemsResponse : Represents the TextItems Response.
• TickLabelsResponse : Represents the TickLabels Response.
• TitleResponse : Represents the Title Response.
• TrendlineResponse : Represents the Trendline Response.
• TrendlinesResponse : Represents the Trendlines Response.
• ValidationResponse : Represents the Validation Response.
• ValidationsResponse : Represents the Validations Response.
• VerticalPageBreakResponse : Represents the VerticalPageBreak Response.
• VerticalPageBreaksResponse : Represents the VerticalPageBreaks Response.
• WallsResponse : Represents the Walls Response.
• WorkbookReplaceResponse : Represents the WorkbookReplace Response.
• WorkbookResponse : Represents the Workbook Response.
• WorkbookSettingsResponse : Represents the WorkbookSettings Response.
• WorkbooksResponse : Represents the Workbooks Response.
• WorksheetReplaceResponse : Represents the WorksheetReplace Response.
• WorksheetResponse : Represents the Worksheet Response.
• WorksheetsResponse : Represents the Worksheets Response.
• AnalyzeExcelRequest :
• BatchConvertRequest : Indicates batch convert file request
• BatchLockRequest : Indicates batch lock file request
• BatchProtectRequest : Indicates batch protect file request
• BatchSplitRequest :
• ColorFilterRequest : Indicates color filter request
• ConvertParameter : Indicates convert parameter
• CreatePivotTableRequest : Indicates create pivot table request
• DataCleansingRequest : A data cleansing request for an Spreadsheet file.
• DataDeduplicationRequest :
• DataFillRequest :
• DataTransformationRequest :
• DeleteIncompleteRowsRequest :
• ImportJsonRequest : Indicates import xml data request
• ImportXMLRequest : Indicates import xml data request
• MatchConditionRequest : Indicates the match condition that needs to be processed for the file name.
• PasswordRequest : Used for password data transfer.
• PivotTableFieldRequest : Indicates pivot table field request
• ProtectWorkbookRequest : Indicates protect workbook request
• RangeCopyRequest : Indicates range copy request
• RangeSetOutlineBorderRequest : Indicates range set outline border request.
• RangeSetStyleRequest : Indicates range set style request.
• RangeSortRequest : Indicates range sort request
• TableTotalRequest : Indicates table total request
• TextWaterMarkerRequest : Indicates text water marker request.
• WorkbookEncryptionRequest : Used by workbook encryption/decryption requests.
• WorkbookProtectionRequest : Used by workbook protection requests.
• WorksheetMovingRequest : Used by workbook moving requests.
• ImageOrPrintOptions : Allows to specify options when rendering worksheet to images, printing worksheet or rendering chart to image.
• RenderingFont : Font for rendering.
• RenderingWatermark : Watermark for rendering.
• JoinType :
• LoadData : Loading data information.
• LoadTo :
• MergeQueries : Represents merge quesies.
• PivotColumn :
• QueryDataSource :
• QueryDataSourceDataType :
• QueryTable : Represents QueryTable information.
• Transformation :
• UnpivotColumn :
• PivotField : Represents a field in a PivotTable report.
• PivotFilter : Represents a PivotFilter in PivotFilter Collection.
• PivotItem : Represents a item in a PivotField report.
• PivotTable : Summary description for PivotTable.
• PivotTables : Represents the collection of all the PivotTable objects on the specified worksheet.
• CellValue : Represents the cell value and corresponding type.
• CustomParserConfig :
• Import2DimensionDoubleArrayOption :
• Import2DimensionIntArrayOption :
• Import2DimensionStringArrayOption :
• ImportBatchDataOption :
• ImportCSVDataOption :
• ImportDataType :
• ImportDoubleArrayOption :
• ImportIntArrayOption :
• ImportOption :
• ImportPictureOption :
• ImportPosition :
• ImportStringArrayOption :
• ArcShape : Represents the arc shape.
• Area : Encapsulates the object that represents an area format.
• AutoShape : Represents an AutoShape.
• AutoShapes :
• Button : Represents the Forms control: Button
• CellsDrawing : Represents the auto shape and drawing object.
• CheckBox : Represents a check box object in a worksheet.
• ComboBox : Represents the control form ComboBox.
• CommentShape : Represents the shape of the comment.
• FillFormat : Encapsulates the object that represents fill formatting for a shape.
• Form :
• Forms :
• GradientFill : Represents the gradient fill.
• GradientFillStop :
• GroupBox : Encapsulates the object that represents a groupbox in a spreadsheet.
• GroupShape : Represents the group shape which contains the individual shapes.
• Label : Encapsulates the object that represents a label in a spreadsheet.
• Line : Encapsulates the object that represents the line format.
• LineFormat : Represents all setting of the line.
• LineShape : Represents the line shape.
• ListBox : Represents a list box object.
• OleObject : Represents an OleObject in a worksheet.
• OleObjects : Represents embedded OLE objects.
• Oval : Represents the oval shape.
• PatternFill : Encapsulates the object that represents pattern fill format
• PicFormatOption : Represents picture format option
• Picture : Encapsulates the object that represents a single picture in a spreadsheet.
• Pictures : Encapsulates a collection of objects.
• RadioButton : Represents a radio button.
• RectangleShape : Represents the rectangle shape.
• ScrollBar : Represents a scroll bar object.
• ShadowEffect : This class specifies the shadow effect of the chart element or shape.
• Shape : Represents the msodrawing object.
• Shapes : Represents all the shape in a worksheet/chart.
• SolidFill : Encapsulates the object that represents solid fill format
• Spinner : Represents the Forms control: Spinner.
• TextBox : Encapsulates the object that represents a textbox in a spreadsheet.
• TextureFill : Encapsulates the object that represents texture fill format
• TilePicOption : Represents tile picture as texture.
• DigitalSignature : Signature in file.
• Axis : Encapsulates the object that represents an axis of chart.
• Chart : Encapsulates the object that represents a single Excel chart.
• ChartArea : Encapsulates the object that represents the chart area in the worksheet.
• ChartDataTable : Represents a chart data table.
• ChartFrame : Encapsulates the object that represents the frame object in a chart.
• ChartGlobalizationSettings : Represents the globalization settings for chart.
• ChartPoint : Represents a single point in a series in a chart.
• ChartPoints : Represents a collection that contains all the points in one series.
• Charts : Encapsulates a collection of objects.
• ChartShape : Chart shape object
• DataLabels : Encapsulates a collection of all the DataLabel objects for the specified Series.
• DisplayUnitLabel : Represents the display unit label.
• DropBars : Represents the up/down bars in a chart.
• ErrorBar : Represents error bar of data series.
• Floor : Encapsulates the object that represents the floor of a 3-D chart.
• Legend : Encapsulates the object that represents the chart legend.
• LegendEntries :
• LegendEntry : Represents a legend entry in a chart legend.
• Marker : Represents the marker in a line chart, scatter chart, or radar chart.
• PlotArea : Encapsulates the object that represents the plot area in a chart.
• Series : Encapsulates the object that represents a single data series in a chart.
• SeriesItems :
• Sparkline : A sparkline represents a tiny chart or graphic in a worksheet cell that provides a visual representation of data.
• SparklineGroup : is organized into sparkline group. A SparklineGroup contains a variable number of sparkline items. A sparkline group specifies the type, display settings and axis settings for the sparklines.
• SparklineGroups : Encapsulates a collection of Aspose.Cells.Charts.SparklineGroup objects.
• TickLabels : Represents the tick-mark labels associated with tick marks on a chart axis.
• Title : Encapsulates the object that represents the title of chart or axis.
• Trendline : Represents a trendline in a chart.
• Trendlines : Represents a collection of all the objects for the specified data series.
• Walls : Encapsulates the object that represents the walls of a 3-D chart.
• ColumnDataExceptionDescription :
• TextCategoryType :
• AnalyzedColumnDescription : Represents description of analyzed column.
• AnalyzedResult : Represents results of analyzed data.
• AnalyzedTableDescription : Represents analyzed table description.
• DiscoverChart : Represents a chart, which is a chart created based on data analysis of a table.
• DiscoverPivotTable : Represents a pivot table, which is a pivot table created based on data analysis of a table.
• ExcelDataStatistics : Represents Excel data statistics.
• WorksheetDataStatistics : Represents worksheet data statistics.
• Error : Error
• ErrorDetails : The error details