AsposeCellsCloud-CellsApi
view release on metacpan or search on metacpan
docs/model/AboveAverage.md view on Meta::CPAN
use AsposeCellsCloud::Object::AboveAverage;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**IsAboveAverage** | **boolean** | Get or set the flag indicating whether the rule is an "above average" rule. 'true' indicates 'above average'. Default value is true. |
**IsEqualAverage** | **boolean** | Get or set the flag indicating whether the 'aboveAverage' and 'belowAverage' criteria is inclusive of the average itself, or exclusive of that value. 'true' indicates to include the average v...
**StdDev** | **int** | Get or set the number of standard deviations to include above or below the average in the conditional formatting rule. The input value must between 0 and 3 (include 0 and 3). Setting this valu...
[[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/model/AbstractCalculationEngine.md view on Meta::CPAN
use AsposeCellsCloud::Object::AbstractCalculationEngine;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**IsParamLiteralRequired** | **boolean** | Indicates whether this engine needs the literal text of parameter while doing calculation. Default value is false. |
**IsParamArrayModeRequired** | **boolean** | Indicates whether this engine needs the parameter to be calculated in array mode. Default value is false. If is required when calculating custom functions, this property needs to be ...
**ProcessBuiltInFunctions** | **boolean** | Whether built-in functions that have been supported by the built-in engine should be checked and processed by this implementation. Default is false. If user needs to change ...
[[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/model/AbstractCalculationMonitor.md view on Meta::CPAN
use AsposeCellsCloud::Object::AbstractCalculationMonitor;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**OriginalValue** | **string** | Gets the old value of the calculated cell. Should be used only in and . |
**ValueChanged** | **boolean** | Whether the cell's value has been changed after the calculation. Should be used only in . |
**CalculatedValue** | **string** | Gets the newly calculated value of the cell. Should be used only in . |
[[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/model/AddTextOptions.md view on Meta::CPAN
------------ | ------------- | ------------- | -------------
**Name** | **string** | The class has a public property named "Name" with a getter and setter method. |
**DataSource** | **DataSource** | Represents data source. There are three types of data, they are CloudFileSystem, RequestFiles, HttpUri. |
**FileInfo** | **FileInfo** | Represents file information. Include of filename, filesize, and file content(base64String). |
**ScopeOptions** | **ScopeOptions** | Specifies the range of cells within the worksheet where the spreadsheet operations will be performed. This parameter allows users to define the exact area to be processed, ensuring that operations are applied onl...
**Text** | **string** | Add text content. |
**SelectPoistion** | **string** | Represents where text should be inserted or selected in the spreadsheet. |
**SelectText** | **string** | Selected text of cell where text should be inserted or selected in the spreadsheet. |
**SkipEmptyCells** | **boolean** | Indicates whether empty cells should be skipped during processing. |
[[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/model/AnalyzeExcelRequest.md view on Meta::CPAN
use AsposeCellsCloud::Object::AnalyzeExcelRequest;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**Files** | **ARRAY[FileInfo]** | The class has a property called "Files" that is a list of FileInfo objects with a default value of an empty list. |
**NeedThumbnail** | **boolean** | |
**BuildSuggestoinSheet** | **boolean** | |
[[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/model/AnalyzedColumnDescription.md view on Meta::CPAN
**Index** | **int** | Column index. |
**ColumnIndex** | **int** | The true position index value of the column. |
**Title** | **string** | This class has a public property "Title" of type string with a default value of an empty string. |
**RepetitionRate** | **double** | When the repetition rate is high, can it be viewed as a group display? |
**ColumnDataDataType** | **string** | The column type is identified, and the attributes of the column are determined after data analysis. |
**NumberCategoryType** | **string** | |
**TextCategoryType** | **string** | |
**StyleNumber** | **int** | |
**columnDataExceptionDescription** | **string** | Column data exception description. |
[[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/model/AnalyzedResult.md view on Meta::CPAN
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**Filename** | **string** | Represents the file name of data file. |
**Description** | **string** | Represents summary about results of analyzed data. |
**BasicStatistics** | **ExcelDataStatistics** | Represents Excel data statistics. |
**Results** | **ARRAY[AnalyzedTableDescription]** | Represents analyzed table description. |
**SuggestedFile** | **string** | base64String Excel file |
[[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/model/AnalyzedTableDescription.md view on Meta::CPAN
**HasTableHeaderRow** | **boolean** | Represents there is a table header in the table. |
**HasTableTotalRow** | **boolean** | Represents there is a total row in the table. |
**StartDataColumnIndex** | **int** | Represents the column index as the start data column. |
**EndDataColumnIndex** | **int** | Represents the column index as the end data column. |
**StartDataRowIndex** | **int** | Represents the row index as the start data row. |
**EndDataRowIndex** | **int** | Represents the row index as the end data row. |
**Thumbnail** | **string** | Represents table thumbnail. Base64String |
**DiscoverCharts** | **ARRAY[DiscoverChart]** | Represents a collection of charts, which is a collection of charts created based on data analysis of a table. |
**DiscoverPivotTables** | **ARRAY[DiscoverPivotTable]** | Represents a collection of pivot tables, which is a collection of pivot tables created based on data analysis of a table. |
[[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/model/AppliedOperate.md view on Meta::CPAN
## Load the model package
```perl
use AsposeCellsCloud::Object::AppliedOperate;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**AppliedOperateType** | **string** | Property summary: Utilizes a custom JSON converter to serialize and deserialize an enum property. |
[[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/model/AppliedStep.md view on Meta::CPAN
```perl
use AsposeCellsCloud::Object::AppliedStep;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**StepName** | **string** | Data manipulation step name. |
**AppliedOperate** | **AppliedOperate** | Data manipulation name. |
[[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/model/ArcShape.md view on Meta::CPAN
**IsLocked** | **boolean** | |
**IsPrintable** | **boolean** | |
**IsTextWrapped** | **boolean** | |
**IsWordArt** | **boolean** | |
**LinkedCell** | **string** | |
**ZOrderPosition** | **int** | |
**Font** | **Font** | |
**Hyperlink** | **string** | |
**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/model/ArcShapeResponse.md view on Meta::CPAN
use AsposeCellsCloud::Object::ArcShapeResponse;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**Shape** | **ArcShape** | A public property Shape of type ArcShape that can be accessed and modified. |
**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/model/Area.md view on Meta::CPAN
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**BackgroundColor** | **Color** | Gets or sets the background of the . |
**FillFormat** | **FillFormat** | Represents a object that contains fill formatting properties for the specified chart or shape. |
**ForegroundColor** | **Color** | Gets or sets the foreground . |
**Format** | **string** | This class has a property named "Format" of type string with both getter and setter methods. |
**InvertIfNegative** | **boolean** | If the property is true and the value of chart point is a negative number, the foreground color and background color will be exchanged. |
**Transparency** | **double** | Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear). |
[[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/model/AutoFilter.md view on Meta::CPAN
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**FilterColumns** | **ARRAY[FilterColumn]** | Gets the collection of the filter columns. |
**Range** | **string** | Represents the range to which the specified AutoFilter applies. |
**Sorter** | **DataSorter** | Gets the data sorter. |
**ShowFilterButton** | **boolean** | Indicates whether the AutoFilter button for this column 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/model/AutoFilterResponse.md view on Meta::CPAN
use AsposeCellsCloud::Object::AutoFilterResponse;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**AutoFilter** | **AutoFilter** | A property named "AutoFilter" with a type of "AutoFilter" that can be read from and written to. |
**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/model/AutoFitterOptions.md view on Meta::CPAN
------------ | ------------- | ------------- | -------------
**AutoFitMergedCellsType** | **string** | Gets and set the type of auto fitting row height of merged cells. |
**IgnoreHidden** | **boolean** | Ignores the hidden rows/columns. |
**OnlyAuto** | **boolean** | Indicates whether only fit the rows which height are not customed. |
**DefaultEditLanguage** | **string** | Gets or sets default edit language. |
**MaxRowHeight** | **double** | Gets and sets the max row height(in unit of Point) when autofitting rows. |
**AutoFitWrappedTextType** | **string** | Gets and sets the type of auto fitting wrapped text. |
**FormatStrategy** | **string** | Gets and sets the formatted strategy. |
**ForRendering** | **boolean** | Indicates whether fit for rendering purpose. |
[[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/model/AutoShape.md view on Meta::CPAN
**IsLocked** | **boolean** | |
**IsPrintable** | **boolean** | |
**IsTextWrapped** | **boolean** | |
**IsWordArt** | **boolean** | |
**LinkedCell** | **string** | |
**ZOrderPosition** | **int** | |
**Font** | **Font** | |
**Hyperlink** | **string** | |
**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/model/AutoShapeResponse.md view on Meta::CPAN
use AsposeCellsCloud::Object::AutoShapeResponse;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**AutoShape** | **AutoShape** | A public property named "AutoShape" of type "AutoShape" with both getter and setter methods. |
**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/model/AutoShapes.md view on Meta::CPAN
```perl
use AsposeCellsCloud::Object::AutoShapes;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**AutoShapeList** | **ARRAY[LinkElement]** | Property Summary: Contains a list of LinkElement objects identified by the XML element "autoshape". |
**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/model/AutoShapesResponse.md view on Meta::CPAN
use AsposeCellsCloud::Object::AutoShapesResponse;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**AutoShapes** | **AutoShapes** | The class has a property named "AutoShapes" decorated with the XmlElement attribute "shapes". |
**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/model/Axis.md view on Meta::CPAN
**MinorUnit** | **double** | Represents the minor units for the axis. |
**MinorUnitScale** | **string** | Represents the major unit scale for the category axis. |
**MinValue** | **double** | Represents the minimum value on the value axis. |
**TickLabelPosition** | **string** | Represents the position of tick-mark labels on the specified axis. |
**TickLabels** | **TickLabels** | Returns a object that represents the tick-mark labels for the specified axis. |
**TickLabelSpacing** | **int** | Represents the number of categories or series between tick-mark labels. Applies only to category and series axes. |
**TickMarkSpacing** | **int** | Returns or sets the number of categories or series between tick marks. Applies only to category and series axes. |
**Title** | **Title** | Gets the axis' title. |
**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/model/AxisResponse.md view on Meta::CPAN
use AsposeCellsCloud::Object::AxisResponse;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**Axis** | **Axis** | A property named "Axis" of type "Axis" with both getter and setter methods is present in the class. |
**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/model/BaseOperateOptions.md view on Meta::CPAN
## Load the model package
```perl
use AsposeCellsCloud::Object::BaseOperateOptions;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**Name** | **string** | The property "Name" is a virtual string type with a public access modifier and a default value of an empty 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/model/BatchConvertRequest.md view on Meta::CPAN
**SourceStorage** | **string** | Aspose Cloud storage name. |
**MatchCondition** | **MatchConditionRequest** | Indicates the match condition that needs to be processed for the file name. |
**Format** | **string** | Conversion format. |
**OutFolder** | **string** | The directory that stores files whose format conversion was successful. |
**OutStorage** | **string** | Aspose Cloud storage name. |
**Region** | **string** | The regional settings for workbook. |
**PageWideFitOnPerSheet** | **boolean** | A nullable Boolean property that determines whether the content should be fit to the entire page width on each sheet. |
**PageTallFitOnPerSheet** | **boolean** | |
**SaveOptions** | **SaveOptions** | Indicates save options. |
[[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/model/BatchLockRequest.md view on Meta::CPAN
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**SourceFolder** | **string** | The directory stores files that need to format conversion. |
**SourceStorage** | **string** | Aspose Cloud storage name |
**MatchCondition** | **MatchConditionRequest** | Indicates the match condition that needs to be processed for the file name. |
**Password** | **string** | Lock file with password |
**OutFolder** | **string** | The directory that stores files whose format conversion was successful. |
**OutStorage** | **string** | Aspose Cloud storage name |
[[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/model/BatchProtectRequest.md view on Meta::CPAN
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**SourceFolder** | **string** | The directory stores files that need to format conversion. |
**SourceStorage** | **string** | Aspose Cloud storage name |
**MatchCondition** | **MatchConditionRequest** | Indicates the match condition that needs to be processed for the file name. |
**ProtectionType** | **string** | This property defines the protection type of an object. |
**Password** | **string** | |
**OutFolder** | **string** | The directory that stores files whose format conversion was successful. |
**OutStorage** | **string** | Aspose Cloud storage name. |
[[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/model/BatchSplitRequest.md view on Meta::CPAN
**SourceStorage** | **string** | Aspose Cloud storage name |
**MatchCondition** | **MatchConditionRequest** | Indicates the match condition that needs to be processed for the file name. |
**Format** | **string** | Output file format |
**FromIndex** | **int** | From worksheet index of workbook. |
**ToIndex** | **int** | To worksheet index of workbook. |
**OutFolder** | **string** | The directory that stores files whose format conversion was successful. |
**OutStorage** | **string** | Aspose Cloud storage name. |
**Region** | **string** | The regional settings for workbook. |
**SaveOptions** | **SaveOptions** | Indicates save options. |
[[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/model/Border.md view on Meta::CPAN
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**LineStyle** | **string** | Gets or sets the cell border type. |
**Color** | **Color** | Gets or sets the of the border. |
**BorderType** | **string** | This class has a property called "BorderType" of type string that can be both get and set. |
**ThemeColor** | **ThemeColor** | Gets and sets the theme color of the border. |
**ArgbColor** | **int** | Gets and sets the color with a 32-bit ARGB value. |
[[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/model/BorderResponse.md view on Meta::CPAN
use AsposeCellsCloud::Object::BorderResponse;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**Border** | **Border** | This class has a public property named Border of type Border that can be both read from and written to. |
**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/model/BrokenLink.md view on Meta::CPAN
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**Filename** | **string** | |
**Worksheet** | **string** | |
**Position** | **string** | |
**LinkAddress** | **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)
( run in 0.734 second using v1.01-cache-2.11-cpan-c0c260db3f6 )