/ 
AsposeCellsCloud-CellsApi-19.2.1
River stage zero No dependents
/ README.md

NAME

AsposeCellsCloud::Role - a Moose role for the Web API Swagger specification

No description provided (generated by Swagger Codegen https://github.com/swagger-api/swagger-codegen)

VERSION

Automatically generated by the Swagger Codegen project:

A note on Moose

This role is the only component of the library that uses Moose. See AsposeCellsCloud::ApiFactory for non-Moosey usage.

SYNOPSIS

The Perl Swagger Codegen project builds a library of Perl modules to interact with a web service defined by a OpenAPI Specification. See below for how to build the library.

This module provides an interface to the generated library. All the classes, objects, and methods (well, not quite *all*, see below) are flattened into this role.

    package MyApp;
    use Moose;
    with 'AsposeCellsCloud::Role';

    package main;

    my $api = MyApp->new({ tokens => $tokens });

    my $pet = $api->get_pet_by_id(pet_id => $pet_id);

Structure of the library

The library consists of a set of API classes, one for each endpoint. These APIs implement the method calls available on each endpoint.

Additionally, there is a set of "object" classes, which represent the objects returned by and sent to the methods on the endpoints.

An API factory class is provided, which builds instances of each endpoint API.

This Moose role flattens all the methods from the endpoint APIs onto the consuming class. It also provides methods to retrieve the endpoint API objects, and the API factory object, should you need it.

For documentation of all these methods, see AUTOMATIC DOCUMENTATION below.

Configuring authentication

In the normal case, the OpenAPI Spec will describe what parameters are required and where to put them. You just need to supply the tokens.

my $tokens = {
    # basic
    username => $username,
    password => $password,

    # oauth
    access_token => $oauth_token,

    # keys
    $some_key => { token => $token,
                   prefix => $prefix,
                   in => $in,             # 'head||query',
                   },

    $another => { token => $token,
                  prefix => $prefix,
                  in => $in,              # 'head||query',
                  },
    ...,

    };

    my $api = MyApp->new({ tokens => $tokens });

Note these are all optional, as are prefix and in, and depend on the API you are accessing. Usually prefix and in will be determined by the code generator from the spec and you will not need to set them at run time. If not, in will default to 'head' and prefix to the empty string.

The tokens will be placed in a LAsposeCellsCloud::Configuration instance as follows, but you don't need to know about this.

METHODS

base_url

The generated code has the base_url already set as a default value. This method returns the current value of base_url.

api_factory

Returns an API factory object. You probably won't need to call this directly.

    $self->api_factory('Pet'); # returns a AsposeCellsCloud::PetApi instance

    $self->pet_api;            # the same

MISSING METHODS

Most of the methods on the API are delegated to individual endpoint API objects (e.g. Pet API, Store API, User API etc). Where different endpoint APIs use the same method name (e.g. new()), these methods can't be delegated. So you need to call $api->pet_api->new().

In principle, every API is susceptible to the presence of a few, random, undelegatable method names. In practice, because of the way method names are constructed, it's unlikely in general that any methods will be undelegatable, except for:

    new()
    class_documentation()
    method_documentation()

To call these methods, you need to get a handle on the relevant object, either by calling $api->foo_api or by retrieving an object, e.g. $api->get_pet_by_id(pet_id => $pet_id). They are class methods, so you could also call them on class names.

BUILDING YOUR LIBRARY

See the homepage https://github.com/swagger-api/swagger-codegen for full details. But briefly, clone the git repository, build the codegen codebase, set up your build config file, then run the API build script. You will need git, Java 7 or 8 and Apache maven 3.0.3 or better already installed.

The config file should specify the project name for the generated library:

    {"moduleName":"WWW::MyProjectName"}

Your library files will be built under WWW::MyProjectName.

      $ git clone https://github.com/swagger-api/swagger-codegen.git
      $ cd swagger-codegen
      $ mvn package
      $ java -jar modules/swagger-codegen-cli/target/swagger-codegen-cli.jar generate \
-i [URL or file path to JSON swagger API spec] \
-l perl \
-c /path/to/config/file.json \
-o /path/to/output/folder

Bang, all done. Run the autodoc script in the bin directory to see the API you just built.

AUTOMATIC DOCUMENTATION

You can print out a summary of the generated API by running the included autodoc script in the bin directory of your generated library. A few output formats are supported:

      Usage: autodoc [OPTION]

-w           wide format (default)
-n           narrow format
-p           POD format
-H           HTML format
-m           Markdown format
-h           print this help message
-c           your application class

The -c option allows you to load and inspect your own application. A dummy namespace is used if you don't supply your own class.

DOCUMENTATION FROM THE OpenAPI Spec

Additional documentation for each class and method may be provided by the Swagger spec. If so, this is available via the class_documentation() and method_documentation() methods on each generated object class, and the method_documentation() method on the endpoint API classes:

    my $cmdoc = $api->pet_api->method_documentation->{$method_name};

    my $odoc = $api->get_pet_by_id->(pet_id => $pet_id)->class_documentation;
    my $omdoc = $api->get_pet_by_id->(pet_id => $pet_id)->method_documentation->{method_name};

Each of these calls returns a hashref with various useful pieces of information.

LOAD THE MODULES

To load the API packages:

use AsposeCellsCloud::CellsApi;
use AsposeCellsCloud::CellsAutoFilterApi;
use AsposeCellsCloud::CellsAutoshapesApi;
use AsposeCellsCloud::CellsChartAreaApi;
use AsposeCellsCloud::CellsChartsApi;
use AsposeCellsCloud::CellsConditionalFormattingsApi;
use AsposeCellsCloud::CellsHypelinksApi;
use AsposeCellsCloud::CellsListObjectsApi;
use AsposeCellsCloud::CellsOleObjectsApi;
use AsposeCellsCloud::CellsPageBreaksApi;
use AsposeCellsCloud::CellsPageSetupApi;
use AsposeCellsCloud::CellsPicturesApi;
use AsposeCellsCloud::CellsPivotTablesApi;
use AsposeCellsCloud::CellsPropertiesApi;
use AsposeCellsCloud::CellsRangesApi;
use AsposeCellsCloud::CellsSaveAsApi;
use AsposeCellsCloud::CellsShapesApi;
use AsposeCellsCloud::CellsTaskApi;
use AsposeCellsCloud::CellsWorkbookApi;
use AsposeCellsCloud::CellsWorksheetValidationsApi;
use AsposeCellsCloud::CellsWorksheetsApi;
use AsposeCellsCloud::OAuthApi;

To load the models:

use AsposeCellsCloud::Object::AboveAverage;
use AsposeCellsCloud::Object::AccessTokenResponse;
use AsposeCellsCloud::Object::Area;
use AsposeCellsCloud::Object::AutoFitterOptions;
use AsposeCellsCloud::Object::Border;
use AsposeCellsCloud::Object::CalculationOptions;
use AsposeCellsCloud::Object::CellArea;
use AsposeCellsCloud::Object::CellValue;
use AsposeCellsCloud::Object::CellsColor;
use AsposeCellsCloud::Object::Color;
use AsposeCellsCloud::Object::ColorFilter;
use AsposeCellsCloud::Object::ColorFilterRequest;
use AsposeCellsCloud::Object::ColorScale;
use AsposeCellsCloud::Object::ConditionalFormattingIcon;
use AsposeCellsCloud::Object::ConditionalFormattingValue;
use AsposeCellsCloud::Object::CopyOptions;
use AsposeCellsCloud::Object::CreatePivotTableRequest;
use AsposeCellsCloud::Object::CustomFilter;
use AsposeCellsCloud::Object::CustomParserConfig;
use AsposeCellsCloud::Object::DataBar;
use AsposeCellsCloud::Object::DataBarBorder;
use AsposeCellsCloud::Object::DataSorter;
use AsposeCellsCloud::Object::DynamicFilter;
use AsposeCellsCloud::Object::FileSource;
use AsposeCellsCloud::Object::FillFormat;
use AsposeCellsCloud::Object::FilterColumn;
use AsposeCellsCloud::Object::Font;
use AsposeCellsCloud::Object::FontSetting;
use AsposeCellsCloud::Object::GradientFill;
use AsposeCellsCloud::Object::GradientFillStop;
use AsposeCellsCloud::Object::HorizontalPageBreak;
use AsposeCellsCloud::Object::IconFilter;
use AsposeCellsCloud::Object::IconSet;
use AsposeCellsCloud::Object::ImportOption;
use AsposeCellsCloud::Object::Line;
use AsposeCellsCloud::Object::Link;
use AsposeCellsCloud::Object::LinkElement;
use AsposeCellsCloud::Object::ListColumn;
use AsposeCellsCloud::Object::MultipleFilter;
use AsposeCellsCloud::Object::MultipleFilters;
use AsposeCellsCloud::Object::NegativeBarFormat;
use AsposeCellsCloud::Object::OperateObject;
use AsposeCellsCloud::Object::OperateObjectPosition;
use AsposeCellsCloud::Object::OperateParameter;
use AsposeCellsCloud::Object::PageSection;
use AsposeCellsCloud::Object::PasswordRequest;
use AsposeCellsCloud::Object::PasteOptions;
use AsposeCellsCloud::Object::PatternFill;
use AsposeCellsCloud::Object::PdfSecurityOptions;
use AsposeCellsCloud::Object::PicFormatOption;
use AsposeCellsCloud::Object::PivotField;
use AsposeCellsCloud::Object::PivotFilter;
use AsposeCellsCloud::Object::PivotItem;
use AsposeCellsCloud::Object::PivotTableFieldRequest;
use AsposeCellsCloud::Object::ProtectSheetParameter;
use AsposeCellsCloud::Object::Range;
use AsposeCellsCloud::Object::RangeCopyRequest;
use AsposeCellsCloud::Object::RangeSetOutlineBorderRequest;
use AsposeCellsCloud::Object::RangeSetStyleRequest;
use AsposeCellsCloud::Object::Ranges;
use AsposeCellsCloud::Object::ResultDestination;
use AsposeCellsCloud::Object::SaaSposeResponse;
use AsposeCellsCloud::Object::SaveOptions;
use AsposeCellsCloud::Object::SaveResult;
use AsposeCellsCloud::Object::ShadowEffect;
use AsposeCellsCloud::Object::SingleValue;
use AsposeCellsCloud::Object::SolidFill;
use AsposeCellsCloud::Object::SortKey;
use AsposeCellsCloud::Object::SplitResult;
use AsposeCellsCloud::Object::TaskData;
use AsposeCellsCloud::Object::TaskDescription;
use AsposeCellsCloud::Object::TaskParameter;
use AsposeCellsCloud::Object::TextureFill;
use AsposeCellsCloud::Object::ThemeColor;
use AsposeCellsCloud::Object::TilePicOption;
use AsposeCellsCloud::Object::Top10;
use AsposeCellsCloud::Object::Top10Filter;
use AsposeCellsCloud::Object::ValueType;
use AsposeCellsCloud::Object::VerticalPageBreak;
use AsposeCellsCloud::Object::Workbook;
use AsposeCellsCloud::Object::WorkbookEncryptionRequest;
use AsposeCellsCloud::Object::WorkbookProtectionRequest;
use AsposeCellsCloud::Object::WorkbookSettings;
use AsposeCellsCloud::Object::Worksheet;
use AsposeCellsCloud::Object::WorksheetMovingRequest;
use AsposeCellsCloud::Object::AutoFilter;
use AsposeCellsCloud::Object::AutoFilterResponse;
use AsposeCellsCloud::Object::AutoShapeResponse;
use AsposeCellsCloud::Object::AutoShapes;
use AsposeCellsCloud::Object::AutoShapesResponse;
use AsposeCellsCloud::Object::Cell;
use AsposeCellsCloud::Object::CellResponse;
use AsposeCellsCloud::Object::Cells;
use AsposeCellsCloud::Object::CellsDocumentProperties;
use AsposeCellsCloud::Object::CellsDocumentPropertiesResponse;
use AsposeCellsCloud::Object::CellsDocumentProperty;
use AsposeCellsCloud::Object::CellsDocumentPropertyResponse;
use AsposeCellsCloud::Object::CellsObjectOperateTaskParameter;
use AsposeCellsCloud::Object::CellsResponse;
use AsposeCellsCloud::Object::Chart;
use AsposeCellsCloud::Object::ChartAreaResponse;
use AsposeCellsCloud::Object::ChartFrame;
use AsposeCellsCloud::Object::ChartOperateParameter;
use AsposeCellsCloud::Object::Charts;
use AsposeCellsCloud::Object::ChartsResponse;
use AsposeCellsCloud::Object::Column;
use AsposeCellsCloud::Object::ColumnResponse;
use AsposeCellsCloud::Object::Columns;
use AsposeCellsCloud::Object::ColumnsResponse;
use AsposeCellsCloud::Object::Comment;
use AsposeCellsCloud::Object::CommentResponse;
use AsposeCellsCloud::Object::Comments;
use AsposeCellsCloud::Object::CommentsResponse;
use AsposeCellsCloud::Object::ConditionalFormatting;
use AsposeCellsCloud::Object::ConditionalFormattingResponse;
use AsposeCellsCloud::Object::ConditionalFormattings;
use AsposeCellsCloud::Object::ConditionalFormattingsResponse;
use AsposeCellsCloud::Object::ConvertTaskParameter;
use AsposeCellsCloud::Object::DifSaveOptions;
use AsposeCellsCloud::Object::FillFormatResponse;
use AsposeCellsCloud::Object::FormatCondition;
use AsposeCellsCloud::Object::HorizontalPageBreakResponse;
use AsposeCellsCloud::Object::HorizontalPageBreaks;
use AsposeCellsCloud::Object::HorizontalPageBreaksResponse;
use AsposeCellsCloud::Object::HtmlSaveOptions;
use AsposeCellsCloud::Object::Hyperlink;
use AsposeCellsCloud::Object::HyperlinkResponse;
use AsposeCellsCloud::Object::Hyperlinks;
use AsposeCellsCloud::Object::HyperlinksResponse;
use AsposeCellsCloud::Object::ImageSaveOptions;
use AsposeCellsCloud::Object::ImportBatchDataOption;
use AsposeCellsCloud::Object::ImportCSVDataOption;
use AsposeCellsCloud::Object::ImportDataTaskParameter;
use AsposeCellsCloud::Object::ImportDoubleArrayOption;
use AsposeCellsCloud::Object::ImportIntArrayOption;
use AsposeCellsCloud::Object::ImportStringArrayOption;
use AsposeCellsCloud::Object::LegendResponse;
use AsposeCellsCloud::Object::LineFormat;
use AsposeCellsCloud::Object::LineResponse;
use AsposeCellsCloud::Object::ListObject;
use AsposeCellsCloud::Object::ListObjectOperateParameter;
use AsposeCellsCloud::Object::ListObjectResponse;
use AsposeCellsCloud::Object::ListObjects;
use AsposeCellsCloud::Object::ListObjectsResponse;
use AsposeCellsCloud::Object::MHtmlSaveOptions;
use AsposeCellsCloud::Object::MergedCell;
use AsposeCellsCloud::Object::MergedCellResponse;
use AsposeCellsCloud::Object::MergedCells;
use AsposeCellsCloud::Object::MergedCellsResponse;
use AsposeCellsCloud::Object::Name;
use AsposeCellsCloud::Object::NameResponse;
use AsposeCellsCloud::Object::Names;
use AsposeCellsCloud::Object::NamesResponse;
use AsposeCellsCloud::Object::OdsSaveOptions;
use AsposeCellsCloud::Object::OleObjectResponse;
use AsposeCellsCloud::Object::OleObjects;
use AsposeCellsCloud::Object::OleObjectsResponse;
use AsposeCellsCloud::Object::OoxmlSaveOptions;
use AsposeCellsCloud::Object::PageBreakOperateParameter;
use AsposeCellsCloud::Object::PageSectionsResponse;
use AsposeCellsCloud::Object::PageSetup;
use AsposeCellsCloud::Object::PageSetupOperateParameter;
use AsposeCellsCloud::Object::PageSetupResponse;
use AsposeCellsCloud::Object::PdfSaveOptions;
use AsposeCellsCloud::Object::PictureResponse;
use AsposeCellsCloud::Object::Pictures;
use AsposeCellsCloud::Object::PicturesResponse;
use AsposeCellsCloud::Object::PivotFieldResponse;
use AsposeCellsCloud::Object::PivotFilterResponse;
use AsposeCellsCloud::Object::PivotFiltersResponse;
use AsposeCellsCloud::Object::PivotTable;
use AsposeCellsCloud::Object::PivotTableOperateParameter;
use AsposeCellsCloud::Object::PivotTableResponse;
use AsposeCellsCloud::Object::PivotTables;
use AsposeCellsCloud::Object::PivotTablesResponse;
use AsposeCellsCloud::Object::RangeValueResponse;
use AsposeCellsCloud::Object::RangesResponse;
use AsposeCellsCloud::Object::Row;
use AsposeCellsCloud::Object::RowResponse;
use AsposeCellsCloud::Object::Rows;
use AsposeCellsCloud::Object::RowsResponse;
use AsposeCellsCloud::Object::SaveResponse;
use AsposeCellsCloud::Object::SaveResultTaskParameter;
use AsposeCellsCloud::Object::Shape;
use AsposeCellsCloud::Object::ShapeOperateParameter;
use AsposeCellsCloud::Object::ShapeResponse;
use AsposeCellsCloud::Object::Shapes;
use AsposeCellsCloud::Object::ShapesResponse;
use AsposeCellsCloud::Object::SingleValueResponse;
use AsposeCellsCloud::Object::SmartMarkerTaskParameter;
use AsposeCellsCloud::Object::SplitResultDocument;
use AsposeCellsCloud::Object::SplitResultResponse;
use AsposeCellsCloud::Object::SplitWorkbookTaskParameter;
use AsposeCellsCloud::Object::SpreadsheetML2003SaveOptions;
use AsposeCellsCloud::Object::Style;
use AsposeCellsCloud::Object::StyleResponse;
use AsposeCellsCloud::Object::SvgSaveOptions;
use AsposeCellsCloud::Object::TextItem;
use AsposeCellsCloud::Object::TextItems;
use AsposeCellsCloud::Object::TextItemsResponse;
use AsposeCellsCloud::Object::TextOptions;
use AsposeCellsCloud::Object::TitleResponse;
use AsposeCellsCloud::Object::TxtSaveOptions;
use AsposeCellsCloud::Object::Validation;
use AsposeCellsCloud::Object::ValidationResponse;
use AsposeCellsCloud::Object::Validations;
use AsposeCellsCloud::Object::ValidationsResponse;
use AsposeCellsCloud::Object::VerticalPageBreakResponse;
use AsposeCellsCloud::Object::VerticalPageBreaks;
use AsposeCellsCloud::Object::VerticalPageBreaksResponse;
use AsposeCellsCloud::Object::WorkbookOperateParameter;
use AsposeCellsCloud::Object::WorkbookReplaceResponse;
use AsposeCellsCloud::Object::WorkbookResponse;
use AsposeCellsCloud::Object::WorkbookSettingsOperateParameter;
use AsposeCellsCloud::Object::WorkbookSettingsResponse;
use AsposeCellsCloud::Object::WorksheetReplaceResponse;
use AsposeCellsCloud::Object::WorksheetResponse;
use AsposeCellsCloud::Object::Worksheets;
use AsposeCellsCloud::Object::WorksheetsResponse;
use AsposeCellsCloud::Object::XlsSaveOptions;
use AsposeCellsCloud::Object::XlsbSaveOptions;
use AsposeCellsCloud::Object::XpsSaveOptions;
use AsposeCellsCloud::Object::AutoShape;
use AsposeCellsCloud::Object::ChartArea;
use AsposeCellsCloud::Object::Legend;
use AsposeCellsCloud::Object::OleObject;
use AsposeCellsCloud::Object::Picture;
use AsposeCellsCloud::Object::Title;

GETTING STARTED

Put the Perl SDK under the 'lib' folder in your project directory, then run the following

#!/usr/bin/perl
use lib 'lib';
use strict;
use warnings;
# load the API package
use AsposeCellsCloud::CellsApi;
use AsposeCellsCloud::CellsAutoFilterApi;
use AsposeCellsCloud::CellsAutoshapesApi;
use AsposeCellsCloud::CellsChartAreaApi;
use AsposeCellsCloud::CellsChartsApi;
use AsposeCellsCloud::CellsConditionalFormattingsApi;
use AsposeCellsCloud::CellsHypelinksApi;
use AsposeCellsCloud::CellsListObjectsApi;
use AsposeCellsCloud::CellsOleObjectsApi;
use AsposeCellsCloud::CellsPageBreaksApi;
use AsposeCellsCloud::CellsPageSetupApi;
use AsposeCellsCloud::CellsPicturesApi;
use AsposeCellsCloud::CellsPivotTablesApi;
use AsposeCellsCloud::CellsPropertiesApi;
use AsposeCellsCloud::CellsRangesApi;
use AsposeCellsCloud::CellsSaveAsApi;
use AsposeCellsCloud::CellsShapesApi;
use AsposeCellsCloud::CellsTaskApi;
use AsposeCellsCloud::CellsWorkbookApi;
use AsposeCellsCloud::CellsWorksheetValidationsApi;
use AsposeCellsCloud::CellsWorksheetsApi;
use AsposeCellsCloud::OAuthApi;

# load the models
use AsposeCellsCloud::Object::AboveAverage;
use AsposeCellsCloud::Object::AccessTokenResponse;
use AsposeCellsCloud::Object::Area;
use AsposeCellsCloud::Object::AutoFitterOptions;
use AsposeCellsCloud::Object::Border;
use AsposeCellsCloud::Object::CalculationOptions;
use AsposeCellsCloud::Object::CellArea;
use AsposeCellsCloud::Object::CellValue;
use AsposeCellsCloud::Object::CellsColor;
use AsposeCellsCloud::Object::Color;
use AsposeCellsCloud::Object::ColorFilter;
use AsposeCellsCloud::Object::ColorFilterRequest;
use AsposeCellsCloud::Object::ColorScale;
use AsposeCellsCloud::Object::ConditionalFormattingIcon;
use AsposeCellsCloud::Object::ConditionalFormattingValue;
use AsposeCellsCloud::Object::CopyOptions;
use AsposeCellsCloud::Object::CreatePivotTableRequest;
use AsposeCellsCloud::Object::CustomFilter;
use AsposeCellsCloud::Object::CustomParserConfig;
use AsposeCellsCloud::Object::DataBar;
use AsposeCellsCloud::Object::DataBarBorder;
use AsposeCellsCloud::Object::DataSorter;
use AsposeCellsCloud::Object::DynamicFilter;
use AsposeCellsCloud::Object::FileSource;
use AsposeCellsCloud::Object::FillFormat;
use AsposeCellsCloud::Object::FilterColumn;
use AsposeCellsCloud::Object::Font;
use AsposeCellsCloud::Object::FontSetting;
use AsposeCellsCloud::Object::GradientFill;
use AsposeCellsCloud::Object::GradientFillStop;
use AsposeCellsCloud::Object::HorizontalPageBreak;
use AsposeCellsCloud::Object::IconFilter;
use AsposeCellsCloud::Object::IconSet;
use AsposeCellsCloud::Object::ImportOption;
use AsposeCellsCloud::Object::Line;
use AsposeCellsCloud::Object::Link;
use AsposeCellsCloud::Object::LinkElement;
use AsposeCellsCloud::Object::ListColumn;
use AsposeCellsCloud::Object::MultipleFilter;
use AsposeCellsCloud::Object::MultipleFilters;
use AsposeCellsCloud::Object::NegativeBarFormat;
use AsposeCellsCloud::Object::OperateObject;
use AsposeCellsCloud::Object::OperateObjectPosition;
use AsposeCellsCloud::Object::OperateParameter;
use AsposeCellsCloud::Object::PageSection;
use AsposeCellsCloud::Object::PasswordRequest;
use AsposeCellsCloud::Object::PasteOptions;
use AsposeCellsCloud::Object::PatternFill;
use AsposeCellsCloud::Object::PdfSecurityOptions;
use AsposeCellsCloud::Object::PicFormatOption;
use AsposeCellsCloud::Object::PivotField;
use AsposeCellsCloud::Object::PivotFilter;
use AsposeCellsCloud::Object::PivotItem;
use AsposeCellsCloud::Object::PivotTableFieldRequest;
use AsposeCellsCloud::Object::ProtectSheetParameter;
use AsposeCellsCloud::Object::Range;
use AsposeCellsCloud::Object::RangeCopyRequest;
use AsposeCellsCloud::Object::RangeSetOutlineBorderRequest;
use AsposeCellsCloud::Object::RangeSetStyleRequest;
use AsposeCellsCloud::Object::Ranges;
use AsposeCellsCloud::Object::ResultDestination;
use AsposeCellsCloud::Object::SaaSposeResponse;
use AsposeCellsCloud::Object::SaveOptions;
use AsposeCellsCloud::Object::SaveResult;
use AsposeCellsCloud::Object::ShadowEffect;
use AsposeCellsCloud::Object::SingleValue;
use AsposeCellsCloud::Object::SolidFill;
use AsposeCellsCloud::Object::SortKey;
use AsposeCellsCloud::Object::SplitResult;
use AsposeCellsCloud::Object::TaskData;
use AsposeCellsCloud::Object::TaskDescription;
use AsposeCellsCloud::Object::TaskParameter;
use AsposeCellsCloud::Object::TextureFill;
use AsposeCellsCloud::Object::ThemeColor;
use AsposeCellsCloud::Object::TilePicOption;
use AsposeCellsCloud::Object::Top10;
use AsposeCellsCloud::Object::Top10Filter;
use AsposeCellsCloud::Object::ValueType;
use AsposeCellsCloud::Object::VerticalPageBreak;
use AsposeCellsCloud::Object::Workbook;
use AsposeCellsCloud::Object::WorkbookEncryptionRequest;
use AsposeCellsCloud::Object::WorkbookProtectionRequest;
use AsposeCellsCloud::Object::WorkbookSettings;
use AsposeCellsCloud::Object::Worksheet;
use AsposeCellsCloud::Object::WorksheetMovingRequest;
use AsposeCellsCloud::Object::AutoFilter;
use AsposeCellsCloud::Object::AutoFilterResponse;
use AsposeCellsCloud::Object::AutoShapeResponse;
use AsposeCellsCloud::Object::AutoShapes;
use AsposeCellsCloud::Object::AutoShapesResponse;
use AsposeCellsCloud::Object::Cell;
use AsposeCellsCloud::Object::CellResponse;
use AsposeCellsCloud::Object::Cells;
use AsposeCellsCloud::Object::CellsDocumentProperties;
use AsposeCellsCloud::Object::CellsDocumentPropertiesResponse;
use AsposeCellsCloud::Object::CellsDocumentProperty;
use AsposeCellsCloud::Object::CellsDocumentPropertyResponse;
use AsposeCellsCloud::Object::CellsObjectOperateTaskParameter;
use AsposeCellsCloud::Object::CellsResponse;
use AsposeCellsCloud::Object::Chart;
use AsposeCellsCloud::Object::ChartAreaResponse;
use AsposeCellsCloud::Object::ChartFrame;
use AsposeCellsCloud::Object::ChartOperateParameter;
use AsposeCellsCloud::Object::Charts;
use AsposeCellsCloud::Object::ChartsResponse;
use AsposeCellsCloud::Object::Column;
use AsposeCellsCloud::Object::ColumnResponse;
use AsposeCellsCloud::Object::Columns;
use AsposeCellsCloud::Object::ColumnsResponse;
use AsposeCellsCloud::Object::Comment;
use AsposeCellsCloud::Object::CommentResponse;
use AsposeCellsCloud::Object::Comments;
use AsposeCellsCloud::Object::CommentsResponse;
use AsposeCellsCloud::Object::ConditionalFormatting;
use AsposeCellsCloud::Object::ConditionalFormattingResponse;
use AsposeCellsCloud::Object::ConditionalFormattings;
use AsposeCellsCloud::Object::ConditionalFormattingsResponse;
use AsposeCellsCloud::Object::ConvertTaskParameter;
use AsposeCellsCloud::Object::DifSaveOptions;
use AsposeCellsCloud::Object::FillFormatResponse;
use AsposeCellsCloud::Object::FormatCondition;
use AsposeCellsCloud::Object::HorizontalPageBreakResponse;
use AsposeCellsCloud::Object::HorizontalPageBreaks;
use AsposeCellsCloud::Object::HorizontalPageBreaksResponse;
use AsposeCellsCloud::Object::HtmlSaveOptions;
use AsposeCellsCloud::Object::Hyperlink;
use AsposeCellsCloud::Object::HyperlinkResponse;
use AsposeCellsCloud::Object::Hyperlinks;
use AsposeCellsCloud::Object::HyperlinksResponse;
use AsposeCellsCloud::Object::ImageSaveOptions;
use AsposeCellsCloud::Object::ImportBatchDataOption;
use AsposeCellsCloud::Object::ImportCSVDataOption;
use AsposeCellsCloud::Object::ImportDataTaskParameter;
use AsposeCellsCloud::Object::ImportDoubleArrayOption;
use AsposeCellsCloud::Object::ImportIntArrayOption;
use AsposeCellsCloud::Object::ImportStringArrayOption;
use AsposeCellsCloud::Object::LegendResponse;
use AsposeCellsCloud::Object::LineFormat;
use AsposeCellsCloud::Object::LineResponse;
use AsposeCellsCloud::Object::ListObject;
use AsposeCellsCloud::Object::ListObjectOperateParameter;
use AsposeCellsCloud::Object::ListObjectResponse;
use AsposeCellsCloud::Object::ListObjects;
use AsposeCellsCloud::Object::ListObjectsResponse;
use AsposeCellsCloud::Object::MHtmlSaveOptions;
use AsposeCellsCloud::Object::MergedCell;
use AsposeCellsCloud::Object::MergedCellResponse;
use AsposeCellsCloud::Object::MergedCells;
use AsposeCellsCloud::Object::MergedCellsResponse;
use AsposeCellsCloud::Object::Name;
use AsposeCellsCloud::Object::NameResponse;
use AsposeCellsCloud::Object::Names;
use AsposeCellsCloud::Object::NamesResponse;
use AsposeCellsCloud::Object::OdsSaveOptions;
use AsposeCellsCloud::Object::OleObjectResponse;
use AsposeCellsCloud::Object::OleObjects;
use AsposeCellsCloud::Object::OleObjectsResponse;
use AsposeCellsCloud::Object::OoxmlSaveOptions;
use AsposeCellsCloud::Object::PageBreakOperateParameter;
use AsposeCellsCloud::Object::PageSectionsResponse;
use AsposeCellsCloud::Object::PageSetup;
use AsposeCellsCloud::Object::PageSetupOperateParameter;
use AsposeCellsCloud::Object::PageSetupResponse;
use AsposeCellsCloud::Object::PdfSaveOptions;
use AsposeCellsCloud::Object::PictureResponse;
use AsposeCellsCloud::Object::Pictures;
use AsposeCellsCloud::Object::PicturesResponse;
use AsposeCellsCloud::Object::PivotFieldResponse;
use AsposeCellsCloud::Object::PivotFilterResponse;
use AsposeCellsCloud::Object::PivotFiltersResponse;
use AsposeCellsCloud::Object::PivotTable;
use AsposeCellsCloud::Object::PivotTableOperateParameter;
use AsposeCellsCloud::Object::PivotTableResponse;
use AsposeCellsCloud::Object::PivotTables;
use AsposeCellsCloud::Object::PivotTablesResponse;
use AsposeCellsCloud::Object::RangeValueResponse;
use AsposeCellsCloud::Object::RangesResponse;
use AsposeCellsCloud::Object::Row;
use AsposeCellsCloud::Object::RowResponse;
use AsposeCellsCloud::Object::Rows;
use AsposeCellsCloud::Object::RowsResponse;
use AsposeCellsCloud::Object::SaveResponse;
use AsposeCellsCloud::Object::SaveResultTaskParameter;
use AsposeCellsCloud::Object::Shape;
use AsposeCellsCloud::Object::ShapeOperateParameter;
use AsposeCellsCloud::Object::ShapeResponse;
use AsposeCellsCloud::Object::Shapes;
use AsposeCellsCloud::Object::ShapesResponse;
use AsposeCellsCloud::Object::SingleValueResponse;
use AsposeCellsCloud::Object::SmartMarkerTaskParameter;
use AsposeCellsCloud::Object::SplitResultDocument;
use AsposeCellsCloud::Object::SplitResultResponse;
use AsposeCellsCloud::Object::SplitWorkbookTaskParameter;
use AsposeCellsCloud::Object::SpreadsheetML2003SaveOptions;
use AsposeCellsCloud::Object::Style;
use AsposeCellsCloud::Object::StyleResponse;
use AsposeCellsCloud::Object::SvgSaveOptions;
use AsposeCellsCloud::Object::TextItem;
use AsposeCellsCloud::Object::TextItems;
use AsposeCellsCloud::Object::TextItemsResponse;
use AsposeCellsCloud::Object::TextOptions;
use AsposeCellsCloud::Object::TitleResponse;
use AsposeCellsCloud::Object::TxtSaveOptions;
use AsposeCellsCloud::Object::Validation;
use AsposeCellsCloud::Object::ValidationResponse;
use AsposeCellsCloud::Object::Validations;
use AsposeCellsCloud::Object::ValidationsResponse;
use AsposeCellsCloud::Object::VerticalPageBreakResponse;
use AsposeCellsCloud::Object::VerticalPageBreaks;
use AsposeCellsCloud::Object::VerticalPageBreaksResponse;
use AsposeCellsCloud::Object::WorkbookOperateParameter;
use AsposeCellsCloud::Object::WorkbookReplaceResponse;
use AsposeCellsCloud::Object::WorkbookResponse;
use AsposeCellsCloud::Object::WorkbookSettingsOperateParameter;
use AsposeCellsCloud::Object::WorkbookSettingsResponse;
use AsposeCellsCloud::Object::WorksheetReplaceResponse;
use AsposeCellsCloud::Object::WorksheetResponse;
use AsposeCellsCloud::Object::Worksheets;
use AsposeCellsCloud::Object::WorksheetsResponse;
use AsposeCellsCloud::Object::XlsSaveOptions;
use AsposeCellsCloud::Object::XlsbSaveOptions;
use AsposeCellsCloud::Object::XpsSaveOptions;
use AsposeCellsCloud::Object::AutoShape;
use AsposeCellsCloud::Object::ChartArea;
use AsposeCellsCloud::Object::Legend;
use AsposeCellsCloud::Object::OleObject;
use AsposeCellsCloud::Object::Picture;
use AsposeCellsCloud::Object::Title;

# for displaying the API response data
use Data::Dumper;
use AsposeCellsCloud::;

my $api_instance = AsposeCellsCloud::->new(
);

my $name = 'name_example'; # string | The workbook name.
my $sheet_name = 'sheet_name_example'; # string | The worksheet name.
my $column_index = 56; # int | The column index.
my $columns = 56; # int | The columns.
my $update_reference = 1; # boolean | The update reference.
my $folder = 'folder_example'; # string | The workbook folder.
my $storage = 'storage_example'; # string | storage name.

eval {
    my $result = $api_instance->cells_delete_worksheet_columns(name => $name, sheet_name => $sheet_name, column_index => $column_index, columns => $columns, update_reference => $update_reference, folder => $folder, storage => $storage);
    print Dumper($result);
};
if ($@) {
    warn "Exception when calling CellsApi->cells_delete_worksheet_columns: $@\n";
}

DOCUMENTATION FOR API ENDPOINTS

All URIs are relative to https://api.aspose.cloud/v1.1/

Class | Method | HTTP request | Description ------------ | ------------- | ------------- | ------------- CellsApi | cells_delete_worksheet_columns | DELETE /cells/{name}/worksheets/{sheetName}/cells/columns/{columnIndex} | Delete worksheet columns. CellsApi | cells_delete_worksheet_row | DELETE /cells/{name}/worksheets/{sheetName}/cells/rows/{rowIndex} | Delete worksheet row. CellsApi | cells_delete_worksheet_rows | DELETE /cells/{name}/worksheets/{sheetName}/cells/rows | Delete several worksheet rows. CellsApi | cells_get_cell_html_string | GET /cells/{name}/worksheets/{sheetName}/cells/{cellName}/htmlstring | Read cell data by cell's name. CellsApi | cells_get_worksheet_cell | GET /cells/{name}/worksheets/{sheetName}/cells/{cellOrMethodName} | Read cell data by cell's name. CellsApi | cells_get_worksheet_cell_style | GET /cells/{name}/worksheets/{sheetName}/cells/{cellName}/style | Read cell's style info. CellsApi | cells_get_worksheet_cells | GET /cells/{name}/worksheets/{sheetName}/cells | Get cells info. CellsApi | cells_get_worksheet_column | GET /cells/{name}/worksheets/{sheetName}/cells/columns/{columnIndex} | Read worksheet column data by column's index. CellsApi | cells_get_worksheet_columns | GET /cells/{name}/worksheets/{sheetName}/cells/columns | Read worksheet columns info. CellsApi | cells_get_worksheet_row | GET /cells/{name}/worksheets/{sheetName}/cells/rows/{rowIndex} | Read worksheet row data by row's index. CellsApi | cells_get_worksheet_rows | GET /cells/{name}/worksheets/{sheetName}/cells/rows | Read worksheet rows info. CellsApi | cells_post_cell_calculate | POST /cells/{name}/worksheets/{sheetName}/cells/{cellName}/calculate | Cell calculate formula CellsApi | cells_post_cell_characters | POST /cells/{name}/worksheets/{sheetName}/cells/{cellName}/characters | Set cell characters CellsApi | cells_post_clear_contents | POST /cells/{name}/worksheets/{sheetName}/cells/clearcontents | Clear cells contents. CellsApi | cells_post_clear_formats | POST /cells/{name}/worksheets/{sheetName}/cells/clearformats | Clear cells contents. CellsApi | cells_post_column_style | POST /cells/{name}/worksheets/{sheetName}/cells/columns/{columnIndex}/style | Set column style CellsApi | cells_post_copy_cell_into_cell | POST /cells/{name}/worksheets/{sheetName}/cells/{destCellName}/copy | Copy cell into cell CellsApi | cells_post_copy_worksheet_columns | POST /cells/{name}/worksheets/{sheetName}/cells/columns/copy | Copy worksheet columns. CellsApi | cells_post_copy_worksheet_rows | POST /cells/{name}/worksheets/{sheetName}/cells/rows/copy | Copy worksheet rows. CellsApi | cells_post_group_worksheet_columns | POST /cells/{name}/worksheets/{sheetName}/cells/columns/group | Group worksheet columns. CellsApi | cells_post_group_worksheet_rows | POST /cells/{name}/worksheets/{sheetName}/cells/rows/group | Group worksheet rows. CellsApi | cells_post_hide_worksheet_columns | POST /cells/{name}/worksheets/{sheetName}/cells/columns/hide | Hide worksheet columns. CellsApi | cells_post_hide_worksheet_rows | POST /cells/{name}/worksheets/{sheetName}/cells/rows/hide | Hide worksheet rows. CellsApi | cells_post_row_style | POST /cells/{name}/worksheets/{sheetName}/cells/rows/{rowIndex}/style | Set row style. CellsApi | cells_post_set_cell_html_string | POST /cells/{name}/worksheets/{sheetName}/cells/{cellName}/htmlstring | Set htmlstring value into cell CellsApi | cells_post_set_cell_range_value | POST /cells/{name}/worksheets/{sheetName}/cells | Set cell range value CellsApi | cells_post_set_worksheet_column_width | POST /cells/{name}/worksheets/{sheetName}/cells/columns/{columnIndex} | Set worksheet column width. CellsApi | cells_post_ungroup_worksheet_columns | POST /cells/{name}/worksheets/{sheetName}/cells/columns/ungroup | Ungroup worksheet columns. CellsApi | cells_post_ungroup_worksheet_rows | POST /cells/{name}/worksheets/{sheetName}/cells/rows/ungroup | Ungroup worksheet rows. CellsApi | cells_post_unhide_worksheet_columns | POST /cells/{name}/worksheets/{sheetName}/cells/columns/unhide | Unhide worksheet columns. CellsApi | cells_post_unhide_worksheet_rows | POST /cells/{name}/worksheets/{sheetName}/cells/rows/unhide | Unhide worksheet rows. CellsApi | cells_post_update_worksheet_cell_style | POST /cells/{name}/worksheets/{sheetName}/cells/{cellName}/style | Update cell's style. CellsApi | cells_post_update_worksheet_range_style | POST /cells/{name}/worksheets/{sheetName}/cells/style | Update cell's range style. CellsApi | cells_post_update_worksheet_row | POST /cells/{name}/worksheets/{sheetName}/cells/rows/{rowIndex} | Update worksheet row. CellsApi | cells_post_worksheet_cell_set_value | POST /cells/{name}/worksheets/{sheetName}/cells/{cellName} | Set cell value. CellsApi | cells_post_worksheet_merge | POST /cells/{name}/worksheets/{sheetName}/cells/merge | Merge cells. CellsApi | cells_post_worksheet_unmerge | POST /cells/{name}/worksheets/{sheetName}/cells/unmerge | Unmerge cells. CellsApi | cells_put_insert_worksheet_columns | PUT /cells/{name}/worksheets/{sheetName}/cells/columns/{columnIndex} | Insert worksheet columns. CellsApi | cells_put_insert_worksheet_row | PUT /cells/{name}/worksheets/{sheetName}/cells/rows/{rowIndex} | Insert new worksheet row. CellsApi | cells_put_insert_worksheet_rows | PUT /cells/{name}/worksheets/{sheetName}/cells/rows | Insert several new worksheet rows. CellsAutoFilterApi | cells_auto_filter_delete_worksheet_date_filter | DELETE /cells/{name}/worksheets/{sheetName}/autoFilter/dateFilter | Removes a date filter.
CellsAutoFilterApi | cells_auto_filter_delete_worksheet_filter | DELETE /cells/{name}/worksheets/{sheetName}/autoFilter/filter | Delete a filter for a filter column.
CellsAutoFilterApi | cells_auto_filter_get_worksheet_auto_filter | GET /cells/{name}/worksheets/{sheetName}/autoFilter | Get Auto filter Description CellsAutoFilterApi | cells_auto_filter_post_worksheet_auto_filter_refresh | POST /cells/{name}/worksheets/{sheetName}/autoFilter/refresh | CellsAutoFilterApi | cells_auto_filter_post_worksheet_match_blanks | POST /cells/{name}/worksheets/{sheetName}/autoFilter/matchBlanks | Match all blank cell in the list. CellsAutoFilterApi | cells_auto_filter_post_worksheet_match_non_blanks | POST /cells/{name}/worksheets/{sheetName}/autoFilter/matchNonBlanks | Match all not blank cell in the list.
CellsAutoFilterApi | cells_auto_filter_put_worksheet_color_filter | PUT /cells/{name}/worksheets/{sheetName}/autoFilter/colorFilter | CellsAutoFilterApi | cells_auto_filter_put_worksheet_custom_filter | PUT /cells/{name}/worksheets/{sheetName}/autoFilter/custom | Filters a list with a custom criteria.
CellsAutoFilterApi | cells_auto_filter_put_worksheet_date_filter | PUT /cells/{name}/worksheets/{sheetName}/autoFilter/dateFilter | add date filter in worksheet CellsAutoFilterApi | cells_auto_filter_put_worksheet_dynamic_filter | PUT /cells/{name}/worksheets/{sheetName}/autoFilter/dynamicFilter | CellsAutoFilterApi | cells_auto_filter_put_worksheet_filter | PUT /cells/{name}/worksheets/{sheetName}/autoFilter/filter | Adds a filter for a filter column.
CellsAutoFilterApi | cells_auto_filter_put_worksheet_filter_top10 | PUT /cells/{name}/worksheets/{sheetName}/autoFilter/filterTop10 | Filter the top 10 item in the list CellsAutoFilterApi | cells_auto_filter_put_worksheet_icon_filter | PUT /cells/{name}/worksheets/{sheetName}/autoFilter/iconFilter | Adds an icon filter. CellsAutoshapesApi | cells_autoshapes_get_worksheet_autoshape | GET /cells/{name}/worksheets/{sheetName}/autoshapes/{autoshapeNumber} | Get autoshape info. CellsAutoshapesApi | cells_autoshapes_get_worksheet_autoshapes | GET /cells/{name}/worksheets/{sheetName}/autoshapes | Get worksheet autoshapes info. CellsChartAreaApi | cells_chart_area_get_chart_area | GET /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/chartArea | Get chart area info. CellsChartAreaApi | cells_chart_area_get_chart_area_border | GET /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/chartArea/border | Get chart area border info. CellsChartAreaApi | cells_chart_area_get_chart_area_fill_format | GET /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/chartArea/fillFormat | Get chart area fill format info. CellsChartsApi | cells_charts_delete_worksheet_chart_legend | DELETE /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/legend | Hide legend in chart CellsChartsApi | cells_charts_delete_worksheet_chart_title | DELETE /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/title | Hide title in chart CellsChartsApi | cells_charts_delete_worksheet_clear_charts | DELETE /cells/{name}/worksheets/{sheetName}/charts | Clear the charts. CellsChartsApi | cells_charts_delete_worksheet_delete_chart | DELETE /cells/{name}/worksheets/{sheetName}/charts/{chartIndex} | Delete worksheet chart by index. CellsChartsApi | cells_charts_get_worksheet_chart | GET /cells/{name}/worksheets/{sheetName}/charts/{chartNumber} | Get chart info. CellsChartsApi | cells_charts_get_worksheet_chart_legend | GET /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/legend | Get chart legend CellsChartsApi | cells_charts_get_worksheet_chart_title | GET /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/title | Get chart title CellsChartsApi | cells_charts_get_worksheet_charts | GET /cells/{name}/worksheets/{sheetName}/charts | Get worksheet charts info. CellsChartsApi | cells_charts_post_worksheet_chart | POST /cells/{name}/worksheets/{sheetName}/charts/{chartIndex} | Update chart propreties CellsChartsApi | cells_charts_post_worksheet_chart_legend | POST /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/legend | Update chart legend CellsChartsApi | cells_charts_post_worksheet_chart_title | POST /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/title | Update chart title CellsChartsApi | cells_charts_put_worksheet_add_chart | PUT /cells/{name}/worksheets/{sheetName}/charts | Add new chart to worksheet. CellsChartsApi | cells_charts_put_worksheet_chart_legend | PUT /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/legend | Show legend in chart CellsChartsApi | cells_charts_put_worksheet_chart_title | PUT /cells/{name}/worksheets/{sheetName}/charts/{chartIndex}/title | Add chart title / Set chart title visible CellsConditionalFormattingsApi | cells_conditional_formattings_delete_worksheet_conditional_formatting | DELETE /cells/{name}/worksheets/{sheetName}/conditionalFormattings/{index} | Remove conditional formatting CellsConditionalFormattingsApi | cells_conditional_formattings_delete_worksheet_conditional_formatting_area | DELETE /cells/{name}/worksheets/{sheetName}/conditionalFormattings/area | Remove cell area from conditional formatting. CellsConditionalFormattingsApi | cells_conditional_formattings_delete_worksheet_conditional_formattings | DELETE /cells/{name}/worksheets/{sheetName}/conditionalFormattings | Clear all condition formattings CellsConditionalFormattingsApi | cells_conditional_formattings_get_worksheet_conditional_formatting | GET /cells/{name}/worksheets/{sheetName}/conditionalFormattings/{index} | Get conditional formatting CellsConditionalFormattingsApi | cells_conditional_formattings_get_worksheet_conditional_formattings | GET /cells/{name}/worksheets/{sheetName}/conditionalFormattings | Get conditional formattings CellsConditionalFormattingsApi | cells_conditional_formattings_put_worksheet_conditional_formatting | PUT /cells/{name}/worksheets/{sheetName}/conditionalFormattings | Add a condition formatting. CellsConditionalFormattingsApi | cells_conditional_formattings_put_worksheet_format_condition | PUT /cells/{name}/worksheets/{sheetName}/conditionalFormattings/{index} | Add a format condition. CellsConditionalFormattingsApi | cells_conditional_formattings_put_worksheet_format_condition_area | PUT /cells/{name}/worksheets/{sheetName}/conditionalFormattings/{index}/area | add a cell area for format condition
CellsConditionalFormattingsApi | cells_conditional_formattings_put_worksheet_format_condition_condition | PUT /cells/{name}/worksheets/{sheetName}/conditionalFormattings/{index}/condition | Add a condition for format condition. CellsHypelinksApi | cells_hypelinks_delete_worksheet_hyperlink | DELETE /cells/{name}/worksheets/{sheetName}/hyperlinks/{hyperlinkIndex} | Delete worksheet hyperlink by index. CellsHypelinksApi | cells_hypelinks_delete_worksheet_hyperlinks | DELETE /cells/{name}/worksheets/{sheetName}/hyperlinks | Delete all hyperlinks in worksheet. CellsHypelinksApi | cells_hypelinks_get_worksheet_hyperlink | GET /cells/{name}/worksheets/{sheetName}/hyperlinks/{hyperlinkIndex} | Get worksheet hyperlink by index. CellsHypelinksApi | cells_hypelinks_get_worksheet_hyperlinks | GET /cells/{name}/worksheets/{sheetName}/hyperlinks | Get worksheet hyperlinks. CellsHypelinksApi | cells_hypelinks_post_worksheet_hyperlink | POST /cells/{name}/worksheets/{sheetName}/hyperlinks/{hyperlinkIndex} | Update worksheet hyperlink by index. CellsHypelinksApi | cells_hypelinks_put_worksheet_hyperlink | PUT /cells/{name}/worksheets/{sheetName}/hyperlinks | Add worksheet hyperlink. CellsListObjectsApi | cells_list_objects_delete_worksheet_list_object | DELETE /cells/{name}/worksheets/{sheetName}/listobjects/{listObjectIndex} | Delete worksheet list object by index CellsListObjectsApi | cells_list_objects_delete_worksheet_list_objects | DELETE /cells/{name}/worksheets/{sheetName}/listobjects | Delete worksheet list objects CellsListObjectsApi | cells_list_objects_get_worksheet_list_object | GET /cells/{name}/worksheets/{sheetName}/listobjects/{listobjectindex} | Get worksheet list object info by index. CellsListObjectsApi | cells_list_objects_get_worksheet_list_objects | GET /cells/{name}/worksheets/{sheetName}/listobjects | Get worksheet listobjects info. CellsListObjectsApi | cells_list_objects_post_worksheet_list_object | POST /cells/{name}/worksheets/{sheetName}/listobjects/{listObjectIndex} | Update list object CellsListObjectsApi | cells_list_objects_post_worksheet_list_object_convert_to_range | POST /cells/{name}/worksheets/{sheetName}/listobjects/{listObjectIndex}/ConvertToRange | CellsListObjectsApi | cells_list_objects_post_worksheet_list_object_sort_table | POST /cells/{name}/worksheets/{sheetName}/listobjects/{listObjectIndex}/sort | CellsListObjectsApi | cells_list_objects_post_worksheet_list_object_summarize_with_pivot_table | POST /cells/{name}/worksheets/{sheetName}/listobjects/{listObjectIndex}/SummarizeWithPivotTable | CellsListObjectsApi | cells_list_objects_put_worksheet_list_object | PUT /cells/{name}/worksheets/{sheetName}/listobjects | Add a list object into worksheet. CellsOleObjectsApi | cells_ole_objects_delete_worksheet_ole_object | DELETE /cells/{name}/worksheets/{sheetName}/oleobjects/{oleObjectIndex} | Delete OLE object. CellsOleObjectsApi | cells_ole_objects_delete_worksheet_ole_objects | DELETE /cells/{name}/worksheets/{sheetName}/oleobjects | Delete all OLE objects. CellsOleObjectsApi | cells_ole_objects_get_worksheet_ole_object | GET /cells/{name}/worksheets/{sheetName}/oleobjects/{objectNumber} | Get OLE object info. CellsOleObjectsApi | cells_ole_objects_get_worksheet_ole_objects | GET /cells/{name}/worksheets/{sheetName}/oleobjects | Get worksheet OLE objects info. CellsOleObjectsApi | cells_ole_objects_post_update_worksheet_ole_object | POST /cells/{name}/worksheets/{sheetName}/oleobjects/{oleObjectIndex} | Update OLE object. CellsOleObjectsApi | cells_ole_objects_put_worksheet_ole_object | PUT /cells/{name}/worksheets/{sheetName}/oleobjects | Add OLE object CellsPageBreaksApi | cells_page_breaks_delete_horizontal_page_break | DELETE /cells/{name}/worksheets/{sheetName}/horizontalpagebreaks/{index} | CellsPageBreaksApi | cells_page_breaks_delete_horizontal_page_breaks | DELETE /cells/{name}/worksheets/{sheetName}/horizontalpagebreaks | CellsPageBreaksApi | cells_page_breaks_delete_vertical_page_break | DELETE /cells/{name}/worksheets/{sheetName}/verticalpagebreaks/{index} | CellsPageBreaksApi | cells_page_breaks_delete_vertical_page_breaks | DELETE /cells/{name}/worksheets/{sheetName}/verticalpagebreaks | CellsPageBreaksApi | cells_page_breaks_get_horizontal_page_break | GET /cells/{name}/worksheets/{sheetName}/horizontalpagebreaks/{index} | CellsPageBreaksApi | cells_page_breaks_get_horizontal_page_breaks | GET /cells/{name}/worksheets/{sheetName}/horizontalpagebreaks | CellsPageBreaksApi | cells_page_breaks_get_vertical_page_break | GET /cells/{name}/worksheets/{sheetName}/verticalpagebreaks/{index} | CellsPageBreaksApi | cells_page_breaks_get_vertical_page_breaks | GET /cells/{name}/worksheets/{sheetName}/verticalpagebreaks | CellsPageBreaksApi | cells_page_breaks_put_horizontal_page_break | PUT /cells/{name}/worksheets/{sheetName}/horizontalpagebreaks | CellsPageBreaksApi | cells_page_breaks_put_vertical_page_break | PUT /cells/{name}/worksheets/{sheetName}/verticalpagebreaks | CellsPageSetupApi | cells_page_setup_delete_header_footer | DELETE /cells/{name}/worksheets/{sheetName}/pagesetup/clearheaderfooter | clear header footer CellsPageSetupApi | cells_page_setup_get_footer | GET /cells/{name}/worksheets/{sheetName}/pagesetup/footer | get page footer information CellsPageSetupApi | cells_page_setup_get_header | GET /cells/{name}/worksheets/{sheetName}/pagesetup/header | get page header information CellsPageSetupApi | cells_page_setup_get_page_setup | GET /cells/{name}/worksheets/{sheetName}/pagesetup | Get Page Setup information.
CellsPageSetupApi | cells_page_setup_post_footer | POST /cells/{name}/worksheets/{sheetName}/pagesetup/footer | update page footer information CellsPageSetupApi | cells_page_setup_post_header | POST /cells/{name}/worksheets/{sheetName}/pagesetup/header | update page header information CellsPageSetupApi | cells_page_setup_post_page_setup | POST /cells/{name}/worksheets/{sheetName}/pagesetup | Update Page Setup information. CellsPicturesApi | cells_pictures_delete_worksheet_picture | DELETE /cells/{name}/worksheets/{sheetName}/pictures/{pictureIndex} | Delete a picture object in worksheet CellsPicturesApi | cells_pictures_delete_worksheet_pictures | DELETE /cells/{name}/worksheets/{sheetName}/pictures | Delete all pictures in worksheet. CellsPicturesApi | cells_pictures_get_worksheet_picture | GET /cells/{name}/worksheets/{sheetName}/pictures/{pictureIndex} | GRead worksheet picture by number. CellsPicturesApi | cells_pictures_get_worksheet_pictures | GET /cells/{name}/worksheets/{sheetName}/pictures | Read worksheet pictures. CellsPicturesApi | cells_pictures_post_worksheet_picture | POST /cells/{name}/worksheets/{sheetName}/pictures/{pictureIndex} | Update worksheet picture by index. CellsPicturesApi | cells_pictures_put_worksheet_add_picture | PUT /cells/{name}/worksheets/{sheetName}/pictures | Add a new worksheet picture. CellsPivotTablesApi | cells_pivot_tables_delete_pivot_table_field | DELETE /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotField | Delete pivot field into into pivot table CellsPivotTablesApi | cells_pivot_tables_delete_worksheet_pivot_table | DELETE /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex} | Delete worksheet pivot table by index CellsPivotTablesApi | cells_pivot_tables_delete_worksheet_pivot_table_filter | DELETE /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotFilters/{fieldIndex} | delete pivot filter for piovt table
CellsPivotTablesApi | cells_pivot_tables_delete_worksheet_pivot_table_filters | DELETE /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotFilters | delete all pivot filters for piovt table CellsPivotTablesApi | cells_pivot_tables_delete_worksheet_pivot_tables | DELETE /cells/{name}/worksheets/{sheetName}/pivottables | Delete worksheet pivot tables CellsPivotTablesApi | cells_pivot_tables_get_pivot_table_field | GET /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotField | Get pivot field into into pivot table CellsPivotTablesApi | cells_pivot_tables_get_worksheet_pivot_table | GET /cells/{name}/worksheets/{sheetName}/pivottables/{pivottableIndex} | Get worksheet pivottable info by index. CellsPivotTablesApi | cells_pivot_tables_get_worksheet_pivot_table_filter | GET /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotFilters/{filterIndex} | CellsPivotTablesApi | cells_pivot_tables_get_worksheet_pivot_table_filters | GET /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotFilters | CellsPivotTablesApi | cells_pivot_tables_get_worksheet_pivot_tables | GET /cells/{name}/worksheets/{sheetName}/pivottables | Get worksheet pivottables info. CellsPivotTablesApi | cells_pivot_tables_post_pivot_table_cell_style | POST /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/Format | Update cell style for pivot table CellsPivotTablesApi | cells_pivot_tables_post_pivot_table_field_hide_item | POST /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotField/Hide | CellsPivotTablesApi | cells_pivot_tables_post_pivot_table_field_move_to | POST /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotField/Move | CellsPivotTablesApi | cells_pivot_tables_post_pivot_table_style | POST /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/FormatAll | Update style for pivot table CellsPivotTablesApi | cells_pivot_tables_post_worksheet_pivot_table_calculate | POST /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/Calculate | Calculates pivottable's data to cells. CellsPivotTablesApi | cells_pivot_tables_post_worksheet_pivot_table_move | POST /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/Move | CellsPivotTablesApi | cells_pivot_tables_put_pivot_table_field | PUT /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotField | Add pivot field into into pivot table CellsPivotTablesApi | cells_pivot_tables_put_worksheet_pivot_table | PUT /cells/{name}/worksheets/{sheetName}/pivottables | Add a pivot table into worksheet. CellsPivotTablesApi | cells_pivot_tables_put_worksheet_pivot_table_filter | PUT /cells/{name}/worksheets/{sheetName}/pivottables/{pivotTableIndex}/PivotFilters | Add pivot filter for piovt table index CellsPropertiesApi | cells_properties_delete_document_properties | DELETE /cells/{name}/documentproperties | Delete all custom document properties and clean built-in ones. CellsPropertiesApi | cells_properties_delete_document_property | DELETE /cells/{name}/documentproperties/{propertyName} | Delete document property. CellsPropertiesApi | cells_properties_get_document_properties | GET /cells/{name}/documentproperties | Read document properties. CellsPropertiesApi | cells_properties_get_document_property | GET /cells/{name}/documentproperties/{propertyName} | Read document property by name. CellsPropertiesApi | cells_properties_put_document_property | PUT /cells/{name}/documentproperties/{propertyName} | Set/create document property. CellsRangesApi | cells_ranges_get_worksheet_cells_range_value | GET /cells/{name}/worksheets/{sheetName}/ranges/value | Get cells list in a range by range name or row column indexes
CellsRangesApi | cells_ranges_post_worksheet_cells_range_column_width | POST /cells/{name}/worksheets/{sheetName}/ranges/columnWidth | Set column width of range CellsRangesApi | cells_ranges_post_worksheet_cells_range_merge | POST /cells/{name}/worksheets/{sheetName}/ranges/merge | Combines a range of cells into a single cell.
CellsRangesApi | cells_ranges_post_worksheet_cells_range_move_to | POST /cells/{name}/worksheets/{sheetName}/ranges/moveto | Move the current range to the dest range.
CellsRangesApi | cells_ranges_post_worksheet_cells_range_outline_border | POST /cells/{name}/worksheets/{sheetName}/ranges/outlineBorder | Sets outline border around a range of cells. CellsRangesApi | cells_ranges_post_worksheet_cells_range_row_height | POST /cells/{name}/worksheets/{sheetName}/ranges/rowHeight | set row height of range CellsRangesApi | cells_ranges_post_worksheet_cells_range_style | POST /cells/{name}/worksheets/{sheetName}/ranges/style | Sets the style of the range.
CellsRangesApi | cells_ranges_post_worksheet_cells_range_unmerge | POST /cells/{name}/worksheets/{sheetName}/ranges/unmerge | Unmerges merged cells of this range.
CellsRangesApi | cells_ranges_post_worksheet_cells_range_value | POST /cells/{name}/worksheets/{sheetName}/ranges/value | Puts a value into the range, if appropriate the value will be converted to other data type and cell's number format will be reset.
CellsRangesApi | cells_ranges_post_worksheet_cells_ranges | POST /cells/{name}/worksheets/{sheetName}/ranges | copy range in the worksheet CellsSaveAsApi | cells_save_as_post_document_save_as | POST /cells/{name}/SaveAs | Convert document and save result to storage. CellsShapesApi | cells_shapes_delete_worksheet_shape | DELETE /cells/{name}/worksheets/{sheetName}/shapes/{shapeindex} | Delete a shape in worksheet CellsShapesApi | cells_shapes_delete_worksheet_shapes | DELETE /cells/{name}/worksheets/{sheetName}/shapes | delete all shapes in worksheet CellsShapesApi | cells_shapes_get_worksheet_shape | GET /cells/{name}/worksheets/{sheetName}/shapes/{shapeindex} | Get worksheet shape CellsShapesApi | cells_shapes_get_worksheet_shapes | GET /cells/{name}/worksheets/{sheetName}/shapes | Get worksheet shapes CellsShapesApi | cells_shapes_post_worksheet_shape | POST /cells/{name}/worksheets/{sheetName}/shapes/{shapeindex} | Update a shape in worksheet CellsShapesApi | cells_shapes_put_worksheet_shape | PUT /cells/{name}/worksheets/{sheetName}/shapes | Add shape in worksheet CellsTaskApi | cells_task_post_run_task | POST /cells/task/runtask | Run tasks
CellsWorkbookApi | cells_workbook_delete_decrypt_document | DELETE /cells/{name}/encryption | Decrypt document. CellsWorkbookApi | cells_workbook_delete_document_unprotect_from_changes | DELETE /cells/{name}/writeProtection | Unprotect document from changes. CellsWorkbookApi | cells_workbook_delete_unprotect_document | DELETE /cells/{name}/protection | Unprotect document. CellsWorkbookApi | cells_workbook_delete_workbook_name | DELETE /cells/{name}/names/{nameName} | Clean workbook's names. CellsWorkbookApi | cells_workbook_delete_workbook_names | DELETE /cells/{name}/names | Clean workbook's names. CellsWorkbookApi | cells_workbook_get_workbook | GET /cells/{name} | Read workbook info or export. CellsWorkbookApi | cells_workbook_get_workbook_default_style | GET /cells/{name}/defaultstyle | Read workbook default style info. CellsWorkbookApi | cells_workbook_get_workbook_name | GET /cells/{name}/names/{nameName} | Read workbook's name. CellsWorkbookApi | cells_workbook_get_workbook_name_value | GET /cells/{name}/names/{nameName}/value | Get workbook's name value. CellsWorkbookApi | cells_workbook_get_workbook_names | GET /cells/{name}/names | Read workbook's names. CellsWorkbookApi | cells_workbook_get_workbook_settings | GET /cells/{name}/settings | Get Workbook Settings DTO CellsWorkbookApi | cells_workbook_get_workbook_text_items | GET /cells/{name}/textItems | Read workbook's text items. CellsWorkbookApi | cells_workbook_post_autofit_workbook_rows | POST /cells/{name}/autofitrows | Autofit workbook rows. CellsWorkbookApi | cells_workbook_post_encrypt_document | POST /cells/{name}/encryption | Encript document. CellsWorkbookApi | cells_workbook_post_import_data | POST /cells/{name}/importdata | CellsWorkbookApi | cells_workbook_post_protect_document | POST /cells/{name}/protection | Protect document. CellsWorkbookApi | cells_workbook_post_workbook_calculate_formula | POST /cells/{name}/calculateformula | Calculate all formulas in workbook. CellsWorkbookApi | cells_workbook_post_workbook_get_smart_marker_result | POST /cells/{name}/smartmarker | Smart marker processing result. CellsWorkbookApi | cells_workbook_post_workbook_settings | POST /cells/{name}/settings | Update Workbook setting CellsWorkbookApi | cells_workbook_post_workbook_split | POST /cells/{name}/split | Split workbook. CellsWorkbookApi | cells_workbook_post_workbooks_merge | POST /cells/{name}/merge | Merge workbooks. CellsWorkbookApi | cells_workbook_post_workbooks_text_replace | POST /cells/{name}/replaceText | Replace text. CellsWorkbookApi | cells_workbook_post_workbooks_text_search | POST /cells/{name}/findText | Search text. CellsWorkbookApi | cells_workbook_put_convert_workbook | PUT /cells/convert | Convert workbook from request content to some format. CellsWorkbookApi | cells_workbook_put_document_protect_from_changes | PUT /cells/{name}/writeProtection | Protect document from changes. CellsWorkbookApi | cells_workbook_put_workbook_create | PUT /cells/{name} | Create new workbook using deferent methods. CellsWorksheetValidationsApi | cells_worksheet_validations_delete_worksheet_validation | DELETE /cells/{name}/worksheets/{sheetName}/validations/{validationIndex} | Delete worksheet validation by index. CellsWorksheetValidationsApi | cells_worksheet_validations_get_worksheet_validation | GET /cells/{name}/worksheets/{sheetName}/validations/{validationIndex} | Get worksheet validation by index. CellsWorksheetValidationsApi | cells_worksheet_validations_get_worksheet_validations | GET /cells/{name}/worksheets/{sheetName}/validations | Get worksheet validations. CellsWorksheetValidationsApi | cells_worksheet_validations_post_worksheet_validation | POST /cells/{name}/worksheets/{sheetName}/validations/{validationIndex} | Update worksheet validation by index. CellsWorksheetValidationsApi | cells_worksheet_validations_put_worksheet_validation | PUT /cells/{name}/worksheets/{sheetName}/validations | Add worksheet validation at index. CellsWorksheetsApi | cells_worksheets_delete_unprotect_worksheet | DELETE /cells/{name}/worksheets/{sheetName}/protection | Unprotect worksheet. CellsWorksheetsApi | cells_worksheets_delete_worksheet | DELETE /cells/{name}/worksheets/{sheetName} | Delete worksheet. CellsWorksheetsApi | cells_worksheets_delete_worksheet_background | DELETE /cells/{name}/worksheets/{sheetName}/background | Set worksheet background image. CellsWorksheetsApi | cells_worksheets_delete_worksheet_comment | DELETE /cells/{name}/worksheets/{sheetName}/comments/{cellName} | Delete worksheet's cell comment. CellsWorksheetsApi | cells_worksheets_delete_worksheet_comments | DELETE /cells/{name}/worksheets/{sheetName}/comments | Delete all comments for worksheet. CellsWorksheetsApi | cells_worksheets_delete_worksheet_freeze_panes | DELETE /cells/{name}/worksheets/{sheetName}/freezepanes | Unfreeze panes CellsWorksheetsApi | cells_worksheets_get_named_ranges | GET /cells/{name}/worksheets/ranges | Read worksheets ranges info. CellsWorksheetsApi | cells_worksheets_get_worksheet | GET /cells/{name}/worksheets/{sheetName} | Read worksheet info or export. CellsWorksheetsApi | cells_worksheets_get_worksheet_calculate_formula | GET /cells/{name}/worksheets/{sheetName}/formulaResult | Calculate formula value. CellsWorksheetsApi | cells_worksheets_get_worksheet_comment | GET /cells/{name}/worksheets/{sheetName}/comments/{cellName} | Get worksheet comment by cell name. CellsWorksheetsApi | cells_worksheets_get_worksheet_comments | GET /cells/{name}/worksheets/{sheetName}/comments | Get worksheet comments. CellsWorksheetsApi | cells_worksheets_get_worksheet_merged_cell | GET /cells/{name}/worksheets/{sheetName}/mergedCells/{mergedCellIndex} | Get worksheet merged cell by its index. CellsWorksheetsApi | cells_worksheets_get_worksheet_merged_cells | GET /cells/{name}/worksheets/{sheetName}/mergedCells | Get worksheet merged cells. CellsWorksheetsApi | cells_worksheets_get_worksheet_text_items | GET /cells/{name}/worksheets/{sheetName}/textItems | Get worksheet text items. CellsWorksheetsApi | cells_worksheets_get_worksheets | GET /cells/{name}/worksheets | Read worksheets info. CellsWorksheetsApi | cells_worksheets_post_autofit_worksheet_columns | POST /cells/{name}/worksheets/{sheetName}/autofitcolumns | CellsWorksheetsApi | cells_worksheets_post_autofit_worksheet_row | POST /cells/{name}/worksheets/{sheetName}/autofitrow | CellsWorksheetsApi | cells_worksheets_post_autofit_worksheet_rows | POST /cells/{name}/worksheets/{sheetName}/autofitrows | Autofit worksheet rows. CellsWorksheetsApi | cells_worksheets_post_copy_worksheet | POST /cells/{name}/worksheets/{sheetName}/copy | CellsWorksheetsApi | cells_worksheets_post_move_worksheet | POST /cells/{name}/worksheets/{sheetName}/position | Move worksheet. CellsWorksheetsApi | cells_worksheets_post_rename_worksheet | POST /cells/{name}/worksheets/{sheetName}/rename | Rename worksheet CellsWorksheetsApi | cells_worksheets_post_update_worksheet_property | POST /cells/{name}/worksheets/{sheetName} | Update worksheet property CellsWorksheetsApi | cells_worksheets_post_update_worksheet_zoom | POST /cells/{name}/worksheets/{sheetName}/zoom | CellsWorksheetsApi | cells_worksheets_post_worksheet_comment | POST /cells/{name}/worksheets/{sheetName}/comments/{cellName} | Update worksheet's cell comment. CellsWorksheetsApi | cells_worksheets_post_worksheet_range_sort | POST /cells/{name}/worksheets/{sheetName}/sort | Sort worksheet range. CellsWorksheetsApi | cells_worksheets_post_worksheet_text_search | POST /cells/{name}/worksheets/{sheetName}/findText | Search text. CellsWorksheetsApi | cells_worksheets_post_worsheet_text_replace | POST /cells/{name}/worksheets/{sheetName}/replaceText | Replace text. CellsWorksheetsApi | cells_worksheets_put_add_new_worksheet | PUT /cells/{name}/worksheets/{sheetName} | Add new worksheet. CellsWorksheetsApi | cells_worksheets_put_change_visibility_worksheet | PUT /cells/{name}/worksheets/{sheetName}/visible | Change worksheet visibility. CellsWorksheetsApi | cells_worksheets_put_protect_worksheet | PUT /cells/{name}/worksheets/{sheetName}/protection | Protect worksheet. CellsWorksheetsApi | cells_worksheets_put_worksheet_background | PUT /cells/{name}/worksheets/{sheetName}/background | Set worksheet background image. CellsWorksheetsApi | cells_worksheets_put_worksheet_comment | PUT /cells/{name}/worksheets/{sheetName}/comments/{cellName} | Add worksheet's cell comment. CellsWorksheetsApi | cells_worksheets_put_worksheet_freeze_panes | PUT /cells/{name}/worksheets/{sheetName}/freezepanes | Set freeze panes OAuthApi | o_auth_post | POST /oauth2/token | Get Access token

DOCUMENTATION FOR MODELS

DOCUMENTATION FOR AUTHORIZATION

appsid

oauth

signature