AsposeCellsCloud-CellsApi
view release on metacpan or search on metacpan
lib/AsposeCellsCloud/CellsApi.pm view on Meta::CPAN
#
# PutWorksheetFilterTop10Request
#
# Filter the top 10 items in the list in the worksheet.
#
# @name string (required) The workbook name.
# @sheetName string (required) The worksheet name.
# @range string (required) Represents the range to which the specified AutoFilter applies.
# @fieldIndex int (required) The integer offset of the field on which you want to base the filter (from the left of the list; the leftmost field is field 0).
# @isTop boolean (required) Indicates whether filter from top or bottom
# @isPercent boolean (required) Indicates whether the items is percent or count
# @itemCount int (required) The item count
# @matchBlanks boolean Match all blank cell in the list.
# @refresh boolean Refresh auto filters to hide or unhide the rows.
# @folder string The folder where the file is situated.
# @storageName string The storage name where the file is situated.
#
{
my $params = {
'request' =>{
data_type => 'PutWorksheetFilterTop10Request',
lib/AsposeCellsCloud/CellsApi.pm view on Meta::CPAN
if (!$response) {
return;
}
my $_response_object = $self->{api_client}->deserialize('RangeValueResponse', $response);
return $_response_object;
}
#
# PostUpdateWorksheetZoomRequest
#
# Update the scaling percentage in the worksheet. It should be between 10 and 400.
#
# @name string (required) The file name.
# @sheetName string (required) The worksheet name.
# @value int (required) Represents the scaling factor in percentage. It should be between 10 and 400.
# @folder string The folder where the file is situated.
# @storageName string The storage name where the file is situated.
#
{
my $params = {
'request' =>{
data_type => 'PostUpdateWorksheetZoomRequest',
description => 'PostUpdateWorksheetZoom Request.',
required => '0',
}
};
__PACKAGE__->method_documentation->{ 'post_update_worksheet_zoom' } = {
summary => 'Update the scaling percentage in the worksheet. It should be between 10 and 400.',
params => $params,
returns => 'CellsCloudResponse',
};
}
#
# @return CellsCloudResponse
#
sub post_update_worksheet_zoom{
my ($self, %args) = @_;
my $request = $args{'request'};
lib/AsposeCellsCloud/Object/Chart.pm view on Meta::CPAN
format => '',
read_only => '',
},
'chart_object' => {
datatype => 'LinkElement',
base_name => 'ChartObject',
description => 'Represents the chartShape;',
format => '',
read_only => '',
},
'depth_percent' => {
datatype => 'int',
base_name => 'DepthPercent',
description => 'Represents the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).',
format => '',
read_only => '',
},
'elevation' => {
datatype => 'int',
base_name => 'Elevation',
description => 'Represents the elevation of the 3-D chart view, in degrees.',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Object/Chart.pm view on Meta::CPAN
'floor' => {
datatype => 'Floor',
base_name => 'Floor',
description => 'Returns a object that represents the walls of a 3-D chart.',
format => '',
read_only => '',
},
'gap_depth' => {
datatype => 'int',
base_name => 'GapDepth',
description => '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.',
format => '',
read_only => '',
},
'gap_width' => {
datatype => 'int',
base_name => 'GapWidth',
description => '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.',
format => '',
read_only => '',
},
'height_percent' => {
datatype => 'int',
base_name => 'HeightPercent',
description => 'Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).',
format => '',
read_only => '',
},
'hide_pivot_field_buttons' => {
datatype => 'boolean',
base_name => 'HidePivotFieldButtons',
description => 'Indicates whether hide the pivot chart field buttons only when the chart is PivotChart.',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Object/Chart.pm view on Meta::CPAN
},
});
__PACKAGE__->swagger_types( {
'auto_scaling' => 'boolean',
'back_wall' => 'Walls',
'category_axis' => 'Axis',
'chart_area' => 'ChartArea',
'chart_data_table' => 'ChartDataTable',
'chart_object' => 'LinkElement',
'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',
lib/AsposeCellsCloud/Object/Chart.pm view on Meta::CPAN
'link' => 'Link'
} );
__PACKAGE__->attribute_map( {
'auto_scaling' => 'AutoScaling',
'back_wall' => 'BackWall',
'category_axis' => 'CategoryAxis',
'chart_area' => 'ChartArea',
'chart_data_table' => 'ChartDataTable',
'chart_object' => 'ChartObject',
'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',
lib/AsposeCellsCloud/Object/ChartPoint.pm view on Meta::CPAN
'data_labels' => {
datatype => 'DataLabels',
base_name => 'DataLabels',
description => 'Returns a DataLabels object that represents the data label associated with the point.',
format => '',
read_only => '',
},
'explosion' => {
datatype => 'int',
base_name => 'Explosion',
description => 'The distance of an open pie slice from the center of the pie chart is expressed as a percentage of the pie diameter.',
format => '',
read_only => '',
},
'marker' => {
datatype => 'Marker',
base_name => 'Marker',
description => 'Gets the marker.',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Object/DataLabels.pm view on Meta::CPAN
'separator' => {
datatype => 'string',
base_name => 'Separator',
description => 'Gets or sets the separator type used for the data labels on a chart.',
format => '',
read_only => '',
},
'show_bubble_size' => {
datatype => 'boolean',
base_name => 'ShowBubbleSize',
description => 'Represents a specified chart`s data label percentage value display behavior. True displays the percentage value. False to hide.',
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 => '',
},
'show_series_name' => {
datatype => 'boolean',
base_name => 'ShowSeriesName',
description => '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.',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Object/DataLabels.pm view on Meta::CPAN
'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',
'border' => 'Line',
lib/AsposeCellsCloud/Object/DataLabels.pm view on Meta::CPAN
'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',
'border' => 'Border',
lib/AsposeCellsCloud/Object/PageSetup.pm view on Meta::CPAN
format => '',
read_only => '',
},
'is_hf_scale_with_doc' => {
datatype => 'boolean',
base_name => 'IsHFScaleWithDoc',
description => 'Indicates whether header and footer are scaled with document scaling. Only applies for Excel 2007. ',
format => '',
read_only => '',
},
'is_percent_scale' => {
datatype => 'boolean',
base_name => 'IsPercentScale',
description => 'If this property is False, the FitToPagesWide and FitToPagesTall properties control how the worksheet is scaled. ',
format => '',
read_only => '',
},
'left_margin' => {
datatype => 'double',
base_name => 'LeftMargin',
description => 'Represents the size of the left margin, in unit of centimeters. ',
lib/AsposeCellsCloud/Object/PageSetup.pm view on Meta::CPAN
'top_margin' => {
datatype => 'double',
base_name => 'TopMargin',
description => 'Represents the size of the top margin, in unit of centimeters. ',
format => '',
read_only => '',
},
'zoom' => {
datatype => 'int',
base_name => 'Zoom',
description => 'Represents the scaling factor in percent. It should be between 10 and 400. ',
format => '',
read_only => '',
},
'header' => {
datatype => 'ARRAY[PageSection]',
base_name => 'Header',
description => 'Represents the page header.',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Object/PageSetup.pm view on Meta::CPAN
'first_page_number' => 'int',
'fit_to_pages_tall' => 'int',
'fit_to_pages_wide' => 'int',
'footer_margin' => 'double',
'header_margin' => 'double',
'is_auto_first_page_number' => 'boolean',
'is_hf_align_margins' => 'boolean',
'is_hf_diff_first' => 'boolean',
'is_hf_diff_odd_even' => 'boolean',
'is_hf_scale_with_doc' => 'boolean',
'is_percent_scale' => 'boolean',
'left_margin' => 'double',
'order' => 'string',
'orientation' => 'string',
'paper_size' => 'string',
'print_area' => 'string',
'print_comments' => 'string',
'print_copies' => 'int',
'print_draft' => 'boolean',
'print_errors' => 'string',
'print_gridlines' => 'boolean',
lib/AsposeCellsCloud/Object/PageSetup.pm view on Meta::CPAN
'first_page_number' => 'FirstPageNumber',
'fit_to_pages_tall' => 'FitToPagesTall',
'fit_to_pages_wide' => 'FitToPagesWide',
'footer_margin' => 'FooterMargin',
'header_margin' => 'HeaderMargin',
'is_auto_first_page_number' => 'IsAutoFirstPageNumber',
'is_hf_align_margins' => 'IsHFAlignMargins',
'is_hf_diff_first' => 'IsHFDiffFirst',
'is_hf_diff_odd_even' => 'IsHFDiffOddEven',
'is_hf_scale_with_doc' => 'IsHFScaleWithDoc',
'is_percent_scale' => 'IsPercentScale',
'left_margin' => 'LeftMargin',
'order' => 'Order',
'orientation' => 'Orientation',
'paper_size' => 'PaperSize',
'print_area' => 'PrintArea',
'print_comments' => 'PrintComments',
'print_copies' => 'PrintCopies',
'print_draft' => 'PrintDraft',
'print_errors' => 'PrintErrors',
'print_gridlines' => 'PrintGridlines',
lib/AsposeCellsCloud/Object/RenderingWatermark.pm view on Meta::CPAN
__PACKAGE__->method_documentation({
'rotation' => {
datatype => 'double',
base_name => 'Rotation',
description => '',
format => '',
read_only => '',
},
'scale_to_page_percent' => {
datatype => 'int',
base_name => 'ScaleToPagePercent',
description => '',
format => '',
read_only => '',
},
'opacity' => {
datatype => 'double',
base_name => 'Opacity',
description => '',
lib/AsposeCellsCloud/Object/RenderingWatermark.pm view on Meta::CPAN
datatype => 'double',
base_name => 'OffsetY',
description => '',
format => '',
read_only => '',
},
});
__PACKAGE__->swagger_types( {
'rotation' => 'double',
'scale_to_page_percent' => 'int',
'opacity' => 'double',
'is_background' => 'boolean',
'text' => 'string',
'font' => 'RenderingFont',
'image' => 'ARRAY[byte?]',
'h_alignment' => 'string',
'v_alignment' => 'string',
'offset_x' => 'double',
'offset_y' => 'double'
} );
__PACKAGE__->attribute_map( {
'rotation' => 'Rotation',
'scale_to_page_percent' => 'ScaleToPagePercent',
'opacity' => 'Opacity',
'is_background' => 'IsBackground',
'text' => 'Text',
'font' => 'Font',
'image' => 'Image',
'h_alignment' => 'HAlignment',
'v_alignment' => 'VAlignment',
'offset_x' => 'OffsetX',
'offset_y' => 'OffsetY'
} );
lib/AsposeCellsCloud/Object/Series.pm view on Meta::CPAN
'border' => {
datatype => 'Line',
base_name => 'Border',
description => 'Represents border of Series object.',
format => '',
read_only => '',
},
'bubble_scale' => {
datatype => 'int',
base_name => 'BubbleScale',
description => 'Gets or sets the scale factor for bubbles in the specified chart group. It can be an integer value from 0 (zero) to 300, corresponding to a percentage of the default size. ...
format => '',
read_only => '',
},
'bubble_sizes' => {
datatype => 'string',
base_name => 'BubbleSizes',
description => 'Gets or sets the bubble sizes values of the chart series.',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Object/Series.pm view on Meta::CPAN
'display_name' => {
datatype => 'string',
base_name => 'DisplayName',
description => 'Gets the series`s name that displays on the chart graph.',
format => '',
read_only => '',
},
'doughnut_hole_size' => {
datatype => 'int',
base_name => 'DoughnutHoleSize',
description => 'Returns or sets the size of the hole in a doughnut chart group. The hole size is expressed as a percentage of the chart size, between 10 and 90 percent.',
format => '',
read_only => '',
},
'down_bars' => {
datatype => 'DropBars',
base_name => 'DownBars',
description => 'Returns a object that represents the down bars on a line chart. Applies only to line charts.',
format => '',
read_only => '',
},
'drop_lines' => {
datatype => 'Line',
base_name => 'DropLines',
description => 'Returns a object that represents the drop lines for a series on the line chart or area chart. Applies only to line chart or area charts.',
format => '',
read_only => '',
},
'explosion' => {
datatype => 'int',
base_name => 'Explosion',
description => 'The distance of an open pie slice from the center of the pie chart is expressed as a percentage of the pie diameter.',
format => '',
read_only => '',
},
'first_slice_angle' => {
datatype => 'int',
base_name => 'FirstSliceAngle',
description => '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.',
format => '',
read_only => '',
},
'gap_width' => {
datatype => 'int',
base_name => 'GapWidth',
description => '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.',
format => '',
read_only => '',
},
'has3_d_effect' => {
datatype => 'boolean',
base_name => 'Has3DEffect',
description => 'True if the series has a three-dimensional appearance. Applies only to bubble charts.',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Object/Series.pm view on Meta::CPAN
'points' => {
datatype => 'LinkElement',
base_name => 'Points',
description => 'Gets the collection of points in a series in a chart.',
format => '',
read_only => '',
},
'second_plot_size' => {
datatype => 'int',
base_name => 'SecondPlotSize',
description => '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 to 200.',...
format => '',
read_only => '',
},
'series_lines' => {
datatype => 'Line',
base_name => 'SeriesLines',
description => '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.',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Object/Style.pm view on Meta::CPAN
format => '',
read_only => '',
},
'is_locked' => {
datatype => 'boolean',
base_name => 'IsLocked',
description => 'Gets or sets a value indicating whether a cell can be modified or not. ',
format => '',
read_only => '',
},
'is_percent' => {
datatype => 'boolean',
base_name => 'IsPercent',
description => 'Indicates whether the number format is a percent format. ',
format => '',
read_only => '',
},
'shrink_to_fit' => {
datatype => 'boolean',
base_name => 'ShrinkToFit',
description => 'Represents if text automatically shrinks to fit in the available column width. ',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Object/Style.pm view on Meta::CPAN
'name' => 'string',
'culture_custom' => 'string',
'custom' => 'string',
'background_color' => 'Color',
'foreground_color' => 'Color',
'is_formula_hidden' => 'boolean',
'is_date_time' => 'boolean',
'is_text_wrapped' => 'boolean',
'is_gradient' => 'boolean',
'is_locked' => 'boolean',
'is_percent' => 'boolean',
'shrink_to_fit' => 'boolean',
'indent_level' => 'int',
'number' => 'int',
'rotation_angle' => 'int',
'pattern' => 'string',
'text_direction' => 'string',
'vertical_alignment' => 'string',
'horizontal_alignment' => 'string',
'border_collection' => 'ARRAY[Border]',
'background_theme_color' => 'ThemeColor',
lib/AsposeCellsCloud/Object/Style.pm view on Meta::CPAN
'name' => 'Name',
'culture_custom' => 'CultureCustom',
'custom' => 'Custom',
'background_color' => 'BackgroundColor',
'foreground_color' => 'ForegroundColor',
'is_formula_hidden' => 'IsFormulaHidden',
'is_date_time' => 'IsDateTime',
'is_text_wrapped' => 'IsTextWrapped',
'is_gradient' => 'IsGradient',
'is_locked' => 'IsLocked',
'is_percent' => 'IsPercent',
'shrink_to_fit' => 'ShrinkToFit',
'indent_level' => 'IndentLevel',
'number' => 'Number',
'rotation_angle' => 'RotationAngle',
'pattern' => 'Pattern',
'text_direction' => 'TextDirection',
'vertical_alignment' => 'VerticalAlignment',
'horizontal_alignment' => 'HorizontalAlignment',
'border_collection' => 'BorderCollection',
'background_theme_color' => 'BackgroundThemeColor',
lib/AsposeCellsCloud/Object/Top10.pm view on Meta::CPAN
__PACKAGE__->method_documentation({
'is_bottom' => {
datatype => 'boolean',
base_name => 'IsBottom',
description => 'Get or set whether a "top/bottom n" rule is a "bottom n" rule. Default value is false. ',
format => '',
read_only => '',
},
'is_percent' => {
datatype => 'boolean',
base_name => 'IsPercent',
description => 'Get or set whether a "top/bottom n" rule is a "top/bottom n percent" rule. Default value is false. ',
format => '',
read_only => '',
},
'rank' => {
datatype => 'int',
base_name => 'Rank',
description => 'Get or set the value of "n" in a "top/bottom n" conditional formatting rule. If IsPercent is true, the value must between 0 and 100. Otherwise it must between 0 and 1000. Default value is 10. ',
format => '',
read_only => '',
},
});
__PACKAGE__->swagger_types( {
'is_bottom' => 'boolean',
'is_percent' => 'boolean',
'rank' => 'int'
} );
__PACKAGE__->attribute_map( {
'is_bottom' => 'IsBottom',
'is_percent' => 'IsPercent',
'rank' => 'Rank'
} );
__PACKAGE__->mk_accessors(keys %{__PACKAGE__->attribute_map});
1;
lib/AsposeCellsCloud/Object/Top10Filter.pm view on Meta::CPAN
format => '',
read_only => '',
},
'criteria' => {
datatype => 'string',
base_name => 'Criteria',
description => ' ',
format => '',
read_only => '',
},
'is_percent' => {
datatype => 'boolean',
base_name => 'IsPercent',
description => 'Indicates whether the items is percent. ',
format => '',
read_only => '',
},
'is_top' => {
datatype => 'boolean',
base_name => 'IsTop',
description => 'Indicates whether it`s top filter. ',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Object/Top10Filter.pm view on Meta::CPAN
base_name => 'Items',
description => 'Gets and sets the items of the filter. ',
format => '',
read_only => '',
},
});
__PACKAGE__->swagger_types( {
'field_index' => 'int',
'criteria' => 'string',
'is_percent' => 'boolean',
'is_top' => 'boolean',
'items' => 'int'
} );
__PACKAGE__->attribute_map( {
'field_index' => 'FieldIndex',
'criteria' => 'Criteria',
'is_percent' => 'IsPercent',
'is_top' => 'IsTop',
'items' => 'Items'
} );
__PACKAGE__->mk_accessors(keys %{__PACKAGE__->attribute_map});
1;
lib/AsposeCellsCloud/Object/Worksheet.pm view on Meta::CPAN
'visibility_type' => {
datatype => 'string',
base_name => 'VisibilityType',
description => 'Indicates the visible state for this sheet. ',
format => '',
read_only => '',
},
'zoom' => {
datatype => 'int',
base_name => 'Zoom',
description => 'Represents the scaling factor in percentage. It should be between 10 and 400. ',
format => '',
read_only => '',
},
'cells' => {
datatype => 'LinkElement',
base_name => 'Cells',
description => 'Gets the collection. ',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Request/PostUpdateWorksheetZoomRequest.pm view on Meta::CPAN
$self->$attribute( $args{ $args_key } );
}
return $self;
}
# Run Operation Request
# PostUpdateWorksheetZoomRequest.name : The file name. ,
# PostUpdateWorksheetZoomRequest.sheetName : The worksheet name. ,
# PostUpdateWorksheetZoomRequest.value : Represents the scaling factor in percentage. It should be between 10 and 400. ,
# PostUpdateWorksheetZoomRequest.folder : The folder where the file is situated. ,
# PostUpdateWorksheetZoomRequest.storageName : The storage name where the file is situated.
{
my $params = {
'client' =>{
data_type => 'ApiClient',
description => 'API Client.',
required => '0',
}
};
__PACKAGE__->method_documentation->{ 'post_update_worksheet_zoom' } = {
summary => 'Update the scaling percentage in the worksheet. It should be between 10 and 400.',
params => $params,
returns => 'CellsCloudResponse',
};
}
sub run_http_request {
my ($self, %args) = @_;
my $client = $args{'client'};
lib/AsposeCellsCloud/Request/PostUpdateWorksheetZoomRequest.pm view on Meta::CPAN
'sheet_name' => {
datatype => 'string',
base_name => 'sheetName',
description => 'The worksheet name.',
format => '',
read_only => '',
},
'value' => {
datatype => 'int',
base_name => 'value',
description => 'Represents the scaling factor in percentage. It should be between 10 and 400.',
format => '',
read_only => '',
},
'folder' => {
datatype => 'string',
base_name => 'folder',
description => 'The folder where the file is situated.',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Request/PutWorksheetFilterTop10Request.pm view on Meta::CPAN
return $self;
}
# Run Operation Request
# PutWorksheetFilterTop10Request.name : The workbook name. ,
# PutWorksheetFilterTop10Request.sheetName : The worksheet name. ,
# PutWorksheetFilterTop10Request.range : Represents the range to which the specified AutoFilter applies. ,
# PutWorksheetFilterTop10Request.fieldIndex : The integer offset of the field on which you want to base the filter (from the left of the list; the leftmost field is field 0). ,
# PutWorksheetFilterTop10Request.isTop : Indicates whether filter from top or bottom ,
# PutWorksheetFilterTop10Request.isPercent : Indicates whether the items is percent or count ,
# PutWorksheetFilterTop10Request.itemCount : The item count ,
# PutWorksheetFilterTop10Request.matchBlanks : Match all blank cell in the list. ,
# PutWorksheetFilterTop10Request.refresh : Refresh auto filters to hide or unhide the rows. ,
# PutWorksheetFilterTop10Request.folder : The folder where the file is situated. ,
# PutWorksheetFilterTop10Request.storageName : The storage name where the file is situated.
{
my $params = {
'client' =>{
data_type => 'ApiClient',
lib/AsposeCellsCloud/Request/PutWorksheetFilterTop10Request.pm view on Meta::CPAN
}
if(defined $self->field_index){
$query_params->{'fieldIndex'} = $client->to_query_value($self->field_index);
}
if(defined $self->is_top){
$query_params->{'isTop'} = $client->to_query_value($self->is_top);
}
if(defined $self->is_percent){
$query_params->{'isPercent'} = $client->to_query_value($self->is_percent);
}
if(defined $self->item_count){
$query_params->{'itemCount'} = $client->to_query_value($self->item_count);
}
if(defined $self->match_blanks){
$query_params->{'matchBlanks'} = $client->to_query_value($self->match_blanks);
}
lib/AsposeCellsCloud/Request/PutWorksheetFilterTop10Request.pm view on Meta::CPAN
format => '',
read_only => '',
},
'is_top' => {
datatype => 'string',
base_name => 'isTop',
description => 'Indicates whether filter from top or bottom',
format => '',
read_only => '',
},
'is_percent' => {
datatype => 'string',
base_name => 'isPercent',
description => 'Indicates whether the items is percent or count',
format => '',
read_only => '',
},
'item_count' => {
datatype => 'int',
base_name => 'itemCount',
description => 'The item count',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Request/PutWorksheetFilterTop10Request.pm view on Meta::CPAN
},
});
__PACKAGE__->attribute_map( {
'name' => 'name',
'sheet_name' => 'sheetName',
'range' => 'range',
'field_index' => 'fieldIndex',
'is_top' => 'isTop',
'is_percent' => 'isPercent',
'item_count' => 'itemCount',
'match_blanks' => 'matchBlanks',
'refresh' => 'refresh',
'folder' => 'folder',
'storage_name' => 'storageName'
} );
__PACKAGE__->mk_accessors(keys %{__PACKAGE__->attribute_map});
( run in 0.433 second using v1.01-cache-2.11-cpan-05162d3a2b1 )