Skip to content

Latest commit

 

History

History
909 lines (903 loc) · 95.8 KB

File metadata and controls

909 lines (903 loc) · 95.8 KB

Overview

This Developer Guide serves as the complete technical reference for the Aspose.Cells Cloud SDK. It provides detailed specifications for all available interfaces and data structures, enabling developers to seamlessly integrate spreadsheet processing capabilities into their applications.

API Reference

API Method API Description
DecomposeUserTask AI task decomposition: Convert user objectives to sequential action plans with formatted file export.
TranslateSpreadsheet Translates the entire spreadsheet to the specified target language.
TranslateTextFile Translates text file content to the specified target language.
AggregateCellsByColor The Aggregate by Color API provides a convenient way to perform calculations on cells that share the same fill or font color. This API supports a range of aggregate operations, including count, sum, maximum value, minimum value, and average value, enabling you to analyze and summarize data based on color distinctions.
MathCalculate
PostAccessToken Get Access Token Result: The Cells Cloud Get Token API acts as a proxy service,forwarding user requests to the Aspose Cloud authentication server and returning the resulting access token to the client.
GetAsposeCellsCloudStatus Check the Health Status of Aspose.Cells Cloud Service.
CheckCloudServiceHealth Check the Health Status of Aspose.Cells Cloud Service.
ExportSpreadsheetAsFormat Converts a spreadsheet in cloud storage to the specified format.
ExportWorksheetAsFormat Converts a worksheet of spreadsheet in cloud storage to the specified format.
ExportChartAsFormat Converts a chart of spreadsheet in cloud storage to the specified format.
ExportTableAsFormat Converts a table of spreadsheet in cloud storage to the specified format.
ExportRangeAsFormat Converts the range of spreadsheet in cloud storage to the specified format.
ConvertSpreadsheet Converts a spreadsheet on a local drive to the specified format.
ConvertSpreadsheetToPdf Converts a spreadsheet on a local drive to the pdf file.
ConvertSpreadsheetToJson Converts a spreadsheet on a local drive to the JSON file.
ConvertSpreadsheetToCsv Converts a spreadsheet on a local drive to the csv file.
ConvertWorksheetToImage Converts a worksheet of spreadsheet on a local drive to the image format.
ConvertWorksheetToPdf Converts a worksheet of spreadsheet on a local drive to the pdf file.
ConvertWorksheetToJson Converts a worksheet of spreadsheet on a local drive to the JSON file.
ConvertWorksheetToCsv Converts a worksheet of spreadsheet on a local drive to the CSV file.
ConvertWorksheetToHtml Converts a worksheet of spreadsheet on a local drive to the html file.
ConvertWorksheetToHtmlTable Converts a worksheet of spreadsheet on a local drive to the HTML table file.
ConvertTableToImage Converts a table of spreadsheet on a local drive to the image file.
ConvertTableToPdf Converts a table of spreadsheet on a local drive to the pdf file.
ConvertTableToCsv Converts a table of spreadsheet on a local drive to the csv file.
ConvertTableToHtml Converts a table of spreadsheet on a local drive to the html file.
ConvertTableToJson Converts a table of spreadsheet on a local drive to the json file.
ConvertRangeToImage Converts a range of spreadsheet on a local drive to the image file.
ConvertRangeToPdf Converts a range of spreadsheet on a local drive to the pdf file.
ConvertRangeToCsv Converts a range of spreadsheet on a local drive to the csv file.
ConvertRangeToHtml Converts a range of spreadsheet on a local drive to the html file.
ConvertRangeToJson Converts a range of spreadsheet on a local drive to the json file.
ConvertChartToImage Converts a chart of spreadsheet on a local drive to image.
ConvertChartToPdf Converts a chart of spreadsheet on a local drive to pdf.
SaveSpreadsheetAs Converts a spreadsheet in cloud storage to the specified format.
MergeSpreadsheets Merge local spreadsheet files into a specified format file.
MergeSpreadsheetsInRemoteFolder Merge spreadsheet files in folder of cloud storage into a specified format file.
MergeRemoteSpreadsheet Merge a spreadsheet file into other spreadsheet in cloud storage, and output a specified format file.
SplitSpreadsheet Split a local spreadsheet into the specified format, multi-file.
SplitTable Split an Excel worksheet tale into multiple sheets by column value.
SplitRemoteSpreadsheet Split a spreadsheet in cloud storage into the specified format, multi-file.
ImportDataIntoSpreadsheet Import data into a spreadsheet from a supported data file format.
ImportJSONDataIntoSpreadsheet Import JSON data file into the local spreadsheet.
ImportXMLDataIntoSpreadsheet Import XML data file into the local spreadsheet.
ImportCSVDataIntoSpreadsheet Import CSV data file into the local spreadsheet.
GetPublicKey Get an asymmetric public key.
CreateSpreadsheet The Web API allows users to create a new spreadsheet with a specified name. Optionally, a template can be provided to initialize the spreadsheet with predefined content or formatting.
GetWorksheetsWithLocalSpreadsheet Fetches a complete list of worksheets from the currently active local spreadsheet.
AddWorksheetToSpreadsheet The Web API enables users to add a new worksheet to a workbook, specifying the worksheet's type, position, and name. This function provides flexibility in managing workbook structure by allowing detailed control over worksheet addition.
DeleteWorksheetFromSpreadsheet The Web API endpoint allows users to delete a specified worksheet from a workbook. This function provides a straightforward way to manage workbook structure by removing unnecessary or redundant worksheets.
RenameWorksheetInSpreadsheet The Web API endpoint allows users to rename a specified worksheet within a workbook. This function provides a straightforward way to update worksheet names, enhancing workbook organization and readability.
MoveWorksheetInSpreadsheet The Web API endpoint allows users to move a specified worksheet within a workbook. This function provides a straightforward way to move a worksheet, enhancing workbook organization.
CompressSpreadsheet The Web API endpoint allows users to compress a spreadsheet to reduce its file size. This function provides a straightforward way to optimize the storage and performance of spreadsheets by applying a specified compression level.
RepairSpreadsheet The Web API endpoint allows users to repair a spreadsheet.
GetMergedCellsInRemotedWorksheet Get all merged cell area form a remote spreadsheet worksheet.
GetMergedCellsInWorksheet Get all merged cell area form a local spreadsheet worksheet.
ProtectSpreadsheet Applies dual-layer password protection to Excel spreadsheets, supporting both open and modify passwords with encryption.
UnprotectSpreadsheet Removes dual-layer password protection from Excel spreadsheets, supporting both open and modify passwords with encryption.
SpreadsheetDigitalsignature
SearchAllTextItemsInRemoteSpreadsheet Get all text items in the remote spreadsheet.
SearchSpreadsheetAllTextItems Get all text items in the remote spreadsheet.
SearchSpreadsheetContent Search text in the local spreadsheet.
SearchContentInRemoteSpreadsheet Search text in the remoted spreadsheet.
SearchContentInRemoteWorksheet Search text in the worksheet of remoted spreadsheet.
SearchContentInRemoteRange Search text in the range of remoted spreadsheet.
ReplaceSpreadsheetContent Replace text in the local spreadsheet.
ReplaceContentInRemoteSpreadsheet Replace text in the remoted spreadsheet.
ReplaceContentInRemoteWorksheet Replace text in the worksheet of remoted spreadsheet.
ReplaceContentInRemoteRange Replace text in the range of remoted spreadsheet.
SearchSpreadsheetBrokenLinks Search broken links in the local spreadsheet.
SearchBrokenLinksInRemoteSpreadsheet Search broken links in the remoted spreadsheet.
SearchBrokenLinksInRemoteWorksheet Search broken links in the worksheet of remoted spreadsheet.
SearchBrokenLinksInRemoteRange Search broken links in the range of remoted spreadsheet.
Spec Get the specifications
CodegenSpec
TrimCharacter The TrimSpreadsheetContent API is designed to process and trim content within a spreadsheet. This API allows users to remove extra spaces, line breaks, or other unnecessary characters from the content of selected cells. It is particularly useful for cleaning up data entries and ensuring consistency in spreadsheet formatting
UpdateWordCase Specify changing the text case in a spreadsheet to switch between uppercase, lowercase, capitalizing the first letter of each word, or capitalizing the first letter of a sentence, and adjust the text according to specific needs.
RemoveCharacters Deletes user-defined characters, predefined symbol sets, or any substring from every cell in the chosen range while preserving formulas, formatting and data-validation.
RemoveCharactersByPosition Deletes characters from every cell in the target range by position (first/last N, before/after a substring, or between two delimiters) while preserving formulas, formatting and data-validation.
RemoveDuplicateSubstrings Finds and removes repeated substrings inside every cell of the chosen range, using user-defined or preset delimiters, while preserving formulas, formatting and data-validation.
AddText Specify appending text to multiple cells at once, allowing you to add prefixes, suffixes, labels, or any specific characters. You can choose the exact position of the text—in the beginning, at the end, or before or after certain characters in the cell.
ConvertText Indicates converting the numbers stored as text into the correct number format, replacing unwanted characters and line breaks with the desired characters, and converting accented characters to their equivalent characters without accents.
ExtractText Indicates extracting substrings, text characters, and numbers from a spreadsheet cell into another cell without having to use complex FIND, MIN, LEFT, or RIGHT formulas.
SplitText Indicates performing text segmentation on the specified area according to the segmentation method, and outputting to the designated interval.
RemoveSpreadsheetBlankRows Delete all blank rows that do not contain any data or other objects.
RemoveSpreadsheetBlankColumns Delete all blank rows that do not contain any data or other objects.
RemoveSpreadsheetBlankWorksheets Delete all blank rows that do not contain any data or other objects.
RemoveDuplicates Removes duplicate values in the worksheet/range/table.
SwapRange The Swap Ranges for Excel API provides a powerful tool to move any two columns, rows, ranges, or individual cells within an Excel file. This API allows users to re-arrange their tables quickly and efficiently, ensuring that the original data formatting is preserved and all existing formulas continue to function correctly. By leveraging this API, users can streamline their data manipulation tasks and maintain the integrity of their spreadsheets.
FlipData Transposes a specified data range (rows become columns, columns become rows).
DownloadFile
UploadFile
CopyFile
MoveFile
DeleteFile
GetFilesList
CreateFolder
CopyFolder
MoveFolder
DeleteFolder
StorageExists
ObjectExists
GetDiscUsage
GetFileVersions
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.
PostConvertWorksheetToImage
PostConvertWorkbook
CheckWrokbookExternalReference Export Excel internal elements or the workbook itself to various format files.
CheckWorkbookFormulaErrors
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.
AddPictureInCell add new picture in the cells.
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.
PostWorksheetCellsRangeToImage
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.
PostCharacterCount
PostWordsCount
PostSpecifyWordsCount
PostRunTask Run tasks.
PostAddTextContent Adds text content to a specified location within a document. It requires an object that defines the text to be added and the insertion location.
PostTrimContent The PostTrimContent API is designed to process and trim content within a specified range in a spreadsheet. This API allows users to remove extra spaces, line breaks, or other unnecessary characters from the content of selected cells. It is particularly useful for cleaning up data entries and ensuring consistency in spreadsheet formatting
PostUpdateWordCase Managing inconsistent text case in spreadsheets (Excel, Google Sheets, CSV) can be frustrating, especially with large datasets. The PostUpdateWordCase WEB API solves this by automating text case conversions, ensuring clean and standardized data.
PostRemoveCharacters A comprehensive set of tools for cleaning text content within selected cells. It allows users to remove specific characters, character sets, and substrings, ensuring that the text is standardized and free from unwanted symbols or sequences.
PostConvertText Enhance Excel data through essential text conversions: convert text to numbers, replace characters and line breaks, and remove accents.
PostRemoveDuplicates Efficiently remove duplicate substrings from Excel cells. Select a range, specify delimiters, and apply options to eliminate repeated text segments.
PostExtractText Effortlessly extract text and numbers from Excel cells with precise options. This API allows extraction of first/last characters, text between delimiters, and numbers from strings, with output as static values or formulas.
PostSplitText Efficiently divides Excel cell content into columns or rows based on specified delimiters or patterns. Supports Character-based splitting, Custom string splitting, Mask and wildcard splitting for pattern-based division, Line break division, Column or row splitting, Delimiter removal or retention.
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.
GetAllStyles Get all style 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.

Model Reference

Model Name Model Description
DiscUsage Class for disc space information.
ObjectExist Object exists
ObjectExistsExtensions
FileVersion
StorageExist Storage exists
FileVersions File versions FileVersion.
FilesList Files list
FilesUploadResult File upload result
StorageFile File or folder information
GoogleDriveStorageFile
AggregateResultByColor
BrokenLink
CellArea
CellsCloudFileInfo
CellsCloudPublicKey
Color
PdfSecurityOptions
Range
RemoveCharactersByPosition
SaveResult
PaginatedSaveOptions
SpreadsheetTemplate
TextItem
DbfSaveOptions
DifSaveOptions
DocxSaveOptions
HtmlSaveOptions
ImageSaveOptions
JsonSaveOptions
MarkdownSaveOptions
MHtmlSaveOptions
OdsSaveOptions
OoxmlSaveOptions
PclSaveOptions
PdfSaveOptions
PptxSaveOptions
SaveOptions
SaveOptionsData
SpreadsheetML2003SaveOptions
SqlScriptSaveOptions
SvgSaveOptions
TxtSaveOptions
XlsbSaveOptions
XlsSaveOptions
XmlSaveOptions
XpsSaveOptions
AggregateResultByColorResponse
BrokenLinksResponse
CellsCloudFileInfoResponse
CellsCloudPublicKeyResponse
CellsCloudResponse
SaveResponse
SearchResponse
ImageOrPrintOptions
RenderingFont
RenderingWatermark
Error Error
ErrorDetails The error details
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.
Cells Encapsulates a collection of cell relevant objects, such as Aspose.Cells.Cell, Aspose.Cells.Row, ...etc.
CellsColor Represents all types of color.
CellsDocumentProperties Excel properties
CellsDocumentProperty Cells document property.
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 I'm here to help! Please provide me with the features that need to be summarized.
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 1. Collaboration: Students will have the opportunity to work together on group projects and assignments. 2. Critical Thinking: Students will be encouraged to analyze, evaluate, and interpret information in a meaningful way. 3. Hands-on Learning: Students will participate in experiential activities to apply theoretical knowledge in practical settings. 4. Technology Integration: Students will utilize various digital tools and platforms to enhance their learning experience. 5. Communication Skills: Students will develop effective verbal and written communication skills through presentations and written assignments.
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.
DataSorter Summary description for DataSorter.
DataSorterKey Represents the key of the data sorter.
DataSource Represents data source.
DateTimeGroupItem Represents the datetime's group setting.
DeduplicationRegion Represents data deduplication region.
DynamicFilter Represents the dynamic filter.
FileInfo Represents file information.
FileSource I'm sorry, I just realized you didn't provide any features for me to summarize. Please provide the features you'd like me to summarize for the class.
FilesResult Class features: Weekly lectures, group projects, midterm and final exams, and participation in class discussions.
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 Class summary: This class covers various features related to data visualization and graphical representation of data sets.
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 I'm glad to help! Please provide me with the features you would like me to summarize.
LinkElement Class summary: The features include automatic emergency braking, lane keeping assist, adaptive cruise control, blind spot monitoring, and rear cross-traffic alert.
LoadOptions Represents the options of loading the file.
MergedCell I'm happy to help! Could you please provide me with the features you would like me to summarize for the class?
MergedCells Sure, could you please provide me with the features you would like me to summarize?
MultipleFilter Class Summary: The features include real-time collaboration, file sharing, scheduling, task tracking, and discussion forums to enhance communication and productivity.
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 Class summary: Includes interactive discussions, group projects, guest speakers, and practical applications of course material.
PageSetup excel print page setting
PasteOptions Represents the paste special options.
Protection Represents the various types of protection options available for a worksheet.
ProtectSheetParameter Class Summary: The features discussed include natural language processing, image recognition, data visualization, clustering, regression, classification, and recommendation systems.
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.
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.
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.
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.
ChartOperateParameter Represents chart operate parameter.
ListObjectOperateParameter Represents list object operate parameter.
OperateObject Represents operate object.
OperateObjectPosition Represents operate object position.
OperateParameter Represents operate parameter.
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.
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.
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.
CheckedExternalReferenceResponse
CheckedFormulaErrorsResponse
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.
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.
StylesResponse Represents the Styles 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 Can you please provide the features that you would like me to summarize for the class?
BatchConvertRequest Indicates batch convert file request
BatchLockRequest Indicates batch lock file request
BatchProtectRequest Indicates batch protect file request
BatchSplitRequest Class summary: Identifying key features of a statistical dataset and methods for data analysis.
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 I'm happy to help! Please provide the features you would like me to summarize.
DataTransformationRequest Data Transformation Request
DeleteIncompleteRowsRequest I'm here to help! Could you please provide the features you would like me to summarize?
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
RangeConvertRequest Indicates range copy 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.
AppliedOperate A data operation that is used to obtain a query of data.
AppliedStep Each data manipulation step that is performed when you get the query data.
DataQuery Data query.
LoadData Loading data information.
LoadTo A description of the location to which the data is mounted.
MergeQueries Represents merge quesies.
PivotColumn Represents pivot column for data table.
UnpivotColumn Unpivot column.
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.
AddTextOptions Class summary: The features of this class include hands-on learning activities, group projects, interactive discussions, guest speakers, and field trips to real-world applications.
BaseOperateOptions
CharacterCountOptions Character Count Options.
CheckExternalReferenceOptions
CheckFormulaErrorOptions
CombinationSourceData
ConvertTextOptions Class summary: The features of the new smartphone include a high-resolution display, multiple camera lenses for versatile photography, a fast processor for seamless performance, and a larger battery for extended usage time.
ConvertWorkbookOptions
ConvertWorksheetOptions
DataOutputLocation
ExtractTextOptions I'm happy to help! Could you please provide me with the features you would like me to summarize for you?
MergeTableOptions
RemoveCharactersByCharacter Class summary: The features include fast and reliable performance, high-quality camera with portrait mode, long-lasting battery life, and a durable water-resistant design.
RemoveCharactersOptions Class summary: The class features discussing effective communication strategies, developing problem-solving skills, and increasing self-awareness for personal growth.
RemoveDuplicatesOptions I'm here to help! Just let me know the features you would like me to summarize for you.
ScopeItem Define the specific range in your Excel worksheet where you want the spreadsheet operations to be performed. This ensures that only the cells within the selected range are processed, and any operations are confined to this area.
ScopeOptions Specifies the range of cells within the worksheet where the spreadsheet operations will be performed. This parameter allows users to define the exact area to be processed, ensuring that operations are applied only to the designated cells.
SpecifyCellsObject
SpecifyWordsCountOptions
SplitTextOptions Appliance features: 1. Automatic defrost system 2. Energy-efficient LED lighting 3. Adjustable glass shelves 4. Ice and water dispenser with filtration system
TablePositionInfo
TrimContentOptions
WordCaseOptions I'm here to assist you. Please provide the features you would like me to summarize for the class.
WordsCountOptions Words Count Options
CellValue Represents the cell value and corresponding type.
CustomParserConfig I'm happy to help! Please provide me with the features you would like me to summarize for the class.
Import2DimensionDoubleArrayOption I can help summarize features, please provide the details you'd like me to summarize.
Import2DimensionIntArrayOption I'm here to help! Please provide the features you'd like me to summarize.
Import2DimensionStringArrayOption I'm eager to assist you! Please provide me with the features you would like me to summarize into one sentence for your class summary.
ImportBatchDataOption I'm sorry, but it seems like you haven't provided any features for me to summarize. Could you please share the features you'd like me to summarize into a single sentence for your class?
ImportCSVDataOption I'm happy to help! Could you please provide me with the features you would like me to summarize into a class summary?
ImportDoubleArrayOption Class summary: The features include grammar and spell check, word count, readability analysis, and style suggestions for improving writing.
ImportIntArrayOption I'm here to help! Just provide me with the features you'd like to summarize.
ImportOption Class Summary: This class covers the features of artificial intelligence, machine learning, deep learning, and natural language processing.
ImportPictureOption Class summary: The features of the topic were explored, discussing its components, patterns, and significance.
ImportPosition I can help with that. Just provide me with the features you'd like me to summarize.
ImportStringArrayOption I'm happy to help! Could you please provide me with the features you would like me to summarize for the class?
ArcShape Represents the arc shape.
Area Encapsulates the object that represents an area format.
AutoShape Represents an AutoShape.
AutoShapes Sure! Just provide me with the features you would like me to summarize into one sentence.
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 I'm happy to help! Please provide the features you would like me to summarize into one sentence for the class.
Forms "Summary: The class covers a range of features including advanced machine learning techniques, statistical analysis tools, and computer vision algorithms."
GradientFill Represents the gradient fill.
GradientFillStop Class summary: Understanding the various features and tools available in Adobe Illustrator to create dynamic and professional vector graphics, including shapes, text, brushes, gradients, and layers.
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 Sure, please provide me with the features you would like me to summarize in one sentence for the class summary.
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 Class Summary: - Features: Active class participation, group projects, quizzes, and final exam.
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.
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.