AsposeCellsCloud-CellsApi
view release on metacpan or search on metacpan
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/DeleteWorksheetColumns.md view on Meta::CPAN
PageTitle: Delete worksheet columns in the worksheet.PageDescription: Aspose.Cells Cloud provides robust support for deleting worksheet columns in the worksheet, a process known for its intricacy.HeadTitle: Delete worksheet columns in the worksheet.H...
### The request parameters of **deleteWorksheetColumns** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The file name.|
|sheetName|String|Path|The worksheet name.|
|columnIndex|Integer|Path|The column index.|
|columns|Integer|Query|The number of columns.|
|updateReference|Boolean|Query|Indicates if references in other worksheets will be updated.|
|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/PutInsertWorksheetColumns.md view on Meta::CPAN
PageTitle: Insert worksheet columns in the worksheet.PageDescription: Aspose.Cells Cloud provides robust support for inserting worksheet columns in the worksheet, a process known for its intricacy.HeadTitle: Insert worksheet columns in the worksheet....
### The request parameters of **putInsertWorksheetColumns** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The file name.|
|sheetName|String|Path|The worksheet name.|
|columnIndex|Integer|Path|The column index.|
|columns|Integer|Query|The number of columns.|
|updateReference|Boolean|Query|Indicates if references in other worksheets will be updated.|
|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
- **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/RemoveDuplicateSubstrings.md view on Meta::CPAN
- **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/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.|
lib/AsposeCellsCloud/CellsApi.pm view on Meta::CPAN
#
# PutInsertWorksheetColumnsRequest
#
# Insert worksheet columns in the worksheet.
#
# @name string (required) The file name.
# @sheetName string (required) The worksheet name.
# @columnIndex int (required) The column index.
# @columns int (required) The number of columns.
# @updateReference boolean Indicates if references in other worksheets will be updated.
# @folder string The folder where the file is situated.
# @storageName string The storage name where the file is situated.
#
{
my $params = {
'request' =>{
data_type => 'PutInsertWorksheetColumnsRequest',
description => 'PutInsertWorksheetColumns Request.',
required => '0',
}
lib/AsposeCellsCloud/CellsApi.pm view on Meta::CPAN
#
# DeleteWorksheetColumnsRequest
#
# Delete worksheet columns in the worksheet.
#
# @name string (required) The file name.
# @sheetName string (required) The worksheet name.
# @columnIndex int (required) The column index.
# @columns int (required) The number of columns.
# @updateReference boolean (required) Indicates if references in other worksheets will be updated.
# @folder string The folder where the file is situated.
# @storageName string The storage name where the file is situated.
#
{
my $params = {
'request' =>{
data_type => 'DeleteWorksheetColumnsRequest',
description => 'DeleteWorksheetColumns Request.',
required => '0',
}
lib/AsposeCellsCloud/Request/DeleteWorksheetColumnsRequest.pm view on Meta::CPAN
return $self;
}
# Run Operation Request
# DeleteWorksheetColumnsRequest.name : The file name. ,
# DeleteWorksheetColumnsRequest.sheetName : The worksheet name. ,
# DeleteWorksheetColumnsRequest.columnIndex : The column index. ,
# DeleteWorksheetColumnsRequest.columns : The number of columns. ,
# DeleteWorksheetColumnsRequest.updateReference : Indicates if references in other worksheets will be updated. ,
# DeleteWorksheetColumnsRequest.folder : The folder where the file is situated. ,
# DeleteWorksheetColumnsRequest.storageName : The storage name where the file is situated.
{
my $params = {
'client' =>{
data_type => 'ApiClient',
description => 'API Client.',
required => '0',
}
lib/AsposeCellsCloud/Request/DeleteWorksheetColumnsRequest.pm view on Meta::CPAN
'columns' => {
datatype => 'int',
base_name => 'columns',
description => 'The number of columns.',
format => '',
read_only => '',
},
'update_reference' => {
datatype => 'string',
base_name => 'updateReference',
description => 'Indicates if references in other worksheets will be updated.',
format => '',
read_only => '',
},
'folder' => {
datatype => 'string',
base_name => 'folder',
description => 'The folder where the file is situated.',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Request/PutInsertWorksheetColumnsRequest.pm view on Meta::CPAN
return $self;
}
# Run Operation Request
# PutInsertWorksheetColumnsRequest.name : The file name. ,
# PutInsertWorksheetColumnsRequest.sheetName : The worksheet name. ,
# PutInsertWorksheetColumnsRequest.columnIndex : The column index. ,
# PutInsertWorksheetColumnsRequest.columns : The number of columns. ,
# PutInsertWorksheetColumnsRequest.updateReference : Indicates if references in other worksheets will be updated. ,
# PutInsertWorksheetColumnsRequest.folder : The folder where the file is situated. ,
# PutInsertWorksheetColumnsRequest.storageName : The storage name where the file is situated.
{
my $params = {
'client' =>{
data_type => 'ApiClient',
description => 'API Client.',
required => '0',
}
lib/AsposeCellsCloud/Request/PutInsertWorksheetColumnsRequest.pm view on Meta::CPAN
'columns' => {
datatype => 'int',
base_name => 'columns',
description => 'The number of columns.',
format => '',
read_only => '',
},
'update_reference' => {
datatype => 'string',
base_name => 'updateReference',
description => 'Indicates if references in other worksheets will be updated.',
format => '',
read_only => '',
},
'folder' => {
datatype => 'string',
base_name => 'folder',
description => 'The folder where the file is situated.',
format => '',
read_only => '',
},
( run in 1.004 second using v1.01-cache-2.11-cpan-97f6503c9c8 )