AsposeCellsCloud-CellsApi
view release on metacpan or search on metacpan
docs/Chart.md view on Meta::CPAN
**DepthPercent** | **int** | Represents the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent). |
**Elevation** | **int** | Represents the elevation of the 3-D chart view, in degrees. |
**FirstSliceAngle** | **int** | Gets or sets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical). Applies only to pie, 3-D pie, and doughnut charts, 0 to 360. |
**Floor** | **Floor** | Returns a object that represents the walls of a 3-D chart. |
**GapDepth** | **int** | Gets or sets the distance between the data series in a 3-D chart, as a percentage of the marker width. The value of this property must be between 0 and 500. |
**GapWidth** | **int** | Returns or sets the space between bar or column clusters, as a percentage of the bar or column width. The value of this property must be between 0 and 500. |
**HeightPercent** | **int** | Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent). |
**HidePivotFieldButtons** | **boolean** | Indicates whether hide the pivot chart field buttons only when the chart is PivotChart. |
**Is3D** | **boolean** | Indicates whether the chart is a 3d chart. |
**IsRectangularCornered** | **boolean** | Gets or sets a value indicating whether the chart area is rectangular cornered. Default is true. |
**Legend** | **Legend** | Gets the chart legend. |
**Name** | **string** | Represents chart name. |
**NSeries** | **SeriesItems** | Gets a collection representing the data series in the chart. |
**PageSetup** | **LinkElement** | Represents the page setup description in this chart. |
**Perspective** | **int** | Returns or sets the perspective for the 3-D chart view. Must be between 0 and 100. This property is ignored if the RightAngleAxes property is True. |
**PivotSource** | **string** | The source is the data of the pivotTable. If PivotSource is not empty ,the chart is PivotChart. |
**Placement** | **string** | Represents the way the chart is attached to the cells below it. |
**PlotArea** | **PlotArea** | Gets the chart's plot area which includes axis tick labels. |
**PlotEmptyCellsType** | **string** | Gets and sets how to plot the empty cells. |
**PlotVisibleCells** | **boolean** | Indicates whether only plot visible cells. |
**PrintSize** | **string** | Gets and sets the printed chart size. |
**RightAngleAxes** | **boolean** | True if the chart axes are at right angles. Applies only for 3-D charts(except Column3D and 3-D Pie Charts). |
**RotationAngle** | **int** | Represents the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees). |
**SecondCategoryAxis** | **LinkElement** | Gets the chart's second X axis. |
**SecondValueAxis** | **LinkElement** | Gets the chart's second Y axis. |
**SeriesAxis** | **LinkElement** | Gets the chart's series axis. |
**Shapes** | **LinkElement** | Returns all drawing shapes in this chart. |
**ShowDataTable** | **boolean** | Gets or sets a value indicating whether the chart displays a data table. |
**ShowLegend** | **boolean** | Gets or sets a value indicating whether the chart legend will be displayed. Default is true. |
**SideWall** | **LinkElement** | Returns a object that represents the side wall of a 3-D chart. |
**SizeWithWindow** | **boolean** | True if Microsoft Excel resizes the chart to match the size of the chart sheet window. |
**Style** | **int** | Gets and sets the builtin style. |
**Title** | **LinkElement** | Represents chart title. |
**Type** | **string** | Represents chart type. |
**ValueAxis** | **Axis** | Gets the chart's Y axis. |
**Walls** | **LinkElement** | Returns a object that represents the walls of a 3-D chart. |
**WallsAndGridlines2D** | **boolean** | True if gridlines are drawn two-dimensionally on a 3-D chart. |
**link** | **Link** | |
docs/ChartDataTable.md view on Meta::CPAN
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**AutoScaleFont** | **boolean** | True if the text in the object changes font size when the object size changes. The default value is True. |
**BackgroundMode** | **string** | Gets and sets the display mode of the background |
**Border** | **Line** | Returns a Border object that represents the border of the object |
**Font** | **Font** | Gets a object which represents the font setting of the specified chart data table. |
**HasBorderHorizontal** | **boolean** | True if the chart data table has horizontal cell borders |
**HasBorderOutline** | **boolean** | True if the chart data table has outline borders |
**HasBorderVertical** | **boolean** | True if the chart data table has vertical cell borders |
**ShowLegendKey** | **boolean** | True if the data label legend key is visible. |
**link** | **Link** | |
[[Back to Model list]](../README.md#documentation-for-models) [[Back to API list]](../README.md#documentation-for-api-endpoints) [[Back to README]](../README.md)
docs/DataLabels.md view on Meta::CPAN
**IsDeleted** | **boolean** | A nullable boolean property "IsDeleted" indicating whether an object has been deleted. |
**LinkedSource** | **string** | |
**Number** | **int** | Gets and sets the built-in number format. |
**NumberFormat** | **string** | Represents the format string for the DataLabels object. |
**NumberFormatLinked** | **boolean** | True if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells). |
**Position** | **string** | Represents the position of the data label. |
**RotationAngle** | **int** | |
**Separator** | **string** | Gets or sets the separator type used for the data labels on a chart. |
**ShowBubbleSize** | **boolean** | Represents a specified chart's data label percentage value display behavior. True displays the percentage value. False to hide. |
**ShowCategoryName** | **boolean** | Represents a specified chart's data label category name display behavior.True to display the category name for the data labels on a chart. False to hide. |
**ShowLegendKey** | **boolean** | Represents a specified chart's data label legend key display behavior. True if the data label legend key is visible. |
**ShowPercentage** | **boolean** | Represents a specified chart's data label percentage value display behavior. True displays the percentage value. False to hide. |
**ShowSeriesName** | **boolean** | Returns or sets a Boolean to indicate the series name display behavior for the data labels on a chart. True to show the series name. False to hide. |
**ShowValue** | **boolean** | Represents a specified chart's data label values display behavior. True displays the values. False to hide. |
**Text** | **string** | Gets or sets the text of data label. |
**TextDirection** | **string** | |
**TextHorizontalAlignment** | **string** | |
**TextVerticalAlignment** | **string** | |
**Area** | **Area** | |
**AutoScaleFont** | **boolean** | |
**BackgroundMode** | **string** | |
docs/Legend.md view on Meta::CPAN
# AsposeCellsCloud::Object::Legend
## Load the model package
```perl
use AsposeCellsCloud::Object::Legend;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**Position** | **string** | Gets or sets the legend position type. |
**LegendEntries** | **LinkElement** | Gets a collection of all the LegendEntry objects in the specified chart legend. Setting the legend entries of the surface chart is not supported. So it will return nu...
**Area** | **Area** | |
**AutoScaleFont** | **boolean** | |
**BackgroundMode** | **string** | |
**Border** | **Line** | |
**Font** | **Font** | |
**IsAutomaticSize** | **boolean** | |
**IsInnerMode** | **boolean** | |
**Shadow** | **boolean** | |
**Width** | **int** | |
**Height** | **int** | |
docs/LegendEntries.md view on Meta::CPAN
# AsposeCellsCloud::Object::LegendEntries
## Load the model package
```perl
use AsposeCellsCloud::Object::LegendEntries;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**legendEntryList** | **ARRAY[LinkElement]** | Property: Utilizes XML element "LengendEntry" to represent a list of LinkElement items in the class. |
**link** | **Link** | |
[[Back to Model list]](../README.md#documentation-for-models) [[Back to API list]](../README.md#documentation-for-api-endpoints) [[Back to README]](../README.md)
docs/LegendEntriesResponse.md view on Meta::CPAN
# AsposeCellsCloud::Object::LegendEntriesResponse
## Load the model package
```perl
use AsposeCellsCloud::Object::LegendEntriesResponse;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**LegendEntries** | **LegendEntries** | Property Summary: The class includes a property for managing legend entries. |
**Code** | **int** | |
**Status** | **string** | |
[[Back to Model list]](../README.md#documentation-for-models) [[Back to API list]](../README.md#documentation-for-api-endpoints) [[Back to README]](../README.md)
docs/LegendEntry.md view on Meta::CPAN
```perl
use AsposeCellsCloud::Object::LegendEntry;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**AutoScaleFont** | **boolean** | True if the text in the object changes font size when the object size changes. The default value is True. |
**BackgroundMode** | **string** | Gets and sets the display mode of the background |
**Font** | **Font** | Gets a object of the specified ChartFrame object. |
**IsDeleted** | **boolean** | Gets and sets whether the legend entry is deleted. |
**link** | **Link** | |
[[Back to Model list]](../README.md#documentation-for-models) [[Back to API list]](../README.md#documentation-for-api-endpoints) [[Back to README]](../README.md)
docs/PostWorksheetChartLegendRequest.md view on Meta::CPAN
```perl
use AsposeCellsCloud::Request::PostWorksheetChartLegend;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**name** | **string** | The file name. |
**sheet_name** | **string** | The worksheet name. |
**chart_index** | **int** | The chart index. |
**legend** | **Legend** | |
**folder** | **string** | The folder where the file is situated. |
**storage_name** | **string** | The storage name where the file is situated. |
[[Back to Model list]](../README.md#documentation-for-requests) [[Back to API list]](../README.md#documentation-for-api-endpoints) [[Back to README]](../README.md)
docs/Series.md view on Meta::CPAN
**HasDropLines** | **boolean** | True if the chart has drop lines. Applies only to line chart or area charts. |
**HasHiLoLines** | **boolean** | True if the line chart has high-low lines. Applies only to line charts. |
**HasLeaderLines** | **boolean** | True if the series has leader lines. |
**HasRadarAxisLabels** | **boolean** | True if a radar chart has category axis labels. Applies only to radar charts. |
**HasSeriesLines** | **boolean** | True if a stacked column chart or bar chart has series lines or if a Pie of Pie chart or Bar of Pie chart has connector lines between the two sections. Applies only to ...
**HasUpDownBars** | **boolean** | True if a line chart has up and down bars. Applies only to line charts. |
**HiLoLines** | **Line** | Returns a HiLoLines object that represents the high-low lines for a series on a line chart. Applies only to line charts. |
**IsAutoSplit** | **boolean** | Indicates whether the threshold value is automatic. |
**IsColorVaried** | **boolean** | Represents if the color of points is varied. The chart must contain only one series. |
**LeaderLines** | **Line** | Represents leader lines on a chart. Leader lines connect data labels to data points. This object isn’t a collection; there’s no object that represents a single leader line. |
**LegendEntry** | **LegendEntry** | Gets the legend entry according to this series. |
**Marker** | **Marker** | Gets the marker. |
**Name** | **string** | Gets or sets the name of the data series. |
**Overlap** | **int** | Specifies how bars and columns are positioned. Can be a value between – 100 and 100. Applies only to 2-D bar and 2-D column charts. |
**PlotOnSecondAxis** | **boolean** | Indicates if this series is plotted on second value axis. |
**Points** | **LinkElement** | Gets the collection of points in a series in a chart. |
**SecondPlotSize** | **int** | Returns or sets the size of the secondary section of either a pie of pie chart or a bar of pie chart, as a percentage of the size of the primary pie. Can be a value from 5 ...
**SeriesLines** | **Line** | Returns a SeriesLines object that represents the series lines for a stacked bar chart or a stacked column chart. Applies only to stacked bar and stacked column charts. |
**Shadow** | **boolean** | True if the series has a shadow. |
**ShowNegativeBubbles** | **boolean** | True if negative bubbles are shown for the chart group. Valid only for bubble charts. |
**SizeRepresents** | **string** | Gets or sets what the bubble size represents on a bubble chart. |
docs/Trendline.md view on Meta::CPAN
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**link** | **Link** | The class has a property named "link" of type "Link" that can be accessed and modified. |
**Backward** | **double** | Returns or sets the number of periods (or units on a scatter chart) that the trendline extends backward. The number of periods must be greater than or equal to zero. If the ch...
**DataLabels** | **DataLabels** | Represents the DataLabels object for the specified series. |
**DisplayEquation** | **boolean** | Represents if the equation for the trendline is displayed on the chart (in the same data label as the R-squared value). Setting this property to True automatically turns on data labels. |
**DisplayRSquared** | **boolean** | Represents if the R-squared value of the trendline is displayed on the chart (in the same data label as the equation). Setting this property to True automatically turns on data labels. |
**Forward** | **double** | Returns or sets the number of periods (or units on a scatter chart) that the trendline extends forward. The number of periods must be greater than or equal to zero. |
**Intercept** | **double** | Returns or sets the point where the trendline crosses the value axis. |
**IsNameAuto** | **boolean** | Returns if Microsoft Excel automatically determines the name of the trendline. |
**LegendEntry** | **LegendEntry** | Gets the legend entry according to this trendline |
**Name** | **string** | Returns the name of the trendline. |
**Order** | **int** | Returns or sets the trendline order (an integer greater than 1) when the trendline type is Polynomial. The order must be between 2 and 6. |
**Period** | **int** | Returns or sets the period for the moving-average trendline. |
**Type** | **string** | Returns the trendline type. |
**BeginArrowLength** | **string** | |
**BeginArrowWidth** | **string** | |
**BeginType** | **string** | |
**CapType** | **string** | |
**Color** | **Color** | |
**CompoundType** | **string** | |
lib/AsposeCellsCloud/CellsApi.pm view on Meta::CPAN
if (!$response) {
return;
}
my $_response_object = $self->{api_client}->deserialize('CellsCloudResponse', $response);
return $_response_object;
}
#
# GetWorksheetChartLegendRequest
#
# Retrieve chart legend description in the worksheet.
#
# @name string (required) The file name.
# @sheetName string (required) The worksheet name.
# @chartIndex int (required) The chart index.
# @folder string The folder where the file is situated.
# @storageName string The storage name where the file is situated.
#
{
my $params = {
'request' =>{
data_type => 'GetWorksheetChartLegendRequest',
description => 'GetWorksheetChartLegend Request.',
required => '0',
}
};
__PACKAGE__->method_documentation->{ 'get_worksheet_chart_legend' } = {
summary => 'Retrieve chart legend description in the worksheet.',
params => $params,
returns => 'LegendResponse',
};
}
#
# @return LegendResponse
#
sub get_worksheet_chart_legend{
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('LegendResponse', $response);
return $_response_object;
}
#
# PostWorksheetChartLegendRequest
#
# Update chart legend in the worksheet.
#
# @name string (required) The file name.
# @sheetName string (required) The worksheet name.
# @chartIndex int (required) The chart index.
# @legend Legend (required)
# @folder string The folder where the file is situated.
# @storageName string The storage name where the file is situated.
#
{
my $params = {
'request' =>{
data_type => 'PostWorksheetChartLegendRequest',
description => 'PostWorksheetChartLegend Request.',
required => '0',
}
};
__PACKAGE__->method_documentation->{ 'post_worksheet_chart_legend' } = {
summary => 'Update chart legend in the worksheet.',
params => $params,
returns => 'CellsCloudResponse',
};
}
#
# @return CellsCloudResponse
#
sub post_worksheet_chart_legend{
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('CellsCloudResponse', $response);
return $_response_object;
}
#
# PutWorksheetChartLegendRequest
#
# Show chart legend in the worksheet.
#
# @name string (required) The file name.
# @sheetName string (required) The worksheet name.
# @chartIndex int (required) The chart index.
# @folder string The folder where the file is situated.
# @storageName string The storage name where the file is situated.
#
{
my $params = {
'request' =>{
data_type => 'PutWorksheetChartLegendRequest',
description => 'PutWorksheetChartLegend Request.',
required => '0',
}
};
__PACKAGE__->method_documentation->{ 'put_worksheet_chart_legend' } = {
summary => 'Show chart legend in the worksheet.',
params => $params,
returns => 'CellsCloudResponse',
};
}
#
# @return CellsCloudResponse
#
sub put_worksheet_chart_legend{
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('CellsCloudResponse', $response);
return $_response_object;
}
#
# DeleteWorksheetChartLegendRequest
#
# Hides chart legend in the worksheet.
#
# @name string (required) The file name.
# @sheetName string (required) The worksheet name.
# @chartIndex int (required) The chart index.
# @folder string The folder where the file is situated.
# @storageName string The storage name where the file is situated.
#
{
my $params = {
'request' =>{
data_type => 'DeleteWorksheetChartLegendRequest',
description => 'DeleteWorksheetChartLegend Request.',
required => '0',
}
};
__PACKAGE__->method_documentation->{ 'delete_worksheet_chart_legend' } = {
summary => 'Hides chart legend in the worksheet.',
params => $params,
returns => 'CellsCloudResponse',
};
}
#
# @return CellsCloudResponse
#
sub delete_worksheet_chart_legend{
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('CellsCloudResponse', $response);
return $_response_object;
}
lib/AsposeCellsCloud/Object/Chart.pm view on Meta::CPAN
format => '',
read_only => '',
},
'is_rectangular_cornered' => {
datatype => 'boolean',
base_name => 'IsRectangularCornered',
description => 'Gets or sets a value indicating whether the chart area is rectangular cornered. Default is true.',
format => '',
read_only => '',
},
'legend' => {
datatype => 'Legend',
base_name => 'Legend',
description => 'Gets the chart legend.',
format => '',
read_only => '',
},
'name' => {
datatype => 'string',
base_name => 'Name',
description => 'Represents chart name.',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Object/Chart.pm view on Meta::CPAN
format => '',
read_only => '',
},
'show_data_table' => {
datatype => 'boolean',
base_name => 'ShowDataTable',
description => 'Gets or sets a value indicating whether the chart displays a data table.',
format => '',
read_only => '',
},
'show_legend' => {
datatype => 'boolean',
base_name => 'ShowLegend',
description => 'Gets or sets a value indicating whether the chart legend will be displayed. Default is true.',
format => '',
read_only => '',
},
'side_wall' => {
datatype => 'LinkElement',
base_name => 'SideWall',
description => 'Returns a object that represents the side wall of a 3-D chart.',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Object/Chart.pm view on Meta::CPAN
'depth_percent' => 'int',
'elevation' => 'int',
'first_slice_angle' => 'int',
'floor' => 'Floor',
'gap_depth' => 'int',
'gap_width' => 'int',
'height_percent' => 'int',
'hide_pivot_field_buttons' => 'boolean',
'is3_d' => 'boolean',
'is_rectangular_cornered' => 'boolean',
'legend' => 'Legend',
'name' => 'string',
'n_series' => 'SeriesItems',
'page_setup' => 'LinkElement',
'perspective' => 'int',
'pivot_source' => 'string',
'placement' => 'string',
'plot_area' => 'PlotArea',
'plot_empty_cells_type' => 'string',
'plot_visible_cells' => 'boolean',
'print_size' => 'string',
'right_angle_axes' => 'boolean',
'rotation_angle' => 'int',
'second_category_axis' => 'LinkElement',
'second_value_axis' => 'LinkElement',
'series_axis' => 'LinkElement',
'shapes' => 'LinkElement',
'show_data_table' => 'boolean',
'show_legend' => 'boolean',
'side_wall' => 'LinkElement',
'size_with_window' => 'boolean',
'style' => 'int',
'title' => 'LinkElement',
'type' => 'string',
'value_axis' => 'Axis',
'walls' => 'LinkElement',
'walls_and_gridlines2_d' => 'boolean',
'link' => 'Link'
} );
lib/AsposeCellsCloud/Object/Chart.pm view on Meta::CPAN
'depth_percent' => 'DepthPercent',
'elevation' => 'Elevation',
'first_slice_angle' => 'FirstSliceAngle',
'floor' => 'Floor',
'gap_depth' => 'GapDepth',
'gap_width' => 'GapWidth',
'height_percent' => 'HeightPercent',
'hide_pivot_field_buttons' => 'HidePivotFieldButtons',
'is3_d' => 'Is3D',
'is_rectangular_cornered' => 'IsRectangularCornered',
'legend' => 'Legend',
'name' => 'Name',
'n_series' => 'NSeries',
'page_setup' => 'PageSetup',
'perspective' => 'Perspective',
'pivot_source' => 'PivotSource',
'placement' => 'Placement',
'plot_area' => 'PlotArea',
'plot_empty_cells_type' => 'PlotEmptyCellsType',
'plot_visible_cells' => 'PlotVisibleCells',
'print_size' => 'PrintSize',
'right_angle_axes' => 'RightAngleAxes',
'rotation_angle' => 'RotationAngle',
'second_category_axis' => 'SecondCategoryAxis',
'second_value_axis' => 'SecondValueAxis',
'series_axis' => 'SeriesAxis',
'shapes' => 'Shapes',
'show_data_table' => 'ShowDataTable',
'show_legend' => 'ShowLegend',
'side_wall' => 'SideWall',
'size_with_window' => 'SizeWithWindow',
'style' => 'Style',
'title' => 'Title',
'type' => 'Type',
'value_axis' => 'ValueAxis',
'walls' => 'Walls',
'walls_and_gridlines2_d' => 'WallsAndGridlines2D',
'link' => 'link'
} );
lib/AsposeCellsCloud/Object/ChartDataTable.pm view on Meta::CPAN
format => '',
read_only => '',
},
'has_border_vertical' => {
datatype => 'boolean',
base_name => 'HasBorderVertical',
description => 'True if the chart data table has vertical cell borders',
format => '',
read_only => '',
},
'show_legend_key' => {
datatype => 'boolean',
base_name => 'ShowLegendKey',
description => 'True if the data label legend key is visible.',
format => '',
read_only => '',
},
'link' => {
datatype => 'Link',
base_name => 'link',
description => '',
format => '',
read_only => '',
},
});
__PACKAGE__->swagger_types( {
'auto_scale_font' => 'boolean',
'background_mode' => 'string',
'border' => 'Line',
'font' => 'Font',
'has_border_horizontal' => 'boolean',
'has_border_outline' => 'boolean',
'has_border_vertical' => 'boolean',
'show_legend_key' => 'boolean',
'link' => 'Link'
} );
__PACKAGE__->attribute_map( {
'auto_scale_font' => 'AutoScaleFont',
'background_mode' => 'BackgroundMode',
'border' => 'Border',
'font' => 'Font',
'has_border_horizontal' => 'HasBorderHorizontal',
'has_border_outline' => 'HasBorderOutline',
'has_border_vertical' => 'HasBorderVertical',
'show_legend_key' => 'ShowLegendKey',
'link' => 'link'
} );
__PACKAGE__->mk_accessors(keys %{__PACKAGE__->attribute_map});
1;
lib/AsposeCellsCloud/Object/DataLabels.pm view on Meta::CPAN
format => '',
read_only => '',
},
'show_category_name' => {
datatype => 'boolean',
base_name => 'ShowCategoryName',
description => 'Represents a specified chart`s data label category name display behavior.True to display the category name for the data labels on a chart. False to hide.',
format => '',
read_only => '',
},
'show_legend_key' => {
datatype => 'boolean',
base_name => 'ShowLegendKey',
description => 'Represents a specified chart`s data label legend key display behavior. True if the data label legend key is visible.',
format => '',
read_only => '',
},
'show_percentage' => {
datatype => 'boolean',
base_name => 'ShowPercentage',
description => 'Represents a specified chart`s data label percentage value display behavior. True displays the percentage value. False to hide.',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Object/DataLabels.pm view on Meta::CPAN
'is_deleted' => 'boolean',
'linked_source' => 'string',
'number' => 'int',
'number_format' => 'string',
'number_format_linked' => 'boolean',
'position' => 'string',
'rotation_angle' => 'int',
'separator' => 'string',
'show_bubble_size' => 'boolean',
'show_category_name' => 'boolean',
'show_legend_key' => 'boolean',
'show_percentage' => 'boolean',
'show_series_name' => 'boolean',
'show_value' => 'boolean',
'text' => 'string',
'text_direction' => 'string',
'text_horizontal_alignment' => 'string',
'text_vertical_alignment' => 'string',
'area' => 'Area',
'auto_scale_font' => 'boolean',
'background_mode' => 'string',
lib/AsposeCellsCloud/Object/DataLabels.pm view on Meta::CPAN
'is_deleted' => 'IsDeleted',
'linked_source' => 'LinkedSource',
'number' => 'Number',
'number_format' => 'NumberFormat',
'number_format_linked' => 'NumberFormatLinked',
'position' => 'Position',
'rotation_angle' => 'RotationAngle',
'separator' => 'Separator',
'show_bubble_size' => 'ShowBubbleSize',
'show_category_name' => 'ShowCategoryName',
'show_legend_key' => 'ShowLegendKey',
'show_percentage' => 'ShowPercentage',
'show_series_name' => 'ShowSeriesName',
'show_value' => 'ShowValue',
'text' => 'Text',
'text_direction' => 'TextDirection',
'text_horizontal_alignment' => 'TextHorizontalAlignment',
'text_vertical_alignment' => 'TextVerticalAlignment',
'area' => 'Area',
'auto_scale_font' => 'AutoScaleFont',
'background_mode' => 'BackgroundMode',
lib/AsposeCellsCloud/Object/Legend.pm view on Meta::CPAN
return DateTime->from_epoch(epoch => str2time($data));
} elsif ( grep( /^$type$/, ('int', 'double', 'string', 'boolean'))) {
return $data;
} else { # hash(model)
my $_instance = eval "AsposeCellsCloud::Object::$type->new()";
return $_instance->from_hash($data);
}
}
__PACKAGE__->class_documentation({description => 'Encapsulates the object that represents the chart legend.',
class => 'Legend',
required => [], # TODO
} );
__PACKAGE__->method_documentation({
'position' => {
datatype => 'string',
base_name => 'Position',
description => 'Gets or sets the legend position type.',
format => '',
read_only => '',
},
'legend_entries' => {
datatype => 'LinkElement',
base_name => 'LegendEntries',
description => 'Gets a collection of all the LegendEntry objects in the specified chart legend. Setting the legend entries of the surface chart is not supported. So it will return null if the chart ...
format => '',
read_only => '',
},
'area' => {
datatype => 'Area',
base_name => 'Area',
description => '',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Object/Legend.pm view on Meta::CPAN
datatype => 'int',
base_name => 'Y',
description => '',
format => '',
read_only => '',
},
});
__PACKAGE__->swagger_types( {
'position' => 'string',
'legend_entries' => 'LinkElement',
'area' => 'Area',
'auto_scale_font' => 'boolean',
'background_mode' => 'string',
'border' => 'Line',
'font' => 'Font',
'is_automatic_size' => 'boolean',
'is_inner_mode' => 'boolean',
'shadow' => 'boolean',
'width' => 'int',
'height' => 'int',
'x' => 'int',
'y' => 'int'
} );
__PACKAGE__->attribute_map( {
'position' => 'Position',
'legend_entries' => 'LegendEntries',
'area' => 'Area',
'auto_scale_font' => 'AutoScaleFont',
'background_mode' => 'BackgroundMode',
'border' => 'Border',
'font' => 'Font',
'is_automatic_size' => 'IsAutomaticSize',
'is_inner_mode' => 'IsInnerMode',
'shadow' => 'Shadow',
'width' => 'Width',
'height' => 'Height',
lib/AsposeCellsCloud/Object/LegendEntries.pm view on Meta::CPAN
}
__PACKAGE__->class_documentation({description => 'Sure, please provide me with the features you would like me to summarize in one sentence for the class summary.',
class => 'LegendEntries',
required => [], # TODO
} );
__PACKAGE__->method_documentation({
'legend_entry_list' => {
datatype => 'ARRAY[LinkElement]',
base_name => 'legendEntryList',
description => 'Property: Utilizes XML element "LengendEntry" to represent a list of LinkElement items in the class.',
format => '',
read_only => '',
},
'link' => {
datatype => 'Link',
base_name => 'link',
description => '',
format => '',
read_only => '',
},
});
__PACKAGE__->swagger_types( {
'legend_entry_list' => 'ARRAY[LinkElement]',
'link' => 'Link'
} );
__PACKAGE__->attribute_map( {
'legend_entry_list' => 'legendEntryList',
'link' => 'link'
} );
__PACKAGE__->mk_accessors(keys %{__PACKAGE__->attribute_map});
1;
lib/AsposeCellsCloud/Object/LegendEntriesResponse.pm view on Meta::CPAN
}
__PACKAGE__->class_documentation({description => 'Represents the LegendEntries Response.',
class => 'LegendEntriesResponse',
required => [], # TODO
} );
__PACKAGE__->method_documentation({
'legend_entries' => {
datatype => 'LegendEntries',
base_name => 'LegendEntries',
description => 'Property Summary: The class includes a property for managing legend entries.',
format => '',
read_only => '',
},
'code' => {
datatype => 'int',
base_name => 'Code',
description => '',
format => '',
read_only => '',
},
'status' => {
datatype => 'string',
base_name => 'Status',
description => '',
format => '',
read_only => '',
},
});
__PACKAGE__->swagger_types( {
'legend_entries' => 'LegendEntries',
'code' => 'int',
'status' => 'string'
} );
__PACKAGE__->attribute_map( {
'legend_entries' => 'LegendEntries',
'code' => 'Code',
'status' => 'Status'
} );
__PACKAGE__->mk_accessors(keys %{__PACKAGE__->attribute_map});
1;
lib/AsposeCellsCloud/Object/LegendEntry.pm view on Meta::CPAN
return DateTime->from_epoch(epoch => str2time($data));
} elsif ( grep( /^$type$/, ('int', 'double', 'string', 'boolean'))) {
return $data;
} else { # hash(model)
my $_instance = eval "AsposeCellsCloud::Object::$type->new()";
return $_instance->from_hash($data);
}
}
__PACKAGE__->class_documentation({description => 'Represents a legend entry in a chart legend.',
class => 'LegendEntry',
required => [], # TODO
} );
__PACKAGE__->method_documentation({
'auto_scale_font' => {
datatype => 'boolean',
base_name => 'AutoScaleFont',
description => 'True if the text in the object changes font size when the object size changes. The default value is True.',
lib/AsposeCellsCloud/Object/LegendEntry.pm view on Meta::CPAN
'font' => {
datatype => 'Font',
base_name => 'Font',
description => 'Gets a object of the specified ChartFrame object.',
format => '',
read_only => '',
},
'is_deleted' => {
datatype => 'boolean',
base_name => 'IsDeleted',
description => 'Gets and sets whether the legend entry is deleted.',
format => '',
read_only => '',
},
'link' => {
datatype => 'Link',
base_name => 'link',
description => '',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Object/LegendEntryResponse.pm view on Meta::CPAN
}
__PACKAGE__->class_documentation({description => 'Represents the LegendEntry Response.',
class => 'LegendEntryResponse',
required => [], # TODO
} );
__PACKAGE__->method_documentation({
'legend_entry' => {
datatype => 'LegendEntry',
base_name => 'LegendEntry',
description => 'A public property called LegendEntry of type LegendEntry with both getter and setter methods.',
format => '',
read_only => '',
},
'code' => {
datatype => 'int',
base_name => 'Code',
description => '',
lib/AsposeCellsCloud/Object/LegendEntryResponse.pm view on Meta::CPAN
'status' => {
datatype => 'string',
base_name => 'Status',
description => '',
format => '',
read_only => '',
},
});
__PACKAGE__->swagger_types( {
'legend_entry' => 'LegendEntry',
'code' => 'int',
'status' => 'string'
} );
__PACKAGE__->attribute_map( {
'legend_entry' => 'LegendEntry',
'code' => 'Code',
'status' => 'Status'
} );
__PACKAGE__->mk_accessors(keys %{__PACKAGE__->attribute_map});
1;
lib/AsposeCellsCloud/Object/LegendResponse.pm view on Meta::CPAN
}
__PACKAGE__->class_documentation({description => 'Represents the Legend Response.',
class => 'LegendResponse',
required => [], # TODO
} );
__PACKAGE__->method_documentation({
'legend' => {
datatype => 'Legend',
base_name => 'Legend',
description => 'This class has a public property called "Legend" of type "Legend" which has both a getter and a setter.',
format => '',
read_only => '',
},
'code' => {
datatype => 'int',
base_name => 'Code',
description => '',
lib/AsposeCellsCloud/Object/LegendResponse.pm view on Meta::CPAN
'status' => {
datatype => 'string',
base_name => 'Status',
description => '',
format => '',
read_only => '',
},
});
__PACKAGE__->swagger_types( {
'legend' => 'Legend',
'code' => 'int',
'status' => 'string'
} );
__PACKAGE__->attribute_map( {
'legend' => 'Legend',
'code' => 'Code',
'status' => 'Status'
} );
__PACKAGE__->mk_accessors(keys %{__PACKAGE__->attribute_map});
1;
lib/AsposeCellsCloud/Object/Series.pm view on Meta::CPAN
format => '',
read_only => '',
},
'leader_lines' => {
datatype => 'Line',
base_name => 'LeaderLines',
description => 'Represents leader lines on a chart. Leader lines connect data labels to data points. This object isn’t a collection; there’s no object that represents a single leader line.',
format => '',
read_only => '',
},
'legend_entry' => {
datatype => 'LegendEntry',
base_name => 'LegendEntry',
description => 'Gets the legend entry according to this series.',
format => '',
read_only => '',
},
'marker' => {
datatype => 'Marker',
base_name => 'Marker',
description => 'Gets the marker.',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Object/Series.pm view on Meta::CPAN
'has_drop_lines' => 'boolean',
'has_hi_lo_lines' => 'boolean',
'has_leader_lines' => 'boolean',
'has_radar_axis_labels' => 'boolean',
'has_series_lines' => 'boolean',
'has_up_down_bars' => 'boolean',
'hi_lo_lines' => 'Line',
'is_auto_split' => 'boolean',
'is_color_varied' => 'boolean',
'leader_lines' => 'Line',
'legend_entry' => 'LegendEntry',
'marker' => 'Marker',
'name' => 'string',
'overlap' => 'int',
'plot_on_second_axis' => 'boolean',
'points' => 'LinkElement',
'second_plot_size' => 'int',
'series_lines' => 'Line',
'shadow' => 'boolean',
'show_negative_bubbles' => 'boolean',
'size_represents' => 'string',
lib/AsposeCellsCloud/Object/Series.pm view on Meta::CPAN
'has_drop_lines' => 'HasDropLines',
'has_hi_lo_lines' => 'HasHiLoLines',
'has_leader_lines' => 'HasLeaderLines',
'has_radar_axis_labels' => 'HasRadarAxisLabels',
'has_series_lines' => 'HasSeriesLines',
'has_up_down_bars' => 'HasUpDownBars',
'hi_lo_lines' => 'HiLoLines',
'is_auto_split' => 'IsAutoSplit',
'is_color_varied' => 'IsColorVaried',
'leader_lines' => 'LeaderLines',
'legend_entry' => 'LegendEntry',
'marker' => 'Marker',
'name' => 'Name',
'overlap' => 'Overlap',
'plot_on_second_axis' => 'PlotOnSecondAxis',
'points' => 'Points',
'second_plot_size' => 'SecondPlotSize',
'series_lines' => 'SeriesLines',
'shadow' => 'Shadow',
'show_negative_bubbles' => 'ShowNegativeBubbles',
'size_represents' => 'SizeRepresents',
lib/AsposeCellsCloud/Object/Trendline.pm view on Meta::CPAN
format => '',
read_only => '',
},
'is_name_auto' => {
datatype => 'boolean',
base_name => 'IsNameAuto',
description => 'Returns if Microsoft Excel automatically determines the name of the trendline.',
format => '',
read_only => '',
},
'legend_entry' => {
datatype => 'LegendEntry',
base_name => 'LegendEntry',
description => 'Gets the legend entry according to this trendline',
format => '',
read_only => '',
},
'name' => {
datatype => 'string',
base_name => 'Name',
description => 'Returns the name of the trendline.',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Object/Trendline.pm view on Meta::CPAN
__PACKAGE__->swagger_types( {
'link' => 'Link',
'backward' => 'double',
'data_labels' => 'DataLabels',
'display_equation' => 'boolean',
'display_r_squared' => 'boolean',
'forward' => 'double',
'intercept' => 'double',
'is_name_auto' => 'boolean',
'legend_entry' => 'LegendEntry',
'name' => 'string',
'order' => 'int',
'period' => 'int',
'type' => 'string',
'begin_arrow_length' => 'string',
'begin_arrow_width' => 'string',
'begin_type' => 'string',
'cap_type' => 'string',
'color' => 'Color',
'compound_type' => 'string',
lib/AsposeCellsCloud/Object/Trendline.pm view on Meta::CPAN
__PACKAGE__->attribute_map( {
'link' => 'link',
'backward' => 'Backward',
'data_labels' => 'DataLabels',
'display_equation' => 'DisplayEquation',
'display_r_squared' => 'DisplayRSquared',
'forward' => 'Forward',
'intercept' => 'Intercept',
'is_name_auto' => 'IsNameAuto',
'legend_entry' => 'LegendEntry',
'name' => 'Name',
'order' => 'Order',
'period' => 'Period',
'type' => 'Type',
'begin_arrow_length' => 'BeginArrowLength',
'begin_arrow_width' => 'BeginArrowWidth',
'begin_type' => 'BeginType',
'cap_type' => 'CapType',
'color' => 'Color',
'compound_type' => 'CompoundType',
lib/AsposeCellsCloud/Request/DeleteWorksheetChartLegendRequest.pm view on Meta::CPAN
# DeleteWorksheetChartLegendRequest.storageName : The storage name where the file is situated.
{
my $params = {
'client' =>{
data_type => 'ApiClient',
description => 'API Client.',
required => '0',
}
};
__PACKAGE__->method_documentation->{ 'delete_worksheet_chart_legend' } = {
summary => 'Hides chart legend in the worksheet.',
params => $params,
returns => 'CellsCloudResponse',
};
}
sub run_http_request {
my ($self, %args) = @_;
my $client = $args{'client'};
# parse inputs
my $_resource_path = '/cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/legend';
my $_method = 'DELETE';
my $query_params = {};
my $header_params = {};
my $form_params = {};
my $_header_accept = $client->select_header_accept('application/json');
if ($_header_accept) {
$header_params->{'Accept'} = $_header_accept;
lib/AsposeCellsCloud/Request/GetWorksheetChartLegendRequest.pm view on Meta::CPAN
# GetWorksheetChartLegendRequest.storageName : The storage name where the file is situated.
{
my $params = {
'client' =>{
data_type => 'ApiClient',
description => 'API Client.',
required => '0',
}
};
__PACKAGE__->method_documentation->{ 'get_worksheet_chart_legend' } = {
summary => 'Retrieve chart legend description in the worksheet.',
params => $params,
returns => 'LegendResponse',
};
}
sub run_http_request {
my ($self, %args) = @_;
my $client = $args{'client'};
# parse inputs
my $_resource_path = '/cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/legend';
my $_method = 'GET';
my $query_params = {};
my $header_params = {};
my $form_params = {};
my $_header_accept = $client->select_header_accept('application/json');
if ($_header_accept) {
$header_params->{'Accept'} = $_header_accept;
lib/AsposeCellsCloud/Request/PostWorksheetChartLegendRequest.pm view on Meta::CPAN
}
return $self;
}
# Run Operation Request
# PostWorksheetChartLegendRequest.name : The file name. ,
# PostWorksheetChartLegendRequest.sheetName : The worksheet name. ,
# PostWorksheetChartLegendRequest.chartIndex : The chart index. ,
# PostWorksheetChartLegendRequest.legend : ,
# PostWorksheetChartLegendRequest.folder : The folder where the file is situated. ,
# PostWorksheetChartLegendRequest.storageName : The storage name where the file is situated.
{
my $params = {
'client' =>{
data_type => 'ApiClient',
description => 'API Client.',
required => '0',
}
};
__PACKAGE__->method_documentation->{ 'post_worksheet_chart_legend' } = {
summary => 'Update chart legend in the worksheet.',
params => $params,
returns => 'CellsCloudResponse',
};
}
sub run_http_request {
my ($self, %args) = @_;
my $client = $args{'client'};
# parse inputs
my $_resource_path = '/cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/legend';
my $_method = 'POST';
my $query_params = {};
my $header_params = {};
my $form_params = {};
my $_header_accept = $client->select_header_accept('application/json');
if ($_header_accept) {
$header_params->{'Accept'} = $_header_accept;
lib/AsposeCellsCloud/Request/PostWorksheetChartLegendRequest.pm view on Meta::CPAN
if(defined $self->folder){
$query_params->{'folder'} = $client->to_query_value($self->folder);
}
if(defined $self->storage_name){
$query_params->{'storageName'} = $client->to_query_value($self->storage_name);
}
my $_body_data;
# body params
if (defined $self->legend) {
#$_body_data = $self->legend;
$_body_data = JSON->new->convert_blessed->encode( $self->legend);
}
# authentication setting, if any
my $auth_settings = [qw()];
# make the API Call
my $response = $client->call_api($_resource_path, $_method, $query_params, $form_params, $header_params, $_body_data, $auth_settings);
return $response;
}
lib/AsposeCellsCloud/Request/PostWorksheetChartLegendRequest.pm view on Meta::CPAN
format => '',
read_only => '',
},
'chart_index' => {
datatype => 'int',
base_name => 'chartIndex',
description => 'The chart index.',
format => '',
read_only => '',
},
'legend' => {
datatype => 'Legend',
base_name => 'legend',
description => '',
format => '',
read_only => '',
},
'folder' => {
datatype => 'string',
base_name => 'folder',
description => 'The folder where the file is situated.',
format => '',
read_only => '',
lib/AsposeCellsCloud/Request/PostWorksheetChartLegendRequest.pm view on Meta::CPAN
format => '',
read_only => '',
},
});
__PACKAGE__->attribute_map( {
'name' => 'name',
'sheet_name' => 'sheetName',
'chart_index' => 'chartIndex',
'legend' => 'legend',
'folder' => 'folder',
'storage_name' => 'storageName'
} );
__PACKAGE__->mk_accessors(keys %{__PACKAGE__->attribute_map});
1;
lib/AsposeCellsCloud/Request/PutWorksheetChartLegendRequest.pm view on Meta::CPAN
# PutWorksheetChartLegendRequest.storageName : The storage name where the file is situated.
{
my $params = {
'client' =>{
data_type => 'ApiClient',
description => 'API Client.',
required => '0',
}
};
__PACKAGE__->method_documentation->{ 'put_worksheet_chart_legend' } = {
summary => 'Show chart legend in the worksheet.',
params => $params,
returns => 'CellsCloudResponse',
};
}
sub run_http_request {
my ($self, %args) = @_;
my $client = $args{'client'};
# parse inputs
my $_resource_path = '/cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/legend';
my $_method = 'PUT';
my $query_params = {};
my $header_params = {};
my $form_params = {};
my $_header_accept = $client->select_header_accept('application/json');
if ($_header_accept) {
$header_params->{'Accept'} = $_header_accept;
( run in 1.502 second using v1.01-cache-2.11-cpan-49f99fa48dc )