AsposeCellsCloud-CellsApi
view release on metacpan or search on metacpan
 [ is a cloud-native REST API that enables Perl developers to **create**, **read**, **edit**, **convert**, and **repair** spreadsheet files—including **Excel** (**XLS**, **XLS...
Built on the **Aspose.Cells Cloud Web API**, this MIT-licensed SDK supports advanced spreadsheet operations such as:
- Cell formatting, formulas, and data validation
- Pivot tables, charts, hyperlinks, and comments
- Conditional formatting and smart markers
- Worksheet merging, splitting, and protection
- Batch processing and background removal
It seamlessly integrates with **AWS**, **Microsoft Azure**, and **Google Cloud**, ensuring **high availability**, **scalability**, and **data integrity**. Ideal for serverless apps, microservices, and cloud automation workflows.
## Quick Start Guide
To begin with Aspose.Cells Cloud, here's what you need to do:
## Architecture
## [Developer Reference](docs/DeveloperGuide.md#overview)
### Manipulate Excel and other spreadsheet files in the Cloud
- **File Manipulation**: Users can upload, download, delete, and manage Excel files stored in the cloud.
- **File Formatting**: Supports formatting of cells, fonts, colors, and alignment modes in Excel files to cater to users' specific requirements.
- **Data Processing**: Powerful functions for data processing including reading, writing, modifying cell data, performing formula calculations, and formatting data.
- **Formula Calculation**: Built-in formula engine handles complex formula calculations in Excel and returns accurate results.
- **Chart Manipulation**: Users can create, edit, and delete charts from Excel files for data analysis and visualization needs.
- **Table Processing**: Offers robust processing capabilities for various form operations such as creation, editing, formatting, and conversion, meeting diverse form processing needs.
- **Data Verification**: Includes data verification function to set cell data type, range, uniqueness, ensuring data accuracy and integrity.
- **Batch Processing**: Supports batch processing of multiple Excel documents, such as batch format conversion, data extraction, and style application..
- **Import/Export Data**: Facilitates importing data from various sources into spreadsheets and exporting spreadsheet data to other formats.
- **Security Management**: Offers a range of security features like data encryption, access control, and permission management to safeguard the security and integrity of spreadsheet data.
## Feature & Enhancements in Version v26.3.1
Full list of issues covering all changes in this release:
docs/DeveloperGuide.md view on Meta::CPAN
| [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) | |
docs/DeveloperGuide.md view on Meta::CPAN
| [PostWorksheetUnmerge](api/PostWorksheetUnmerge.md) | Unmerge cells in the worksheet. |
| [GetWorksheetCells](api/GetWorksheetCells.md) | Retrieve cell descriptions in a specified format. |
| [GetWorksheetCell](api/GetWorksheetCell.md) | Retrieve cell data using either cell reference or method name in the worksheet. |
| [GetWorksheetCellStyle](api/GetWorksheetCellStyle.md) | Retrieve cell style descriptions in the worksheet. |
| [PostWorksheetCellSetValue](api/PostWorksheetCellSetValue.md) | Set cell value using cell name in the worksheet. |
| [PostUpdateWorksheetCellStyle](api/PostUpdateWorksheetCellStyle.md) | Set cell style using cell name in the worksheet. |
| [PostSetCellRangeValue](api/PostSetCellRangeValue.md) | Set the value of the range in the worksheet. |
| [PostCopyCellIntoCell](api/PostCopyCellIntoCell.md) | Copy data from a source cell to a destination cell in the worksheet. |
| [GetCellHtmlString](api/GetCellHtmlString.md) | Retrieve the HTML string containing data and specific formats in this cell. |
| [PostSetCellHtmlString](api/PostSetCellHtmlString.md) | Set the HTML string containing data and specific formats in this cell. |
| [PostCellCalculate](api/PostCellCalculate.md) | Calculate cell formula in the worksheet. |
| [PostCellCharacters](api/PostCellCharacters.md) | Set cell characters in the worksheet. |
| [GetWorksheetColumns](api/GetWorksheetColumns.md) | Retrieve descriptions of worksheet columns. |
| [PostSetWorksheetColumnWidth](api/PostSetWorksheetColumnWidth.md) | Set worksheet column width. |
| [GetWorksheetColumn](api/GetWorksheetColumn.md) | Retrieve worksheet column data by column index. |
| [PutInsertWorksheetColumns](api/PutInsertWorksheetColumns.md) | Insert worksheet columns in the worksheet. |
| [DeleteWorksheetColumns](api/DeleteWorksheetColumns.md) | Delete worksheet columns in the worksheet. |
| [PostHideWorksheetColumns](api/PostHideWorksheetColumns.md) | Hide worksheet columns in the worksheet. |
| [PostUnhideWorksheetColumns](api/PostUnhideWorksheetColumns.md) | Unhide worksheet columns in the worksheet. |
| [PostGroupWorksheetColumns](api/PostGroupWorksheetColumns.md) | Group worksheet columns in the worksheet. |
| [PostUngroupWorksheetColumns](api/PostUngroupWorksheetColumns.md) | Ungroup worksheet columns. |
docs/DeveloperGuide.md view on Meta::CPAN
| [PostCharacterCount](api/PostCharacterCount.md) | |
| [PostWordsCount](api/PostWordsCount.md) | |
| [PostSpecifyWordsCount](api/PostSpecifyWordsCount.md) | |
| [PostRunTask](api/PostRunTask.md) | Run tasks. |
| [PostAddTextContent](api/PostAddTextContent.md) | 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](api/PostTrimContent.md) | 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 t...
| [PostUpdateWordCase](api/PostUpdateWordCase.md) | 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 con...
| [PostRemoveCharacters](api/PostRemoveCharacters.md) | 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 standardize...
| [PostConvertText](api/PostConvertText.md) | Enhance Excel data through essential text conversions: convert text to numbers, replace characters and line breaks, and remove accents. |
| [PostRemoveDuplicates](api/PostRemoveDuplicates.md) | Efficiently remove duplicate substrings from Excel cells. Select a range, specify delimiters, and apply options to eliminate repeated text segments. |
| [PostExtractText](api/PostExtractText.md) | 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 v...
| [PostSplitText](api/PostSplitText.md) | 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-base...
| [GetWorkbookDefaultStyle](api/GetWorkbookDefaultStyle.md) | Retrieve the description of the default style for the workbook . |
| [GetWorkbookTextItems](api/GetWorkbookTextItems.md) | Retrieve text items in the workbook. |
| [GetWorkbookNames](api/GetWorkbookNames.md) | Retrieve named ranges in the workbook. |
| [PutWorkbookName](api/PutWorkbookName.md) | Define a new name in the workbook. |
| [GetWorkbookName](api/GetWorkbookName.md) | Retrieve description of a named range in the workbook. |
| [PostWorkbookName](api/PostWorkbookName.md) | Update a named range in the workbook. |
| [GetWorkbookNameValue](api/GetWorkbookNameValue.md) | Retrieve the value of a named range in the workbook. |
| [DeleteWorkbookNames](api/DeleteWorkbookNames.md) | Delete all named ranges in the workbook. |
| [DeleteWorkbookName](api/DeleteWorkbookName.md) | Delete a named range in the workbook. |
| [PostWorkbooksMerge](api/PostWorkbooksMerge.md) | Merge a workbook into the existing workbook. |
| [PostWorkbooksTextSearch](api/PostWorkbooksTextSearch.md) | Search for text in the workbook. |
| [PostWorkbookTextReplace](api/PostWorkbookTextReplace.md) | Replace text in the workbook. |
| [PostWorkbookGetSmartMarkerResult](api/PostWorkbookGetSmartMarkerResult.md) | Smart marker processing. |
| [PutWorkbookCreate](api/PutWorkbookCreate.md) | Create a new workbook using different methods. |
| [PostWorkbookSplit](api/PostWorkbookSplit.md) | Split the workbook with a specific format. |
| [PostWorkbookCalculateFormula](api/PostWorkbookCalculateFormula.md) | Calculate all formulas in the workbook. |
| [PostAutofitWorkbookRows](api/PostAutofitWorkbookRows.md) | Autofit rows in the workbook. |
| [PostAutofitWorkbookColumns](api/PostAutofitWorkbookColumns.md) | Autofit columns in the workbook. |
| [GetWorkbookSettings](api/GetWorkbookSettings.md) | Retrieve descriptions of workbook settings. |
| [PostWorkbookSettings](api/PostWorkbookSettings.md) | Update setting in the workbook. |
| [PutWorkbookBackground](api/PutWorkbookBackground.md) | Set background in the workbook. |
| [DeleteWorkbookBackground](api/DeleteWorkbookBackground.md) | Delete background in the workbook. |
| [PutWorkbookWaterMarker](api/PutWorkbookWaterMarker.md) | Set water marker in the workbook. |
| [GetPageCount](api/GetPageCount.md) | Get page count in the workbook. |
| [GetAllStyles](api/GetAllStyles.md) | Get all style in the workbook. |
| [GetWorksheets](api/GetWorksheets.md) | Retrieve the description of worksheets from a workbook. |
docs/DeveloperGuide.md view on Meta::CPAN
| [DeleteUnprotectWorksheet](api/DeleteUnprotectWorksheet.md) | Unprotect worksheet. |
| [GetWorksheetTextItems](api/GetWorksheetTextItems.md) | Retrieve text items in the worksheet. |
| [GetWorksheetComments](api/GetWorksheetComments.md) | Retrieve the description of comments in the worksheet. |
| [GetWorksheetComment](api/GetWorksheetComment.md) | Retrieve the description of comment in the worksheet. |
| [PutWorksheetComment](api/PutWorksheetComment.md) | Add cell comment in the worksheet. |
| [PostWorksheetComment](api/PostWorksheetComment.md) | Update cell comment in the worksheet. |
| [DeleteWorksheetComment](api/DeleteWorksheetComment.md) | Delete cell comment in the worksheet. |
| [DeleteWorksheetComments](api/DeleteWorksheetComments.md) | Delete all comments in the worksheet. |
| [GetWorksheetMergedCells](api/GetWorksheetMergedCells.md) | Get worksheet merged cells. |
| [GetWorksheetMergedCell](api/GetWorksheetMergedCell.md) | Retrieve description of a merged cell by its index in the worksheet. |
| [GetWorksheetCalculateFormula](api/GetWorksheetCalculateFormula.md) | Calculate formula in the worksheet. |
| [PostWorksheetCalculateFormula](api/PostWorksheetCalculateFormula.md) | Calculate formula in the worksheet. |
| [PostWorksheetTextSearch](api/PostWorksheetTextSearch.md) | Search for text in the worksheet. |
| [PostWorksheetTextReplace](api/PostWorksheetTextReplace.md) | Replace old text with new text in the worksheet. |
| [PostWorksheetRangeSort](api/PostWorksheetRangeSort.md) | Sort a range in the worksheet. |
| [PostAutofitWorksheetRow](api/PostAutofitWorksheetRow.md) | Autofit a row in the worksheet. |
| [PostAutofitWorksheetRows](api/PostAutofitWorksheetRows.md) | Autofit rows in the worksheet. |
| [PostAutofitWorksheetColumns](api/PostAutofitWorksheetColumns.md) | Autofit columns in the worksheet. |
| [PutWorksheetBackground](api/PutWorksheetBackground.md) | Set background image in the worksheet. |
| [DeleteWorksheetBackground](api/DeleteWorksheetBackground.md) | Delete background image in the worksheet. |
| [PutWorksheetFreezePanes](api/PutWorksheetFreezePanes.md) | Set freeze panes in the worksheet. |
| [DeleteWorksheetFreezePanes](api/DeleteWorksheetFreezePanes.md) | Unfreeze panes in worksheet. |
docs/DeveloperGuide.md view on Meta::CPAN
| [CellsCloudResponse](model/CellsCloudResponse.md)| |
| [SaveResponse](model/SaveResponse.md)| |
| [SearchResponse](model/SearchResponse.md)| |
| [ImageOrPrintOptions](model/ImageOrPrintOptions.md)| |
| [RenderingFont](model/RenderingFont.md)| |
| [RenderingWatermark](model/RenderingWatermark.md)| |
| [Error](model/Error.md)| Error |
| [ErrorDetails](model/ErrorDetails.md)| The error details |
| [AboveAverage](model/AboveAverage.md)| 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](model/AbstractCalculationEngine.md)| Represents user's custom calculation engine to extend the default calculation engine of Aspose.Cells. |
| [AbstractCalculationMonitor](model/AbstractCalculationMonitor.md)| Monitor for user to track the progress of formula calculation. |
| [AutoFilter](model/AutoFilter.md)| Represents autofiltering for the specified worksheet. |
| [AutoFitterOptions](model/AutoFitterOptions.md)| Represents all auto fitter options. |
| [Border](model/Border.md)| Encapsulates the object that represents the cell border. |
| [CalculationOptions](model/CalculationOptions.md)| Represents options for calculation. |
| [Cell](model/Cell.md)| Encapsulates the object that represents a single Workbook cell. |
| [Cells](model/Cells.md)| Encapsulates a collection of cell relevant objects, such as Aspose.Cells.Cell, Aspose.Cells.Row, ...etc. |
| [CellsColor](model/CellsColor.md)| Represents all types of color. |
| [CellsDocumentProperties](model/CellsDocumentProperties.md)| Excel properties |
| [CellsDocumentProperty](model/CellsDocumentProperty.md)| Cells document property. |
| [ColorFilter](model/ColorFilter.md)| Color filter. |
docs/DeveloperGuide.md view on Meta::CPAN
| [DeduplicationRegion](model/DeduplicationRegion.md)| Represents data deduplication region. |
| [DynamicFilter](model/DynamicFilter.md)| Represents the dynamic filter. |
| [FileInfo](model/FileInfo.md)| Represents file information. |
| [FileSource](model/FileSource.md)| 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](model/FilesResult.md)| Class features: Weekly lectures, group projects, midterm and final exams, and participation in class discussions. |
| [FilterColumn](model/FilterColumn.md)| Represents a filter for a single column. The Filter object is a member of the Filters collection |
| [Font](model/Font.md)| Encapsulates the font object used in a spreadsheet. |
| [FontSetting](model/FontSetting.md)| Represents a range of characters within the cell text. |
| [FormatCondition](model/FormatCondition.md)| Represents conditional formatting condition. |
| [FormulaFormatCondition](model/FormulaFormatCondition.md)| Class summary: This class covers various features related to data visualization and graphical representation of data sets. |
| [FormulaSettings](model/FormulaSettings.md)| Settings of formulas and calculation. |
| [GlobalizationSettings](model/GlobalizationSettings.md)| Represents the globalization settings. |
| [HorizontalPageBreak](model/HorizontalPageBreak.md)| Encapsulates the object that represents a horizontal page break. |
| [HorizontalPageBreaks](model/HorizontalPageBreaks.md)| Encapsulates a collection of objects. |
| [Hyperlink](model/Hyperlink.md)| Encapsulates the object that represents a hyperlink. |
| [Hyperlinks](model/Hyperlinks.md)| Encapsulates a collection of objects. |
| [IconFilter](model/IconFilter.md)| Represents icon filter. |
| [IconSet](model/IconSet.md)| Describe the IconSet conditional formatting rule. This conditional formatting rule applies icons to cells according to their values. |
| [Link](model/Link.md)| I'm glad to help! Please provide me with the features you would like me to summarize. |
| [LinkElement](model/LinkElement.md)| Class summary: The features include automatic emergency braking, lane keeping assist, adaptive cruise control, blind spot monitoring, and rear cross-traffic alert. |
| [LoadOptions](model/LoadOptions.md)| Represents the options of loading the file. |
docs/api/AddText.md view on Meta::CPAN
- **Example**
## **Interface Details**
### **Endpoint**
```
PUT http://api.aspose.cloud/v4.0/cells/content/add/text
```
### **Function Description**
Bulk-inserts the supplied string into every cell of the chosen range at the exact position you specify(prefix, suffix, before/after a given substring, or offset). - **position** enum: None, AtTheBeginning, AtTheEnd, BeforeText, AfterText. - **selec...
### The request parameters of **addText** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|Spreadsheet|File|FormData|Upload spreadsheet file.|
|text|String|Query|Specify the added text content.|
|position|String|Query|Indicates the specific location for adding text content.None, AtTheBeginning, AtTheEnd, BeforeText, AfterText.|
|selectText|String|Query|Indicates selecting the specific position to add text based on the content of the text.|
|skipEmptyCells|Boolean|Query|Indicates skip empty cells.|
docs/api/CheckWorkbookFormulaErrors.md view on Meta::CPAN
## **Quick Start**
- **Base URL**: `http://api.aspose.cloud/v3.0`
- **Authentication Method**: `JWT (OAuth2, application)` **Token URL**: `https://api.aspose.cloud/connect/token`
## **Interface Details**
### **Endpoint**
```
POST http://api.aspose.cloud/v3.0/cells/checkformulaerrors
```
### **Function Description**
### The request parameters of **checkWorkbookFormulaErrors** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|formulaErrorOptions|Class|Body||
### **Response Description**
```json
{
"Name": "CheckedFormulaErrorsResponse",
"Description": [
""
],
"Type": "Class",
"ParentName": "CellsCloudResponse",
docs/api/ExtractText.md view on Meta::CPAN
# **Spreadsheet Cloud API: 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.
## **Quick Start**
- **Base URL**: `http://api.aspose.cloud/v4.0`
- **Authentication Method**: `JWT (OAuth2, application)` **Token URL**: `https://api.aspose.cloud/connect/token`
- **Example**
## **Interface Details**
### **Endpoint**
```
PUT http://api.aspose.cloud/v4.0/cells/content/extract/text
```
### **Function Description**
Extracts substrings, numbers, or fixed-length prefixes/suffixes from the selected range and writes the results directly to the target area—no Excel formulas, no helper columns, no manual copy-paste.The engine works cell-by-cell:- **String cells** a...
### The request parameters of **extractText** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|Spreadsheet|File|FormData|Upload spreadsheet file.|
|extractTextType|String|Query|Indicates extract text type.|
|outPositionRange|String|Query|Indicates the output location for the extracted text.|
|beforeText|String|Query|Indicates extracting the text before the specified characters or substrings.|
|afterText|String|Query|Indicates extracting the text after the specified characters or substrings.|
docs/api/GetWorksheetCalculateFormula.md view on Meta::CPAN
# **Spreadsheet Cloud API: getWorksheetCalculateFormula**
Calculate formula in the worksheet.
## **Quick Start**
- **Base URL**: `http://api.aspose.cloud/v3.0`
- **Authentication Method**: `JWT (OAuth2, application)` **Token URL**: `https://api.aspose.cloud/connect/token`
- **Example**
## **Interface Details**
### **Endpoint**
```
GET http://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/formulaResult
```
### **Function Description**
PageTitle: Calculate formula in the worksheet.PageDescription: Aspose.Cells Cloud provides robust support for calculating formula in the worksheet, a process known for its intricacy.HeadTitle: Calculate formula in the worksheet.HeadSummary: Aspose.Ce...
### The request parameters of **getWorksheetCalculateFormula** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The file name.|
|sheetName|String|Path|The worksheet name.|
|formula|String|Query|The formula.|
|folder|String|Query|The folder where the file is situated.|
|storageName|String|Query|The storage name where the file is situated.|
### **Response Description**
```json
{
"Name": "SingleValueResponse",
"Description": [
"Represents the SingleValue Response."
],
docs/api/PostCellCalculate.md view on Meta::CPAN
# **Spreadsheet Cloud API: postCellCalculate**
Calculate cell formula in the worksheet.
## **Quick Start**
- **Base URL**: `http://api.aspose.cloud/v3.0`
- **Authentication Method**: `JWT (OAuth2, application)` **Token URL**: `https://api.aspose.cloud/connect/token`
- **Example**
## **Interface Details**
### **Endpoint**
```
POST http://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/cells/{cellName}/calculate
```
### **Function Description**
PageTitle: Calculate cell formula in the worksheet.PageDescription: Aspose.Cells Cloud provides robust support for calculating cell formula in the worksheet, a process known for its intricacy.HeadTitle: Calculate cell formula in the worksheet.HeadSum...
### The request parameters of **postCellCalculate** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The file name.|
|sheetName|String|Path|The worksheet name.|
|cellName|String|Path|The cell name.|
|options|Class|Body|Calculation Options|
|folder|String|Query|The folder where the file is situated.|
docs/api/PostExtractText.md view on Meta::CPAN
# **Spreadsheet Cloud API: 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.
## **Quick Start**
- **Base URL**: `http://api.aspose.cloud/v3.0`
- **Authentication Method**: `JWT (OAuth2, application)` **Token URL**: `https://api.aspose.cloud/connect/token`
## **Interface Details**
### **Endpoint**
```
POST http://api.aspose.cloud/v3.0/cells/extracttext
```
### **Function Description**
Extract substrings, characters, and digits from Excel cells with options for precise text extraction. This API simplifies complex formula tasks by enabling first character extraction, text retrieval before/after/between specified characters, substrin...
### The request parameters of **postExtractText** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|extractTextOptions|Class|Body||
### **Response Description**
```json
{
docs/api/PostWorkbookCalculateFormula.md view on Meta::CPAN
# **Spreadsheet Cloud API: postWorkbookCalculateFormula**
Calculate all formulas in the workbook.
## **Quick Start**
- **Base URL**: `http://api.aspose.cloud/v3.0`
- **Authentication Method**: `JWT (OAuth2, application)` **Token URL**: `https://api.aspose.cloud/connect/token`
- **Example**
## **Interface Details**
### **Endpoint**
```
POST http://api.aspose.cloud/v3.0/cells/{name}/calculateformula
```
### **Function Description**
PageTitle: Calculate all formulas in the workbook.PageDescription: Aspose.Cells Cloud provides robust support for calculating all formulas in the workbook, a process known for its intricacy.HeadTitle: Calculate all formulas in the workbook.HeadSumma...
### The request parameters of **postWorkbookCalculateFormula** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The file name.|
|options|Class|Body|CalculationOptions Calculation Options.|
|ignoreError|Boolean|Query|ignore Error.|
|folder|String|Query|The folder where the file is situated.|
|storageName|String|Query|The storage name where the file is situated.|
docs/api/PostWorksheetCalculateFormula.md view on Meta::CPAN
# **Spreadsheet Cloud API: postWorksheetCalculateFormula**
Calculate formula in the worksheet.
## **Quick Start**
- **Base URL**: `http://api.aspose.cloud/v3.0`
- **Authentication Method**: `JWT (OAuth2, application)` **Token URL**: `https://api.aspose.cloud/connect/token`
- **Example**
## **Interface Details**
### **Endpoint**
```
POST http://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/calculateformula
```
### **Function Description**
PageTitle: Calculate formula in the worksheet.PageDescription: Aspose.Cells Cloud provides robust support for calculating formula in the worksheet, a process known for its intricacy.HeadTitle: Calculate formula in the worksheet.HeadSummary: Aspose.Ce...
### The request parameters of **postWorksheetCalculateFormula** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The file name.|
|sheetName|String|Path|Worksheet name.|
|formula|String|Query|The formula.|
|folder|String|Query|The folder where the file is situated.|
|storageName|String|Query|The storage name where the file is situated.|
### **Response Description**
```json
{
"Name": "SingleValueResponse",
"Description": [
"Represents the SingleValue Response."
],
docs/api/PostWorksheetCellSetValue.md view on Meta::CPAN
### The request parameters of **postWorksheetCellSetValue** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The file name.|
|sheetName|String|Path|The worksheet name.|
|cellName|String|Path|The cell name.|
|value|String|Query|The cell value.|
|type|String|Query|The value type.|
|formula|String|Query|Formula for cell|
|folder|String|Query|The folder where the file is situated.|
|storageName|String|Query|The storage name where the file is situated.|
### **Response Description**
```json
{
"Name": "CellResponse",
"Description": [
"Represents the Cell Response."
],
docs/api/PutWorksheetFormatCondition.md view on Meta::CPAN
### The request parameters of **putWorksheetFormatCondition** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The file name.|
|sheetName|String|Path|The worksheet name.|
|index|Integer|Path|Gets the Conditional Formatting element at the specified index.|
|cellArea|String|Query|Adds a conditional formatted cell range.|
|type|String|Query|Format condition type(CellValue/Expression/ColorScale/DataBar/IconSet/Top10/UniqueValues/DuplicateValues/ContainsText/NotContainsText/BeginsWith/EndsWith/ContainsBlanks/NotContainsBlanks/ContainsErrors/NotContainsErrors/TimePeriod/...
|operatorType|String|Query|Represents the operator type of conditional format and data validation(Between/Equal/GreaterThan/GreaterOrEqual/LessThan/None/NotBetween/NotEqual).|
|formula1|String|Query|The value or expression associated with conditional formatting.|
|formula2|String|Query|The value or expression associated with conditional formatting.|
|folder|String|Query|The folder where the file is situated.|
|storageName|String|Query|The storage name where the file is situated.|
### **Response Description**
```json
{
"Name": "CellsCloudResponse",
"Type": "Class",
"IsAbstract": false,
"Properties": [
docs/api/PutWorksheetFormatConditionCondition.md view on Meta::CPAN
### The request parameters of **putWorksheetFormatConditionCondition** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The file name.|
|sheetName|String|Path|The worksheet name.|
|index|Integer|Path|Gets the Conditional Formatting element at the specified index.|
|type|String|Query|Format condition type(CellValue/Expression/ColorScale/DataBar/IconSet/Top10/UniqueValues/DuplicateValues/ContainsText/NotContainsText/BeginsWith/EndsWith/ContainsBlanks/NotContainsBlanks/ContainsErrors/NotContainsErrors/TimePeriod/...
|operatorType|String|Query|Represents the operator type of conditional format and data validation(Between/Equal/GreaterThan/GreaterOrEqual/LessThan/None/NotBetween/NotEqual).|
|formula1|String|Query|The value or expression associated with conditional formatting.|
|formula2|String|Query|The value or expression associated with conditional formatting.|
|folder|String|Query|The folder where the file is situated.|
|storageName|String|Query|The storage name where the file is situated.|
### **Response Description**
```json
{
"Name": "CellsCloudResponse",
"Type": "Class",
"IsAbstract": false,
"Properties": [
docs/api/RemoveCharacters.md view on Meta::CPAN
# **Spreadsheet Cloud API: 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.
## **Quick Start**
- **Base URL**: `http://api.aspose.cloud/v4.0`
- **Authentication Method**: `JWT (OAuth2, application)` **Token URL**: `https://api.aspose.cloud/connect/token`
- **Example**
## **Interface Details**
### **Endpoint**
```
PUT http://api.aspose.cloud/v4.0/cells/content/remove/characters
```
### **Function Description**
RemoveCustomText performs precise, position-based or pattern-based deletion inside the supplied range while preserving formulas, formatting and data-validation. **Removal modes** - `CustomChars` – delete each character supplied in `cust...
### The request parameters of **removeCharacters** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|Spreadsheet|File|FormData|Upload spreadsheet file.|
|removeTextMethod|String|Query|Specify the removal of text method type.|
|characterSets|String|Query|Specify the character sets.|
|removeCustomValue|String|Query|Specify the remove custom value.|
|caseSensitive|Boolean|Query||
docs/api/RemoveCharactersByPosition.md view on Meta::CPAN
# **Spreadsheet Cloud API: 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.
## **Quick Start**
- **Base URL**: `http://api.aspose.cloud/v4.0`
- **Authentication Method**: `JWT (OAuth2, application)` **Token URL**: `https://api.aspose.cloud/connect/token`
- **Example**
## **Interface Details**
docs/api/RemoveDuplicateSubstrings.md view on Meta::CPAN
# **Spreadsheet Cloud API: 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.
## **Quick Start**
- **Base URL**: `http://api.aspose.cloud/v4.0`
- **Authentication Method**: `JWT (OAuth2, application)` **Token URL**: `https://api.aspose.cloud/connect/token`
- **Example**
## **Interface Details**
### **Endpoint**
```
PUT http://api.aspose.cloud/v4.0/cells/content/remove/duplicate-substrings
```
### **Function Description**
**How duplicates are detected** 1. Each cell value is split into substrings by the chosen delimiter(s). 2. The tool compares substrings **within the same cell** and keeps only the **first occurrence** of each duplicate. 3. Cleaned substrings are r...
### The request parameters of **removeDuplicateSubstrings** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|Spreadsheet|File|FormData|Upload spreadsheet file.|
|delimiters|String|Query|comma, semicolon, space, tab, line-break |
|treatConsecutiveDelimitersAsOne|Boolean|Query|collapse adjacent delimiters into a single separator.|
|caseSensitive|Boolean|Query||
|worksheet|String|Query||
docs/api/SwapRange.md view on Meta::CPAN
# **Spreadsheet Cloud API: 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 formatti...
## **Quick Start**
- **Base URL**: `http://api.aspose.cloud/v4.0`
- **Authentication Method**: `JWT (OAuth2, application)` **Token URL**: `https://api.aspose.cloud/connect/token`
## **Interface Details**
### **Endpoint**
```
PUT http://api.aspose.cloud/v4.0/cells/swap/range
```
### **Function Description**
This API is designed to enhance productivity by simplifying the process of re-arranging data in Excel files. Users can easily swap columns, rows, ranges, or individual cells without worrying about losing data formatting or breaking formulas. The API ...
### The request parameters of **swapRange** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|Spreadsheet|File|FormData|Upload spreadsheet file.|
|worksheet1|String|Query|Specify the worksheet that is the source of the exchange data area.|
|range1|String|Query|Specify exchange data source.|
|worksheet2|String|Query|Specify the worksheet that is the target of the exchange data area.|
|range2|String|Query|Specify exchange data target.|
docs/api/TranslateSpreadsheet.md view on Meta::CPAN
- **Base URL**: `http://api.aspose.cloud/v4.0`
- **Authentication Method**: `JWT (OAuth2, application)` **Token URL**: `https://api.aspose.cloud/connect/token`
## **Interface Details**
### **Endpoint**
```
PUT http://api.aspose.cloud/v4.0/cells/ai/translate/spreadsheet
```
### **Function Description**
This method reads all text content from the spreadsheet workbook, translates it to the target language using AI translation services,and returns the translated spreadsheet file. The translation process preserves the original spreadsheet structure and...
### The request parameters of **translateSpreadsheet** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|Spreadsheet|File|FormData|Upload spreadsheet file.|
|targetLanguage|String|Query|The target language code for translation (e.g., "es", "fr", "de").|
|region|String|Query|The spreadsheet region setting.|
|password|String|Query|The password for opening spreadsheet file.|
docs/api/UpdateWordCase.md view on Meta::CPAN
- **Example**
## **Interface Details**
### **Endpoint**
```
PUT http://api.aspose.cloud/v4.0/cells/content/wordcase
```
### **Function Description**
ChangeTextCase converts the text values inside the specified range to the requested case (upper / lower / proper / sentence) while leaving formulas, formatting and data-validation intact.- Only string-type cells are processed; numbers, booleans, erro...
### The request parameters of **updateWordCase** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|Spreadsheet|File|FormData|Upload spreadsheet file.|
|wordCaseType|String|Query|Specify text case: Upper Case, Lower Case, Proper Case, Sentence Case.|
|worksheet|String|Query|Specify the worksheet of spreadsheet.|
|range|String|Query|Specify the worksheet range of spreadsheet.|
|outPath|String|Query|(Optional) The folder path where the workbook is stored. The default is null.|
docs/model/CalculationOptions.md view on Meta::CPAN
## Load the model package
```perl
use AsposeCellsCloud::Object::CalculationOptions;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**CalcStackSize** | **int** | Specifies the stack size for calculating cells recursively. |
**IgnoreError** | **boolean** | Indicates whether errors encountered while calculating formulas should be ignored. The error may be unsupported function, external links, etc. The default value is true. |
**PrecisionStrategy** | **string** | Specifies the strategy for processing precision of calculation. |
**Recursive** | **boolean** | Indicates whether calculate the dependent cells recursively when calculating one cell and it depends on other cells. The default value is true. |
**CustomEngine** | **AbstractCalculationEngine** | The custom formula calculation engine to extend the default calculation engine of Aspose.Cells. |
**CalculationMonitor** | **AbstractCalculationMonitor** | The monitor for user to track the progress of formula calculation. |
**LinkedDataSources** | **ARRAY[Workbook]** | Specifies the data sources for external links used in formulas. |
[[Back to Model list]](../DeveloperGuide.md#model-reference)
[[Back to README]](../../README.md)
docs/model/Cell.md view on Meta::CPAN
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**Name** | **string** | Gets the name of the cell. |
**Row** | **int** | Gets row number (zero based) of the cell. |
**Column** | **int** | Gets column number (zero based) of the cell. |
**Value** | **string** | Gets the value contained in this cell. |
**Type** | **string** | Represents cell value type. |
**Formula** | **string** | Gets or sets a formula of the . |
**IsFormula** | **boolean** | Represents if the specified cell contains formula. |
**IsMerged** | **boolean** | Checks if a cell is part of a merged range or not. |
**IsArrayHeader** | **boolean** | Indicates the cell's formula is and array formula and it is the first cell of the array. |
**IsInArray** | **boolean** | Indicates whether the cell formula is an array formula. |
**IsErrorValue** | **boolean** | Checks if the value of this cell is an error. |
**IsInTable** | **boolean** | Indicates whether this cell is part of table formula. |
**IsStyleSet** | **boolean** | Indicates if the cell's style is set. If return false, it means this cell has a default cell format. |
**HtmlString** | **string** | Gets and sets the html string which contains data and some formats in this cell. |
**Style** | **LinkElement** | This class property represents a style element with the specified XML element name. |
**Worksheet** | **string** | Gets the parent worksheet. |
**link** | **Link** | |
[[Back to Model list]](../DeveloperGuide.md#model-reference)
[[Back to README]](../../README.md)
docs/model/CellValue.md view on Meta::CPAN
use AsposeCellsCloud::Object::CellValue;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**rowIndex** | **int** | A public integer property called "rowIndex" with both getter and setter. |
**columnIndex** | **int** | |
**type** | **string** | |
**value** | **string** | |
**formula** | **string** | |
**style** | **Style** | |
[[Back to Model list]](../DeveloperGuide.md#model-reference)
[[Back to README]](../../README.md)
docs/model/CopyOptions.md view on Meta::CPAN
## Load the model package
```perl
use AsposeCellsCloud::Object::CopyOptions;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**ColumnCharacterWidth** | **boolean** | Indicates whether copying column width in unit of characters. |
**CopyInvalidFormulasAsValues** | **boolean** | If the formula is not valid for the dest destination, only copy values. |
**CopyNames** | **boolean** | Indicates whether copying the names. |
**ExtendToAdjacentRange** | **boolean** | Indicates whether extend ranges when copying the range to adjacent range. |
**ReferToDestinationSheet** | **boolean** | When copying the range in the same file and the chart refers to the source sheet, False means the copied chart's data source will not be changed. True means the copied chart's data sou...
**ReferToSheetWithSameName** | **boolean** | In ms excel, when copying formulas which refer to other worksheets while copying a worksheet to another one, the copied formulas should refer to source workbook. However, for some sit...
**CopyTheme** | **boolean** | |
[[Back to Model list]](../DeveloperGuide.md#model-reference)
[[Back to README]](../../README.md)
docs/model/FormulaSettings.md view on Meta::CPAN
## Load the model package
```perl
use AsposeCellsCloud::Object::FormulaSettings;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**CalculateOnOpen** | **boolean** | Indicates whether the application is required to perform a full calculation when the workbook is opened. |
**CalculateOnSave** | **boolean** | Indicates whether recalculate the workbook before saving the document, when in manual calculation mode. |
**ForceFullCalculation** | **boolean** | Indicates whether calculates all formulas every time when a calculation is triggered. |
**CalculationMode** | **string** | Gets or sets the mode for workbook calculation in ms excel. |
**CalculationId** | **string** | Specifies the version of the calculation engine used to calculate values in the workbook. |
**EnableIterativeCalculation** | **boolean** | Indicates whether enable iterative calculation to resolve circular references. |
**MaxIteration** | **int** | The maximum iterations to resolve a circular reference. |
**MaxChange** | **double** | The maximum change to resolve a circular reference. |
**PrecisionAsDisplayed** | **boolean** | Whether the precision of calculated result be set as they are displayed while calculating formulas |
**EnableCalculationChain** | **boolean** | Whether enable calculation chain for formulas. Default is false. |
**PreservePaddingSpaces** | **boolean** | Indicates whether preserve those spaces and line breaks that are padded between formula tokens while getting and setting formulas. Default value is false. |
[[Back to Model list]](../DeveloperGuide.md#model-reference)
[[Back to README]](../../README.md)
docs/model/GlobalizationSettings.md view on Meta::CPAN
```perl
use AsposeCellsCloud::Object::GlobalizationSettings;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**ChartSettings** | **ChartGlobalizationSettings** | Gets or sets the globalization settings for Chart. |
**PivotSettings** | **PivotGlobalizationSettings** | Gets or sets the globalization settings for pivot table. |
**ListSeparator** | **string** | Gets the separator for list, parameters of function, ...etc. |
**RowSeparatorOfFormulaArray** | **string** | Gets the separator for rows in array data in formula. |
**ColumnSeparatorOfFormulaArray** | **string** | Gets the separator for the items in array's row data in formula. |
[[Back to Model list]](../DeveloperGuide.md#model-reference)
[[Back to README]](../../README.md)
docs/model/ListColumn.md view on Meta::CPAN
```perl
use AsposeCellsCloud::Object::ListColumn;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**Name** | **string** | Gets and sets the name of the column. |
**Range** | **Range** | Gets the range of this list column. |
**TotalsCalculation** | **string** | Gets and sets the type of calculation in the Totals row of the list column. |
**Formula** | **string** | Gets and sets the formula of the list column. |
**TotalsRowLabel** | **string** | Gets and sets the display labels of total row. |
[[Back to Model list]](../DeveloperGuide.md#model-reference)
[[Back to README]](../../README.md)
docs/model/LoadOptions.md view on Meta::CPAN
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**ConvertNumericData** | **string** | This class has a public property named "ConvertNumericData" of type string that can be read from and written to. |
**InterruptMonitor** | **string** | Gets and sets the interrupt monitor. |
**LanguageCode** | **string** | Gets or sets the user interface language of the Workbook version based on CountryCode that has saved the file. |
**LoadDataOptions** | **string** | |
**LoadFormat** | **string** | Gets the load format. |
**OnlyLoadDocumentProperties** | **string** | |
**ParsingFormulaOnOpen** | **string** | Indicates whether parsing the formula when reading the file. |
**Password** | **string** | Gets and set the password of the workbook. |
**Region** | **string** | Gets or sets the system regional settings based on CountryCode at the time the file was loaded. |
**StandardFont** | **string** | Sets the default standard font name |
**StandardFontSize** | **double** | Sets the default standard font size. |
[[Back to Model list]](../DeveloperGuide.md#model-reference)
[[Back to README]](../../README.md)
docs/model/Name.md view on Meta::CPAN
## Load the model package
```perl
use AsposeCellsCloud::Object::Name;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**Comment** | **string** | Gets and sets the comment of the name. Only applies for Excel 2007. |
**WorksheetIndex** | **int** | Property Summary: WorksheetIndex is an optional integer property marked with the XmlElement attribute "worksheetindex". |
**IsReferred** | **boolean** | Indicates whether this name is referred by other formulas. |
**IsVisible** | **boolean** | Indicates whether the name is visible. |
**R1C1RefersTo** | **string** | Gets or sets a R1C1 reference of the . |
**RefersTo** | **string** | Returns or sets the formula that the name is defined to refer to, beginning with an equal sign. |
**Text** | **string** | Gets the name text of the object. |
**link** | **Link** | |
[[Back to Model list]](../DeveloperGuide.md#model-reference)
[[Back to README]](../../README.md)
docs/model/Style.md view on Meta::CPAN
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**Font** | **Font** | Gets a object. |
**Name** | **string** | Gets or sets the name of the style. |
**CultureCustom** | **string** | Gets and sets the culture-dependent pattern string for number format. If no number format has been set for this object, null will be returned. If number format is builtin, the pattern string corr...
**Custom** | **string** | Represents the custom number format string of this style object. If the custom number format is not set(For example, the number format is builtin), "" will be returned. |
**BackgroundColor** | **Color** | Gets or sets a style's background color. |
**ForegroundColor** | **Color** | Gets or sets a style's foreground color. |
**IsFormulaHidden** | **boolean** | Represents if the formula will be hidden when the worksheet is protected. |
**IsDateTime** | **boolean** | Indicates whether the number format is a date format. |
**IsTextWrapped** | **boolean** | Gets or sets a value indicating whether the text within a cell is wrapped. |
**IsGradient** | **boolean** | Indicates whether the cell shading is a gradient pattern. |
**IsLocked** | **boolean** | Gets or sets a value indicating whether a cell can be modified or not. |
**IsPercent** | **boolean** | Indicates whether the number format is a percent format. |
**ShrinkToFit** | **boolean** | Represents if text automatically shrinks to fit in the available column width. |
**IndentLevel** | **int** | Represents the indent level for the cell or range. Can only be an integer from 0 to 250. |
**Number** | **int** | Gets or sets the display format of numbers and dates. The formatting patterns are different for different regions. |
**RotationAngle** | **int** | Represents text rotation angle. |
**Pattern** | **string** | Gets or sets the cell background pattern type. |
docs/model/TableTotalRequest.md view on Meta::CPAN
## Load the model package
```perl
use AsposeCellsCloud::Object::TableTotalRequest;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**ListColumnIndex** | **int** | Indicates list column index. |
**TotalsCalculation** | **string** | Indicates totals calculation. |
**CustomFormula** | **string** | Indicates custom formula. |
[[Back to Model list]](../DeveloperGuide.md#model-reference)
[[Back to README]](../../README.md)
( run in 3.245 seconds using v1.01-cache-2.11-cpan-5735350b133 )