Operations

• 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.