AsposeCellsCloud-CellsApi
view release on metacpan or search on metacpan
lib/AsposeCellsCloud/CellsApi.pm view on Meta::CPAN
#
{
my $params = {
'request' =>{
data_type => 'TrimCharacterRequest',
description => 'TrimCharacter Request.',
required => '0',
}
};
__PACKAGE__->method_documentation->{ 'trim_character' } = {
summary => '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 selected cells. It is particu...
params => $params,
returns => 'string',
};
}
#
# @return string
#
sub trim_character{
my ($self, %args) = @_;
my $request = $args{'request'};
my $response = $request->run_http_request('client' => $self->{api_client} );
if (!$response) {
return;
}
my $_response_object = $self->{api_client}->deserialize('string', $response);
return $_response_object;
}
#
# UpdateWordCaseRequest
#
# 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 according to specific needs.
#
# @Spreadsheet string (required) Upload spreadsheet file.
# @wordCaseType string (required) Specify text case: Upper Case, Lower Case, Proper Case, Sentence Case.
# @worksheet string Specify the worksheet of spreadsheet.
# @range string Specify the worksheet range of spreadsheet.
# @outPath string (Optional) The folder path where the workbook is stored. The default is null.
# @outStorageName string Output file Storage Name.
# @region string The spreadsheet region setting.
# @password string The password for opening spreadsheet file.
#
{
my $params = {
'request' =>{
data_type => 'UpdateWordCaseRequest',
description => 'UpdateWordCase Request.',
required => '0',
}
};
__PACKAGE__->method_documentation->{ 'update_word_case' } = {
summary => '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 according to specific needs.',
params => $params,
returns => 'string',
};
}
#
# @return string
#
sub update_word_case{
my ($self, %args) = @_;
my $request = $args{'request'};
my $response = $request->run_http_request('client' => $self->{api_client} );
if (!$response) {
return;
}
my $_response_object = $self->{api_client}->deserialize('string', $response);
return $_response_object;
}
#
# RemoveCharactersRequest
#
# Deletes user-defined characters, predefined symbol sets, or any substring from every cell in the chosen range while preserving formulas, formatting and data-validation.
#
# @Spreadsheet string (required) Upload spreadsheet file.
# @removeTextMethod string Specify the removal of text method type.
# @characterSets string Specify the character sets.
# @removeCustomValue string Specify the remove custom value.
# @caseSensitive boolean
# @worksheet string Specify the worksheet of spreadsheet.
# @range string Specify the worksheet range of spreadsheet.
# @outPath string (Optional) The folder path where the workbook is stored. The default is null.
# @outStorageName string Output file Storage Name.
# @region string The spreadsheet region setting.
# @password string The password for opening spreadsheet file.
#
{
my $params = {
'request' =>{
data_type => 'RemoveCharactersRequest',
description => 'RemoveCharacters Request.',
required => '0',
}
};
__PACKAGE__->method_documentation->{ 'remove_characters' } = {
summary => 'Deletes user-defined characters, predefined symbol sets, or any substring from every cell in the chosen range while preserving formulas, formatting and data-validation.',
params => $params,
returns => 'string',
};
}
#
# @return string
#
sub remove_characters{
my ($self, %args) = @_;
my $request = $args{'request'};
my $response = $request->run_http_request('client' => $self->{api_client} );
if (!$response) {
return;
}
my $_response_object = $self->{api_client}->deserialize('string', $response);
return $_response_object;
}
#
# RemoveCharactersByPositionRequest
#
# 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.
#
( run in 0.430 second using v1.01-cache-2.11-cpan-5b529ec07f3 )