AsposeCellsCloud-CellsApi
view release on metacpan - search on metacpan
view release on metacpan or search on metacpan
docs/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/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/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/AddPictureInCellRequest.md view on Meta::CPAN
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**name** | **string** | |
**sheet_name** | **string** | |
**cell_name** | **string** | |
**picture_path** | **string** | |
**folder** | **string** | |
**storage_name** | **string** | |
[[Back to Model list]](../README.md#documentation-for-requests) [[Back to API list]](../README.md#documentation-for-api-endpoints) [[Back to README]](../README.md)
docs/AddTextOptions.md view on Meta::CPAN
**Name** | **string** | The class has a public property named "Name" with a getter and setter method. |
**DataSource** | **DataSource** | |
**FileInfo** | **FileInfo** | |
**Text** | **string** | |
**Worksheet** | **string** | |
**Range** | **string** | |
**SelectPoistion** | **string** | |
**SelectText** | **string** | |
**SkipEmptyCells** | **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/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/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/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/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/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/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/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/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/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/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/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/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/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/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/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/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/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/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/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/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/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/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/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/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/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)
view release on metacpan - search on metacpan
( run in 0.783 second using v1.00-cache-2.02-grep-82fe00e-cpan-4673cadbf75 )