AsposeCellsCloud-CellsApi
view release on metacpan or search on metacpan
docs/api/CheckCloudServiceHealth.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**
```
GET http://api.aspose.cloud/v4.0/cells/status/check
```
### **Function Description**
This API provides real-time monitoring of Aspose.Cells Cloud service availability and operational status.Returns key health metrics such as service connectivity, response latency, and error rates(if applicable).Use cases:â–¸ Pre-flight checks before ...
### The request parameters of **checkCloudServiceHealth** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
### **Response Description**
```json
{
String
docs/api/ExportChartAsFormat.md view on Meta::CPAN
- **Example**
## **Interface Details**
### **Endpoint**
```
GET http://api.aspose.cloud/v4.0/cells/{name}/worksheets/{worksheet}/charts/{chartIndex}
```
### **Function Description**
This method processes a chart of spreadsheet directly in cloud storage, converting it to the requested output format (PDF, or Image format) without requiring the file to be downloaded to the local machine.The operation relies on valid cloud storage c...
### The request parameters of **exportChartAsFormat** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|(Required) The name of the workbook file to be retrieved.|
|worksheet|String|Path||
|chartIndex|Integer|Path||
|format|String|Query|(Required) The desired pdf or image format (e.g., "png", "Pdf", "svg").|
|folder|String|Query|(Optional) The folder path where the workbook is stored. The default is null.|
docs/api/ExportSpreadsheetAsFormat.md view on Meta::CPAN
- **Example**
## **Interface Details**
### **Endpoint**
```
GET http://api.aspose.cloud/v4.0/cells/{name}
```
### **Function Description**
This method processes a spreadsheet directly in cloud storage, converting it to the requested output format (e.g., XLSX, PDF, CSV) without requiring the file to be downloaded to the local machine.The operation relies on valid cloud storage credential...
### The request parameters of **exportSpreadsheetAsFormat** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|(Required) The name of the workbook file to be retrieved.|
|format|String|Query|(Required) The desired output format (e.g., "Xlsx", "Pdf", "Csv").|
|folder|String|Query|(Optional) The folder path where the workbook is stored. The default is null.|
|storageName|String|Query|(Optional) The name of the storage if using custom cloud storage. Use default storage if omitted.|
|outPath|String|Query|(Optional) The folder path where the workbook is stored. The default is null.|
docs/api/GetAsposeCellsCloudStatus.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**
```
GET http://api.aspose.cloud/v4.0/cells
```
### **Function Description**
This API provides real-time monitoring of Aspose.Cells Cloud service availability and operational status.Returns key health metrics such as service connectivity, response latency, and error rates(if applicable).Use cases:â–¸ Pre-flight checks before ...
### The request parameters of **getAsposeCellsCloudStatus** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
### **Response Description**
```json
{
String
docs/api/MergeRemoteSpreadsheet.md view on Meta::CPAN
- **Example**
## **Interface Details**
### **Endpoint**
```
PUT http://api.aspose.cloud/v4.0/cells/{name}/merge/spreadsheet
```
### **Function Description**
This method merges multiple spreadsheet files stored in cloud storage into a single output file in the specified format (e.g., XLSX, CSV, PDF).The operation is performed remotely, without requiring the files to be downloaded to the local machine.Vali...
### The request parameters of **mergeRemoteSpreadsheet** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The name of the workbook file to be split.|
|mergedSpreadsheet|String|Query||
|folder|String|Query|The folder path where the workbook is stored.|
|outFormat|String|Query|The out file format.|
|mergeInOneSheet|Boolean|Query|Whether to combine all data into a single worksheet.|
docs/api/MergeSpreadsheetsInRemoteFolder.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/merge/remote-spreadsheets
```
### **Function Description**
This method merges multiple spreadsheet files stored in cloud storage into a single output file in the specified format (e.g., XLSX, CSV, PDF).The operation is performed remotely, without requiring the files to be downloaded to the local machine.Vali...
### The request parameters of **mergeSpreadsheetsInRemoteFolder** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|folder|String|Query|The folder used to store the merged files.|
|fileMatchExpression|String|Query||
|outFormat|String|Query|The out file format.|
|mergeInOneSheet|Boolean|Query|Whether to combine all data into a single worksheet.|
|storageName|String|Query|(Optional) The name of the storage if using custom cloud storage. Use default storage if omitted.|
docs/api/PostAccessToken.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**
```
POST http://api.aspose.cloud/v4.0/cells/connect/token
```
### **Function Description**
- This API acts as an intermediary proxy, transparently forwarding client authentication requests to the Aspose Cloud authorization service.- Upon successful authentication, the access token issued by Aspose Cloud is returned intact to the caller.- U...
### The request parameters of **postAccessToken** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
### **Response Description**
```json
{
String
docs/api/ReplaceContentInRemoteRange.md view on Meta::CPAN
- **Example**
## **Interface Details**
### **Endpoint**
```
PUT http://api.aspose.cloud/v4.0/cells/{name}/worksheets/{worksheet}/ranges/{cellarea}/replace/content
```
### **Function Description**
This method replaces specified text within a range of spreadsheet file stored in remote cloud storage.It supports replacing occurrences of the target text across all sheets and cells of the workbook directly within the cloud environment.The operation...
### The request parameters of **replaceContentInRemoteRange** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The name of the workbook file to be replace.|
|searchText|String|Query|The searched text.|
|replaceText|String|Query|The replaced text.|
|worksheet|String|Path|The worksheet name.|
|cellArea|String|Path|The cell area for the replace.|
docs/api/ReplaceContentInRemoteSpreadsheet.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/{name}/replace/content
```
### **Function Description**
This method replaces specified text within a spreadsheet file stored in remote cloud storage.It supports replacing occurrences of the target text across all sheets and cells of the workbook directly within the cloud environment.The operation is perfo...
### The request parameters of **replaceContentInRemoteSpreadsheet** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The name of the workbook file to be replace.|
|searchText|String|Query|The searched text.|
|replaceText|String|Query|The replaced text.|
|folder|String|Query|The folder path where the workbook is stored.|
|storageName|String|Query|(Optional) The name of the storage if using custom cloud storage. Use default storage if omitted.|
docs/api/ReplaceContentInRemoteWorksheet.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/{name}/worksheets/{worksheet}/replace/content
```
### **Function Description**
This method replaces specified text within a worksheet of spreadsheet file stored in remote cloud storage.It supports replacing occurrences of the target text across all sheets and cells of the workbook directly within the cloud environment.The opera...
### The request parameters of **replaceContentInRemoteWorksheet** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The name of the workbook file to be replace.|
|worksheet|String|Path|Specify the worksheet for the replace.|
|searchText|String|Query|The searched text.|
|replaceText|String|Query|The replaced text.|
|folder|String|Query|The folder path where the workbook is stored.|
docs/api/SaveSpreadsheetAs.md view on Meta::CPAN
- **Example**
## **Interface Details**
### **Endpoint**
```
PUT http://api.aspose.cloud/v4.0/cells/{name}/saveas
```
### **Function Description**
This method accesses a spreadsheet file directly from cloud storage, converts it into the desired output format (e.g., XLSX, PDF, CSV), and returns the converted result without downloading the file to the local system.Ensure that the cloud storage co...
### The request parameters of **saveSpreadsheetAs** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|(Required) The name of the workbook file to be converted.|
|format|String|Query|(Required) The desired output format (e.g., "Xlsx", "Pdf", "Csv").|
|saveOptionsData|Class|Body|(Optional) Save options data. The default is null.|
|folder|String|Query|(Optional) The folder path where the workbook is stored. The default is null.|
|storageName|String|Query|(Optional) The name of the storage if using custom cloud storage. Use default storage if omitted.|
docs/api/SearchBrokenLinksInRemoteRange.md view on Meta::CPAN
- **Example**
## **Interface Details**
### **Endpoint**
```
PUT http://api.aspose.cloud/v4.0/cells/{name}/worksheets/{worksheet}/ranges/{cellArea}search/broken-links
```
### **Function Description**
This method searches for broken links within a range of spreadsheet file stored in remote cloud storage.It scans all sheets and cells to identify hyperlinks that no longer point to valid destinations, such as dead URLs or missing external references....
### The request parameters of **searchBrokenLinksInRemoteRange** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The name of the workbook file to be search.|
|worksheet|String|Path|Specify the worksheet for the lookup.|
|cellArea|String|Path|Specify the cell area for the lookup|
|folder|String|Query|The folder path where the workbook is stored.|
|storageName|String|Query|(Optional) The name of the storage if using custom cloud storage. Use default storage if omitted.|
docs/api/SearchBrokenLinksInRemoteSpreadsheet.md view on Meta::CPAN
- **Example**
## **Interface Details**
### **Endpoint**
```
PUT http://api.aspose.cloud/v4.0/cells/{name}/search/broken-links
```
### **Function Description**
This method searches for broken links within a spreadsheet file stored in remote cloud storage.It scans all sheets and cells to identify hyperlinks that no longer point to valid destinations, such as dead URLs or missing external references.The opera...
### The request parameters of **searchBrokenLinksInRemoteSpreadsheet** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The name of the workbook file to be search.|
|worksheet|String|Query|Specify the worksheet for the lookup.|
|cellArea|String|Query|Specify the cell area for the lookup|
|folder|String|Query|The folder path where the workbook is stored.|
|storageName|String|Query|(Optional) The name of the storage if using custom cloud storage. Use default storage if omitted.|
docs/api/SearchBrokenLinksInRemoteWorksheet.md view on Meta::CPAN
- **Example**
## **Interface Details**
### **Endpoint**
```
PUT http://api.aspose.cloud/v4.0/cells/{name}/worksheets/{worksheet}/search/broken-links
```
### **Function Description**
This method searches for broken links within a worksheet of spreadsheet file stored in remote cloud storage.It scans all sheets and cells to identify hyperlinks that no longer point to valid destinations, such as dead URLs or missing external referen...
### The request parameters of **searchBrokenLinksInRemoteWorksheet** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The name of the workbook file to be search.|
|worksheet|String|Path|Specify the worksheet for the lookup.|
|folder|String|Query|The folder path where the workbook is stored.|
|storageName|String|Query|(Optional) The name of the storage if using custom cloud storage. Use default storage if omitted.|
|regoin|String|Query|The spreadsheet region setting.|
docs/api/SearchContentInRemoteRange.md view on Meta::CPAN
- **Example**
## **Interface Details**
### **Endpoint**
```
PUT http://api.aspose.cloud/v4.0/cells/{name}/worksheets/{worksheet}/ranges/{cellArea}/search/content
```
### **Function Description**
This method searches for specified text within a range of spreadsheet file stored in remote cloud storage.It supports searching through all sheets and cells of the workbook, identifying occurrences of the search term directly within the cloud environ...
### The request parameters of **searchContentInRemoteRange** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path||
|worksheet|String|Path||
|cellArea|String|Path||
|searchText|String|Query||
|ignoringCase|Boolean|Query||
docs/api/SearchContentInRemoteSpreadsheet.md view on Meta::CPAN
- **Example**
## **Interface Details**
### **Endpoint**
```
PUT http://api.aspose.cloud/v4.0/cells/{name}/search/content
```
### **Function Description**
This method searches for specified text within a spreadsheet file stored in remote cloud storage.It supports searching through all sheets and cells of the workbook, identifying occurrences of the search term directly within the cloud environment.The ...
### The request parameters of **searchContentInRemoteSpreadsheet** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The name of the workbook file to be search.|
|searchText|String|Query|The searched text.|
|ignoringCase|Boolean|Query|Ignore the text of the search.|
|folder|String|Query|The folder path where the workbook is stored.|
|storageName|String|Query|(Optional) The name of the storage if using custom cloud storage. Use default storage if omitted.|
docs/api/SearchContentInRemoteWorksheet.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/{name}/worksheets/{worksheet}/search/content
```
### **Function Description**
This method searches for specified text within a worksheet of spreadsheet file stored in remote cloud storage.It supports searching through all sheets and cells of the workbook, identifying occurrences of the search term directly within the cloud env...
### The request parameters of **searchContentInRemoteWorksheet** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The name of the workbook file to be search.|
|worksheet|String|Path|The name of worksheet|
|searchText|String|Query|The searched text.|
|ignoringCase|Boolean|Query|Ignore the text of the search.|
|folder|String|Query|The folder path where the workbook is stored.|
docs/api/SplitRemoteSpreadsheet.md view on Meta::CPAN
- **Example**
## **Interface Details**
### **Endpoint**
```
PUT http://api.aspose.cloud/v4.0/cells/{name}/split/spreadsheet
```
### **Function Description**
This method splits a single spreadsheet file stored in cloud storage into multiple output files in the specified format (e.g., XLSX, CSV, PDF).Each split file may represent different sheets, sections, or segments of the original document based on use...
### The request parameters of **splitRemoteSpreadsheet** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The name of the workbook file to be split.|
|folder|String|Query|The folder path where the workbook is stored.|
|from|Integer|Query|Begin worksheet index.|
|to|Integer|Query|End worksheet index.|
|outFormat|String|Query|The desired output format (e.g., "Xlsx", "Pdf", "Csv").|
lib/AsposeCellsCloud/ApiClient.pm view on Meta::CPAN
my ($self, %args) = @_;
if(!$self->need_auth()){
return;
}
if($self->{get_access_token_time}){
my $difference_in_seconds=time() - $self->{get_access_token_time};
if($difference_in_seconds < 86300){
return;
}
}
my $access_token = $self->o_auth_post('grant_type' => "client_credentials", 'client_id' => $self->{config}->{client_id}, 'client_secret' =>$self->{config}->{client_secret})->access_token;
$self->{config}->{access_token} = $access_token;
}
# make the HTTP request
# @param string $resourcePath path to method endpoint
# @param string $method method to call
# @param array $queryParams parameters to be place in query URL
# @param array $postData parameters to be placed in POST body
# @param array $headerParams parameters to be place in request header
# @return mixed
lib/AsposeCellsCloud/CellsApi.pm view on Meta::CPAN
my $class = shift;
my $api_client;
if ($_[0] && ref $_[0] && ref $_[0] eq 'AsposeCellsCloud::ApiClient' ) {
$api_client = $_[0];
} else {
$api_client = AsposeCellsCloud::ApiClient->new(@_);
}
if($api_client->need_auth()){
my $access_token = $api_client->o_auth_post('grant_type' => "client_credentials", 'client_id' => $api_client->{config}->{client_id}, 'client_secret' =>$api_client->{config}->{client_secret})->access_token;
$api_client->{config}->{access_token} = $access_token;
}
bless { api_client => $api_client }, $class;
}
#
# PostAccessTokenRequest
#
( run in 0.694 second using v1.01-cache-2.11-cpan-2b1a40005be )