view release on metacpan or  search on metacpan

docs/api/ExtractText.md  view on Meta::CPAN

- **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/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||
|treatConsecutiveDelimitersAsOne|Boolean|Query||
|caseSensitive|Boolean|Query||
|worksheet|String|Query||