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