view release on metacpan or  search on metacpan

docs/DeveloperGuide.md  view on Meta::CPAN

## **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 c...

##  **API Reference**

| API Method | API Description |
| :--------- | :---------------| 
| [DecomposeUserTask](api/DecomposeUserTask.md) | AI task decomposition: Convert user objectives to sequential action plans with formatted file export. |
| [TranslateSpreadsheet](api/TranslateSpreadsheet.md) | Translates the entire spreadsheet to the specified target language. |
| [TranslateTextFile](api/TranslateTextFile.md) | Translates text file content to the specified target language. |
| [AggregateCellsByColor](api/AggregateCellsByColor.md) | 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...
| [MathCalculate](api/MathCalculate.md) |  |
| [PostAccessToken](api/PostAccessToken.md) | 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](api/GetAsposeCellsCloudStatus.md) | Check the Health Status of Aspose.Cells Cloud Service. |
| [CheckCloudServiceHealth](api/CheckCloudServiceHealth.md) | Check the Health Status of Aspose.Cells Cloud Service. |
| [ExportSpreadsheetAsFormat](api/ExportSpreadsheetAsFormat.md) | Converts a spreadsheet in cloud storage to the specified format. |
| [ExportWorksheetAsFormat](api/ExportWorksheetAsFormat.md) | Converts a worksheet of spreadsheet in cloud storage to the specified format. |
| [ExportChartAsFormat](api/ExportChartAsFormat.md) | Converts a chart of spreadsheet in cloud storage to the specified format. |
| [ExportTableAsFormat](api/ExportTableAsFormat.md) | Converts a table of spreadsheet in cloud storage to the specified format. |
| [ExportRangeAsFormat](api/ExportRangeAsFormat.md) | Converts the range of spreadsheet in cloud storage to the specified format. |
| [ConvertSpreadsheet](api/ConvertSpreadsheet.md) | Converts a spreadsheet on a local drive to the specified format. |
| [ConvertSpreadsheetToPdf](api/ConvertSpreadsheetToPdf.md) | Converts a spreadsheet on a local drive to the pdf file. |
| [ConvertSpreadsheetToJson](api/ConvertSpreadsheetToJson.md) | Converts a spreadsheet on a local drive to the JSON file. |
| [ConvertSpreadsheetToCsv](api/ConvertSpreadsheetToCsv.md) | Converts a spreadsheet on a local drive to the csv file. |
| [ConvertWorksheetToImage](api/ConvertWorksheetToImage.md) | Converts a worksheet of spreadsheet on a local drive to the image format. |
| [ConvertWorksheetToPdf](api/ConvertWorksheetToPdf.md) | Converts a worksheet of spreadsheet on a local drive to the pdf file. |
| [ConvertWorksheetToJson](api/ConvertWorksheetToJson.md) | Converts a worksheet of spreadsheet on a local drive to the JSON file. |
| [ConvertWorksheetToCsv](api/ConvertWorksheetToCsv.md) | Converts a worksheet of spreadsheet on a local drive to the CSV file. |
| [ConvertWorksheetToHtml](api/ConvertWorksheetToHtml.md) | Converts a worksheet of spreadsheet on a local drive to the html file. |
| [ConvertWorksheetToHtmlTable](api/ConvertWorksheetToHtmlTable.md) | Converts a worksheet of spreadsheet on a local drive to the HTML table file. |
| [ConvertTableToImage](api/ConvertTableToImage.md) | Converts a table of spreadsheet on a local drive to the image file. |
| [ConvertTableToPdf](api/ConvertTableToPdf.md) | Converts a table of spreadsheet on a local drive to the pdf file. |
| [ConvertTableToCsv](api/ConvertTableToCsv.md) | Converts a table of spreadsheet on a local drive to the csv file. |
| [ConvertTableToHtml](api/ConvertTableToHtml.md) | Converts a table of spreadsheet on a local drive to the html file. |
| [ConvertTableToJson](api/ConvertTableToJson.md) | Converts a table of spreadsheet on a local drive to the json file. |
| [ConvertRangeToImage](api/ConvertRangeToImage.md) | Converts a range of spreadsheet on a local drive to the image file. |
| [ConvertRangeToPdf](api/ConvertRangeToPdf.md) | Converts a range of spreadsheet on a local drive to the pdf file. |
| [ConvertRangeToCsv](api/ConvertRangeToCsv.md) | Converts a range of spreadsheet on a local drive to the csv file. |
| [ConvertRangeToHtml](api/ConvertRangeToHtml.md) | Converts a range of spreadsheet on a local drive to the html file. |
| [ConvertRangeToJson](api/ConvertRangeToJson.md) | Converts a range of spreadsheet on a local drive to the json file. |
| [ConvertChartToImage](api/ConvertChartToImage.md) | Converts a chart of spreadsheet on a local drive to image. |
| [ConvertChartToPdf](api/ConvertChartToPdf.md) | Converts a chart of spreadsheet on a local drive to pdf. |
| [SaveSpreadsheetAs](api/SaveSpreadsheetAs.md) | Converts a spreadsheet in cloud storage to the specified format. |
| [MergeSpreadsheets](api/MergeSpreadsheets.md) | Merge local spreadsheet files into a specified format file. |
| [MergeSpreadsheetsInRemoteFolder](api/MergeSpreadsheetsInRemoteFolder.md) | Merge spreadsheet files in folder of cloud storage into a specified format file. |
| [MergeRemoteSpreadsheet](api/MergeRemoteSpreadsheet.md) | Merge a spreadsheet file into other spreadsheet in cloud storage, and output a specified format file. |
| [SplitSpreadsheet](api/SplitSpreadsheet.md) | Split a local spreadsheet into the specified format, multi-file. |
| [SplitTable](api/SplitTable.md) | Split an Excel worksheet tale into multiple sheets by column value. |
| [SplitRemoteSpreadsheet](api/SplitRemoteSpreadsheet.md) | Split a spreadsheet in cloud storage into the specified format, multi-file. |
| [ImportDataIntoSpreadsheet](api/ImportDataIntoSpreadsheet.md) | Import data into a spreadsheet from a supported data file format. |
| [ImportJSONDataIntoSpreadsheet](api/ImportJSONDataIntoSpreadsheet.md) | Import JSON data file into the local spreadsheet. |
| [ImportXMLDataIntoSpreadsheet](api/ImportXMLDataIntoSpreadsheet.md) | Import XML data file into the local spreadsheet. |
| [ImportCSVDataIntoSpreadsheet](api/ImportCSVDataIntoSpreadsheet.md) | Import CSV data file into the local spreadsheet. |
| [GetPublicKey](api/GetPublicKey.md) | Get an asymmetric public key. |
| [CreateSpreadsheet](api/CreateSpreadsheet.md) | 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](api/GetWorksheetsWithLocalSpreadsheet.md) | Fetches a complete list of worksheets from the currently active local spreadsheet. |
| [AddWorksheetToSpreadsheet](api/AddWorksheetToSpreadsheet.md) | 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 b...
| [DeleteWorksheetFromSpreadsheet](api/DeleteWorksheetFromSpreadsheet.md) | 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 unnec...
| [RenameWorksheetInSpreadsheet](api/RenameWorksheetInSpreadsheet.md) | 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 or...
| [MoveWorksheetInSpreadsheet](api/MoveWorksheetInSpreadsheet.md) | 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](api/CompressSpreadsheet.md) | 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 applyin...
| [RepairSpreadsheet](api/RepairSpreadsheet.md) | The Web API endpoint allows users to repair a spreadsheet. |
| [GetMergedCellsInRemotedWorksheet](api/GetMergedCellsInRemotedWorksheet.md) | Get all merged cell area form a remote spreadsheet worksheet. |
| [GetMergedCellsInWorksheet](api/GetMergedCellsInWorksheet.md) | Get all merged cell area form a local spreadsheet worksheet. |
| [AcceptAllRevisions](api/AcceptAllRevisions.md) |  |
| [AcceptAllRevisionsInRemoteSpreadsheet](api/AcceptAllRevisionsInRemoteSpreadsheet.md) |  |
| [ProtectSpreadsheet](api/ProtectSpreadsheet.md) | Applies dual-layer password protection to Excel spreadsheets, supporting both open and modify passwords with encryption. |
| [UnprotectSpreadsheet](api/UnprotectSpreadsheet.md) | Removes dual-layer password protection from Excel spreadsheets, supporting both open and modify passwords with encryption. |
| [SpreadsheetDigitalsignature](api/SpreadsheetDigitalsignature.md) |  |
| [SearchAllTextItemsInRemoteSpreadsheet](api/SearchAllTextItemsInRemoteSpreadsheet.md) | Get all text items in the remote spreadsheet. |
| [SearchSpreadsheetAllTextItems](api/SearchSpreadsheetAllTextItems.md) | Get all text items in the remote spreadsheet. |
| [SearchSpreadsheetContent](api/SearchSpreadsheetContent.md) | Search text in the local spreadsheet. |
| [SearchContentInRemoteSpreadsheet](api/SearchContentInRemoteSpreadsheet.md) | Search text in the remoted spreadsheet. |
| [SearchContentInRemoteWorksheet](api/SearchContentInRemoteWorksheet.md) | Search text in the worksheet of remoted spreadsheet. |
| [SearchContentInRemoteRange](api/SearchContentInRemoteRange.md) | Search text in the range of remoted spreadsheet. |
| [ReplaceSpreadsheetContent](api/ReplaceSpreadsheetContent.md) | Replace text in the local spreadsheet. |
| [ReplaceContentInRemoteSpreadsheet](api/ReplaceContentInRemoteSpreadsheet.md) | Replace text in the remoted spreadsheet. |
| [ReplaceContentInRemoteWorksheet](api/ReplaceContentInRemoteWorksheet.md) | Replace text in the worksheet of remoted spreadsheet. |
| [ReplaceContentInRemoteRange](api/ReplaceContentInRemoteRange.md) | Replace text in the range of remoted spreadsheet. |
| [SearchSpreadsheetBrokenLinks](api/SearchSpreadsheetBrokenLinks.md) | Search broken links in the local spreadsheet. |
| [SearchBrokenLinksInRemoteSpreadsheet](api/SearchBrokenLinksInRemoteSpreadsheet.md) | Search broken links in the remoted spreadsheet. |
| [SearchBrokenLinksInRemoteWorksheet](api/SearchBrokenLinksInRemoteWorksheet.md) | Search broken links in the worksheet of remoted spreadsheet. |
| [SearchBrokenLinksInRemoteRange](api/SearchBrokenLinksInRemoteRange.md) | Search broken links in the range of remoted spreadsheet. |
| [Spec](api/Spec.md) | Get the specifications |
| [CodegenSpec](api/CodegenSpec.md) |  |
| [TrimCharacter](api/TrimCharacter.md) | 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 sele...
| [UpdateWordCase](api/UpdateWordCase.md) | 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 accord...
| [RemoveCharacters](api/RemoveCharacters.md) | 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](api/RemoveCharactersByPosition.md) | 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-...
| [RemoveDuplicateSubstrings](api/RemoveDuplicateSubstrings.md) | 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](api/AddText.md) | 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 aft...
| [ConvertText](api/ConvertText.md) | 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 ch...
| [ExtractText](api/ExtractText.md) | 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](api/SplitText.md) | Indicates performing text segmentation on the specified area according to the segmentation method, and outputting to the designated interval. |
| [RemoveSpreadsheetBlankRows](api/RemoveSpreadsheetBlankRows.md) | Delete all blank rows that do not contain any data or other objects. |
| [RemoveSpreadsheetBlankColumns](api/RemoveSpreadsheetBlankColumns.md) | Delete all blank rows that do not contain any data or other objects. |
| [RemoveSpreadsheetBlankWorksheets](api/RemoveSpreadsheetBlankWorksheets.md) | Delete all blank rows that do not contain any data or other objects. |
| [RemoveDuplicates](api/RemoveDuplicates.md) | Removes duplicate values in the worksheet/range/table. |
| [SwapRange](api/SwapRange.md) | 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, ensuri...
| [FlipData](api/FlipData.md) | Transposes a specified data range (rows become columns, columns become rows). |
| [DownloadFile](api/DownloadFile.md) |  |
| [UploadFile](api/UploadFile.md) |  |
| [CopyFile](api/CopyFile.md) |  |
| [MoveFile](api/MoveFile.md) |  |
| [DeleteFile](api/DeleteFile.md) |  |
| [GetFilesList](api/GetFilesList.md) |  |
| [CreateFolder](api/CreateFolder.md) |  |
| [CopyFolder](api/CopyFolder.md) |  |
| [MoveFolder](api/MoveFolder.md) |  |
| [DeleteFolder](api/DeleteFolder.md) |  |
| [StorageExists](api/StorageExists.md) |  |
| [ObjectExists](api/ObjectExists.md) |  |
| [GetDiscUsage](api/GetDiscUsage.md) |  |
| [GetFileVersions](api/GetFileVersions.md) |  |
| [PostAnalyzeExcel](api/PostAnalyzeExcel.md) | Perform business analysis of data in Excel files. |
| [GetWorksheetAutoFilter](api/GetWorksheetAutoFilter.md) | Retrieve the description of auto filters from a worksheet. |
| [PutWorksheetDateFilter](api/PutWorksheetDateFilter.md) | Apply a date filter in the worksheet. |
| [PutWorksheetFilter](api/PutWorksheetFilter.md) | Add a filter for a column in the worksheet. |
| [PutWorksheetIconFilter](api/PutWorksheetIconFilter.md) | Add an icon filter in the worksheet. |
| [PutWorksheetCustomFilter](api/PutWorksheetCustomFilter.md) | Filter a list with custom criteria in the worksheet. |
| [PutWorksheetDynamicFilter](api/PutWorksheetDynamicFilter.md) | Add a dynamic filter in the worksheet. |
| [PutWorksheetFilterTop10](api/PutWorksheetFilterTop10.md) | Filter the top 10 items in the list in the worksheet. |