AsposeCellsCloud-CellsApi
view release on metacpan or search on metacpan
|[AZW3](https://docs.fileformat.com/ebook/azw3/)|AZ3/KF8 File Format|Â |√|
|[EPUB](https://docs.fileformat.com/ebook/epub/)|EPUB File Format|Â |√|
|[DBF](https://docs.fileformat.com/ebook/epub/)|DBF File Format|Â |√|
|[EPUB](https://docs.fileformat.com/database/dbf/)|database file|Â |√|
|[XHTML](https://docs.fileformat.com/web/xhtml/)|XHTML File Format|Â |√|
## Manipulate Excel and other spreadsheet files in the Cloud
- File Manipulation: Users can upload, download, delete, and manage Excel files stored in the cloud.
- Formatting: Supports formatting of cells, fonts, colors, and alignment modes in Excel files to cater to users' specific requirements.
- Data Processing: Powerful functions for data processing including reading, writing, modifying cell data, performing formula calculations, and formatting data.
- Formula Calculation: Built-in formula engine handles complex formula calculations in Excel and returns accurate results.
- Chart Manipulation: Users can create, edit, and delete charts from Excel files for data analysis and visualization needs.
- Table Processing: Offers robust processing capabilities for various form operations such as creation, editing, formatting, and conversion, meeting diverse form processing needs.
- Data Verification: Includes data verification function to set cell data type, range, uniqueness, ensuring data accuracy and integrity.
- Batch Processing: Supports batch processing of multiple Excel documents, such as batch format conversion, data extraction, and style application..
- Import/Export: Facilitates importing data from various sources into spreadsheets and exporting spreadsheet data to other formats.
- Security Management: Offers a range of security features like data encryption, access control, and permission management to safeguard the security and integrity of spreadsheet data.
## Feature & Enhancements in Version v25.6.1
Full list of issues covering all changes in this release:
docs/api/CheckWorkbookFormulaErrors.md view on Meta::CPAN
## **Quick Start**
- **Base URL**: `http://api.aspose.cloud/v3.0`
- **Authentication Method**: `JWT (OAuth2, application)` **Token URL**: `https://api.aspose.cloud/connect/token`
## **Interface Details**
### **Endpoint**
```
POST http://api.aspose.cloud/v3.0/cells/checkformulaerrors
```
### **Function Description**
### The request parameters of **checkWorkbookFormulaErrors** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|formulaErrorOptions|Class|Body||
### **Response Description**
```json
{
"Name": "CheckedFormulaErrorsResponse",
"Description": [
""
],
"Type": "Class",
"ParentName": "CellsCloudResponse",
docs/api/GetWorksheetCalculateFormula.md view on Meta::CPAN
# **Spreadsheet Cloud API: getWorksheetCalculateFormula**
Calculate formula in the worksheet.
## **Quick Start**
- **Base URL**: `http://api.aspose.cloud/v3.0`
- **Authentication Method**: `JWT (OAuth2, application)` **Token URL**: `https://api.aspose.cloud/connect/token`
- **Example**
## **Interface Details**
### **Endpoint**
```
GET http://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/formulaResult
```
### **Function Description**
PageTitle: Calculate formula in the worksheet.PageDescription: Aspose.Cells Cloud provides robust support for calculating formula in the worksheet, a process known for its intricacy.HeadTitle: Calculate formula in the worksheet.HeadSummary: Aspose.Ce...
### The request parameters of **getWorksheetCalculateFormula** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The file name.|
|sheetName|String|Path|The worksheet name.|
|formula|String|Query|The formula.|
|folder|String|Query|The folder where the file is situated.|
|storageName|String|Query|The storage name where the file is situated.|
### **Response Description**
```json
{
"Name": "SingleValueResponse",
"Description": [
"Represents the SingleValue Response."
],
docs/api/PostCellCalculate.md view on Meta::CPAN
# **Spreadsheet Cloud API: postCellCalculate**
Calculate cell formula in the worksheet.
## **Quick Start**
- **Base URL**: `http://api.aspose.cloud/v3.0`
- **Authentication Method**: `JWT (OAuth2, application)` **Token URL**: `https://api.aspose.cloud/connect/token`
- **Example**
## **Interface Details**
### **Endpoint**
```
POST http://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/cells/{cellName}/calculate
```
### **Function Description**
PageTitle: Calculate cell formula in the worksheet.PageDescription: Aspose.Cells Cloud provides robust support for calculating cell formula in the worksheet, a process known for its intricacy.HeadTitle: Calculate cell formula in the worksheet.HeadSum...
### The request parameters of **postCellCalculate** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The file name.|
|sheetName|String|Path|The worksheet name.|
|cellName|String|Path|The cell name.|
|options|Class|Body|Calculation Options|
|folder|String|Query|The folder where the file is situated.|
docs/api/PostWorkbookCalculateFormula.md view on Meta::CPAN
# **Spreadsheet Cloud API: postWorkbookCalculateFormula**
Calculate all formulas in the workbook.
## **Quick Start**
- **Base URL**: `http://api.aspose.cloud/v3.0`
- **Authentication Method**: `JWT (OAuth2, application)` **Token URL**: `https://api.aspose.cloud/connect/token`
- **Example**
## **Interface Details**
### **Endpoint**
```
POST http://api.aspose.cloud/v3.0/cells/{name}/calculateformula
```
### **Function Description**
PageTitle: Calculate all formulas in the workbook.PageDescription: Aspose.Cells Cloud provides robust support for calculating all formulas in the workbook, a process known for its intricacy.HeadTitle: Calculate all formulas in the workbook.HeadSumma...
### The request parameters of **postWorkbookCalculateFormula** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The file name.|
|options|Class|Body|CalculationOptions Calculation Options.|
|ignoreError|Boolean|Query|ignore Error.|
|folder|String|Query|The folder where the file is situated.|
|storageName|String|Query|The storage name where the file is situated.|
docs/api/PostWorksheetCalculateFormula.md view on Meta::CPAN
# **Spreadsheet Cloud API: postWorksheetCalculateFormula**
Calculate formula in the worksheet.
## **Quick Start**
- **Base URL**: `http://api.aspose.cloud/v3.0`
- **Authentication Method**: `JWT (OAuth2, application)` **Token URL**: `https://api.aspose.cloud/connect/token`
- **Example**
## **Interface Details**
### **Endpoint**
```
POST http://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/calculateformula
```
### **Function Description**
PageTitle: Calculate formula in the worksheet.PageDescription: Aspose.Cells Cloud provides robust support for calculating formula in the worksheet, a process known for its intricacy.HeadTitle: Calculate formula in the worksheet.HeadSummary: Aspose.Ce...
### The request parameters of **postWorksheetCalculateFormula** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The file name.|
|sheetName|String|Path|Worksheet name.|
|formula|String|Query|The formula.|
|folder|String|Query|The folder where the file is situated.|
|storageName|String|Query|The storage name where the file is situated.|
### **Response Description**
```json
{
"Name": "SingleValueResponse",
"Description": [
"Represents the SingleValue Response."
],
docs/api/PostWorksheetCellSetValue.md view on Meta::CPAN
### The request parameters of **postWorksheetCellSetValue** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The file name.|
|sheetName|String|Path|The worksheet name.|
|cellName|String|Path|The cell name.|
|value|String|Query|The cell value.|
|type|String|Query|The value type.|
|formula|String|Query|Formula for cell|
|folder|String|Query|The folder where the file is situated.|
|storageName|String|Query|The storage name where the file is situated.|
### **Response Description**
```json
{
"Name": "CellResponse",
"Description": [
"Represents the Cell Response."
],
docs/api/PutWorksheetFormatCondition.md view on Meta::CPAN
### The request parameters of **putWorksheetFormatCondition** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The file name.|
|sheetName|String|Path|The worksheet name.|
|index|Integer|Path|Gets the Conditional Formatting element at the specified index.|
|cellArea|String|Query|Adds a conditional formatted cell range.|
|type|String|Query|Format condition type(CellValue/Expression/ColorScale/DataBar/IconSet/Top10/UniqueValues/DuplicateValues/ContainsText/NotContainsText/BeginsWith/EndsWith/ContainsBlanks/NotContainsBlanks/ContainsErrors/NotContainsErrors/TimePeriod/...
|operatorType|String|Query|Represents the operator type of conditional format and data validation(Between/Equal/GreaterThan/GreaterOrEqual/LessThan/None/NotBetween/NotEqual).|
|formula1|String|Query|The value or expression associated with conditional formatting.|
|formula2|String|Query|The value or expression associated with conditional formatting.|
|folder|String|Query|The folder where the file is situated.|
|storageName|String|Query|The storage name where the file is situated.|
### **Response Description**
```json
{
"Name": "CellsCloudResponse",
"Type": "Class",
"IsAbstract": false,
"Properties": [
docs/api/PutWorksheetFormatConditionCondition.md view on Meta::CPAN
### The request parameters of **putWorksheetFormatConditionCondition** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The file name.|
|sheetName|String|Path|The worksheet name.|
|index|Integer|Path|Gets the Conditional Formatting element at the specified index.|
|type|String|Query|Format condition type(CellValue/Expression/ColorScale/DataBar/IconSet/Top10/UniqueValues/DuplicateValues/ContainsText/NotContainsText/BeginsWith/EndsWith/ContainsBlanks/NotContainsBlanks/ContainsErrors/NotContainsErrors/TimePeriod/...
|operatorType|String|Query|Represents the operator type of conditional format and data validation(Between/Equal/GreaterThan/GreaterOrEqual/LessThan/None/NotBetween/NotEqual).|
|formula1|String|Query|The value or expression associated with conditional formatting.|
|formula2|String|Query|The value or expression associated with conditional formatting.|
|folder|String|Query|The folder where the file is situated.|
|storageName|String|Query|The storage name where the file is situated.|
### **Response Description**
```json
{
"Name": "CellsCloudResponse",
"Type": "Class",
"IsAbstract": false,
"Properties": [
docs/model/CalculationOptions.md view on Meta::CPAN
## Load the model package
```perl
use AsposeCellsCloud::Object::CalculationOptions;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**CalcStackSize** | **int** | Specifies the stack size for calculating cells recursively. |
**IgnoreError** | **boolean** | Indicates whether errors encountered while calculating formulas should be ignored. The error may be unsupported function, external links, etc. The default value is true. |
**PrecisionStrategy** | **string** | Specifies the strategy for processing precision of calculation. |
**Recursive** | **boolean** | Indicates whether calculate the dependent cells recursively when calculating one cell and it depends on other cells. The default value is true. |
**CustomEngine** | **AbstractCalculationEngine** | The custom formula calculation engine to extend the default calculation engine of Aspose.Cells. |
**CalculationMonitor** | **AbstractCalculationMonitor** | The monitor for user to track the progress of formula calculation. |
**LinkedDataSources** | **ARRAY[Workbook]** | Specifies the data sources for external links used in formulas. |
[[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/Cell.md view on Meta::CPAN
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**Name** | **string** | Gets the name of the cell. |
**Row** | **int** | Gets row number (zero based) of the cell. |
**Column** | **int** | Gets column number (zero based) of the cell. |
**Value** | **string** | Gets the value contained in this cell. |
**Type** | **string** | Represents cell value type. |
**Formula** | **string** | Gets or sets a formula of the . |
**IsFormula** | **boolean** | Represents if the specified cell contains formula. |
**IsMerged** | **boolean** | Checks if a cell is part of a merged range or not. |
**IsArrayHeader** | **boolean** | Indicates the cell's formula is and array formula and it is the first cell of the array. |
**IsInArray** | **boolean** | Indicates whether the cell formula is an array formula. |
**IsErrorValue** | **boolean** | Checks if the value of this cell is an error. |
**IsInTable** | **boolean** | Indicates whether this cell is part of table formula. |
**IsStyleSet** | **boolean** | Indicates if the cell's style is set. If return false, it means this cell has a default cell format. |
**HtmlString** | **string** | Gets and sets the html string which contains data and some formats in this cell. |
**Style** | **LinkElement** | This class property represents a style element with the specified XML element name. |
**Worksheet** | **string** | Gets the parent worksheet. |
**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/CellValue.md view on Meta::CPAN
use AsposeCellsCloud::Object::CellValue;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**rowIndex** | **int** | A public integer property called "rowIndex" with both getter and setter. |
**columnIndex** | **int** | |
**type** | **string** | |
**value** | **string** | |
**formula** | **string** | |
**style** | **Style** | |
[[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/CopyOptions.md view on Meta::CPAN
## Load the model package
```perl
use AsposeCellsCloud::Object::CopyOptions;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**ColumnCharacterWidth** | **boolean** | Indicates whether copying column width in unit of characters. |
**CopyInvalidFormulasAsValues** | **boolean** | If the formula is not valid for the dest destination, only copy values. |
**CopyNames** | **boolean** | Indicates whether copying the names. |
**ExtendToAdjacentRange** | **boolean** | Indicates whether extend ranges when copying the range to adjacent range. |
**ReferToDestinationSheet** | **boolean** | When copying the range in the same file and the chart refers to the source sheet, False means the copied chart's data source will not be changed. True means the copied chart's data sou...
**ReferToSheetWithSameName** | **boolean** | In ms excel, when copying formulas which refer to other worksheets while copying a worksheet to another one, the copied formulas should refer to source workbook. However, for some sit...
**CopyTheme** | **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/FormulaSettings.md view on Meta::CPAN
## Load the model package
```perl
use AsposeCellsCloud::Object::FormulaSettings;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**CalculateOnOpen** | **boolean** | Indicates whether the application is required to perform a full calculation when the workbook is opened. |
**CalculateOnSave** | **boolean** | Indicates whether recalculate the workbook before saving the document, when in manual calculation mode. |
**ForceFullCalculation** | **boolean** | Indicates whether calculates all formulas every time when a calculation is triggered. |
**CalculationMode** | **string** | Gets or sets the mode for workbook calculation in ms excel. |
**CalculationId** | **string** | Specifies the version of the calculation engine used to calculate values in the workbook. |
**EnableIterativeCalculation** | **boolean** | Indicates whether enable iterative calculation to resolve circular references. |
**MaxIteration** | **int** | The maximum iterations to resolve a circular reference. |
**MaxChange** | **double** | The maximum change to resolve a circular reference. |
**PrecisionAsDisplayed** | **boolean** | Whether the precision of calculated result be set as they are displayed while calculating formulas |
**EnableCalculationChain** | **boolean** | Whether enable calculation chain for formulas. Default is false. |
**PreservePaddingSpaces** | **boolean** | Indicates whether preserve those spaces and line breaks that are padded between formula tokens while getting and setting formulas. Default value is false. |
[[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/GlobalizationSettings.md view on Meta::CPAN
```perl
use AsposeCellsCloud::Object::GlobalizationSettings;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**ChartSettings** | **ChartGlobalizationSettings** | Gets or sets the globalization settings for Chart. |
**PivotSettings** | **PivotGlobalizationSettings** | Gets or sets the globalization settings for pivot table. |
**ListSeparator** | **string** | Gets the separator for list, parameters of function, ...etc. |
**RowSeparatorOfFormulaArray** | **string** | Gets the separator for rows in array data in formula. |
**ColumnSeparatorOfFormulaArray** | **string** | Gets the separator for the items in array's row data in formula. |
[[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/ListColumn.md view on Meta::CPAN
```perl
use AsposeCellsCloud::Object::ListColumn;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**Name** | **string** | Gets and sets the name of the column. |
**Range** | **Range** | Gets the range of this list column. |
**TotalsCalculation** | **string** | Gets and sets the type of calculation in the Totals row of the list column. |
**Formula** | **string** | Gets and sets the formula of the list column. |
**TotalsRowLabel** | **string** | Gets and sets the display labels of total row. |
[[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/LoadOptions.md view on Meta::CPAN
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**ConvertNumericData** | **string** | This class has a public property named "ConvertNumericData" of type string that can be read from and written to. |
**InterruptMonitor** | **string** | Gets and sets the interrupt monitor. |
**LanguageCode** | **string** | Gets or sets the user interface language of the Workbook version based on CountryCode that has saved the file. |
**LoadDataOptions** | **string** | |
**LoadFormat** | **string** | Gets the load format. |
**OnlyLoadDocumentProperties** | **string** | |
**ParsingFormulaOnOpen** | **string** | Indicates whether parsing the formula when reading the file. |
**Password** | **string** | Gets and set the password of the workbook. |
**Region** | **string** | Gets or sets the system regional settings based on CountryCode at the time the file was loaded. |
**StandardFont** | **string** | Sets the default standard font name |
**StandardFontSize** | **double** | Sets the default standard font size. |
[[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/Name.md view on Meta::CPAN
## Load the model package
```perl
use AsposeCellsCloud::Object::Name;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**Comment** | **string** | Gets and sets the comment of the name. Only applies for Excel 2007. |
**WorksheetIndex** | **int** | Property Summary: WorksheetIndex is an optional integer property marked with the XmlElement attribute "worksheetindex". |
**IsReferred** | **boolean** | Indicates whether this name is referred by other formulas. |
**IsVisible** | **boolean** | Indicates whether the name is visible. |
**R1C1RefersTo** | **string** | Gets or sets a R1C1 reference of the . |
**RefersTo** | **string** | Returns or sets the formula that the name is defined to refer to, beginning with an equal sign. |
**Text** | **string** | Gets the name text of the object. |
**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/Style.md view on Meta::CPAN
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**Font** | **Font** | Gets a object. |
**Name** | **string** | Gets or sets the name of the style. |
**CultureCustom** | **string** | Gets and sets the culture-dependent pattern string for number format. If no number format has been set for this object, null will be returned. If number format is builtin, the pattern string corr...
**Custom** | **string** | Represents the custom number format string of this style object. If the custom number format is not set(For example, the number format is builtin), "" will be returned. |
**BackgroundColor** | **Color** | Gets or sets a style's background color. |
**ForegroundColor** | **Color** | Gets or sets a style's foreground color. |
**IsFormulaHidden** | **boolean** | Represents if the formula will be hidden when the worksheet is protected. |
**IsDateTime** | **boolean** | Indicates whether the number format is a date format. |
**IsTextWrapped** | **boolean** | Gets or sets a value indicating whether the text within a cell is wrapped. |
**IsGradient** | **boolean** | Indicates whether the cell shading is a gradient pattern. |
**IsLocked** | **boolean** | Gets or sets a value indicating whether a cell can be modified or not. |
**IsPercent** | **boolean** | Indicates whether the number format is a percent format. |
**ShrinkToFit** | **boolean** | Represents if text automatically shrinks to fit in the available column width. |
**IndentLevel** | **int** | Represents the indent level for the cell or range. Can only be an integer from 0 to 250. |
**Number** | **int** | Gets or sets the display format of numbers and dates. The formatting patterns are different for different regions. |
**RotationAngle** | **int** | Represents text rotation angle. |
**Pattern** | **string** | Gets or sets the cell background pattern type. |
docs/model/TableTotalRequest.md view on Meta::CPAN
## Load the model package
```perl
use AsposeCellsCloud::Object::TableTotalRequest;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**ListColumnIndex** | **int** | Indicates list column index. |
**TotalsCalculation** | **string** | Indicates totals calculation. |
**CustomFormula** | **string** | Indicates custom formula. |
[[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/WorkbookSettings.md view on Meta::CPAN
```perl
use AsposeCellsCloud::Object::WorkbookSettings;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**AutoCompressPictures** | **boolean** | Specifies a boolean value that indicates the application automatically compressed pictures in the workbook. |
**AutoRecover** | **boolean** | Indicates whether the file is mark for auto-recovery. |
**BuildVersion** | **string** | Specifies the incremental public release of the application. |
**CalcMode** | **string** | It specifies whether to calculate formulas manually, automatically or automatically except for multiple table operations. |
**CalculationId** | **string** | Specifies the version of the calculation engine used to calculate values in the workbook. |
**CheckComptiliblity** | **boolean** | Indicates whether check comptiliblity when saving workbook. Remarks: The default value is true. |
**CheckExcelRestriction** | **boolean** | Whether check restriction of excel file when user modify cells related objects. For example, excel does not allow inputting string value longer than 32K. When you input a value longer th...
**CrashSave** | **boolean** | indicates whether the application last saved the workbook file after a crash. |
**CreateCalcChain** | **boolean** | Whether creates calculated formulas chain. Default is false. |
**DataExtractLoad** | **boolean** | indicates whether the application last opened the workbook for data recovery. |
**Date1904** | **boolean** | Gets or sets a value which represents if the workbook uses the 1904 date system. |
**DisplayDrawingObjects** | **string** | Indicates whether and how to show objects in the workbook. |
**EnableMacros** | **boolean** | Enable macros; |
**FirstVisibleTab** | **int** | Gets or sets the first visible worksheet tab. |
**HidePivotFieldList** | **boolean** | Gets and sets whether hide the field list for the PivotTable. |
**IsDefaultEncrypted** | **boolean** | Indicates whether encrypting the workbook with default password if Structure and Windows of the workbook are locked. |
**IsHidden** | **boolean** | Indicates whether this workbook is hidden. |
**IsHScrollBarVisible** | **boolean** | Gets or sets a value indicating whether the generated spreadsheet will contain a horizontal scroll bar. |
**IsMinimized** | **boolean** | Represents whether the generated spreadsheet will be opened Minimized. |
**IsVScrollBarVisible** | **boolean** | Gets or sets a value indicating whether the generated spreadsheet will contain a vertical scroll bar. |
**Iteration** | **boolean** | Indicates whether enable iterative calculation to resolve circular references. |
**LanguageCode** | **string** | Gets or sets the user interface language of the Workbook version based on CountryCode that has saved the file. |
**MaxChange** | **double** | Returns or sets the maximum number of change to resolve a circular reference. |
**MaxIteration** | **int** | Returns or sets the maximum number of iterations to resolve a circular reference. |
**MemorySetting** | **string** | Gets or sets the memory usage options. The new option will be taken as the default option for newly created worksheets but does not take effect for existing worksheets. |
**NumberDecimalSeparator** | **string** | Gets or sets the decimal separator for formatting/parsing numeric values. Default is the decimal separator of current Region. |
**NumberGroupSeparator** | **string** | Gets or sets the character that separates groups of digits to the left of the decimal in numeric values. Default is the group separator of current Region. |
**ParsingFormulaOnOpen** | **boolean** | Indicates whether parsing the formula when reading the file. |
**PrecisionAsDisplayed** | **boolean** | True if calculations in this workbook will be done using only the precision of the numbers as they're displayed |
**RecalculateBeforeSave** | **boolean** | Indicates whether to recalculate before saving the document. |
**ReCalculateOnOpen** | **boolean** | Indicates whether re-calculate all formulas on opening file. |
**RecommendReadOnly** | **boolean** | Indicates if the Read Only Recommended option is selected. |
**Region** | **string** | Gets or sets the regional settings for workbook. |
**RemovePersonalInformation** | **boolean** | True if personal information can be removed from the specified workbook. |
**RepairLoad** | **boolean** | Indicates whether the application last opened the workbook in safe or repair mode. |
**Shared** | **boolean** | Gets or sets a value that indicates whether the Workbook is shared. |
**SheetTabBarWidth** | **int** | Width of worksheet tab bar (in 1/1000 of window width). |
**ShowTabs** | **boolean** | Get or sets a value whether the Workbook tabs are displayed. |
**UpdateAdjacentCellsBorder** | **boolean** | Indicates whether update adjacent cells' border. |
**UpdateLinksType** | **string** | Gets and sets how updates external links when the workbook is opened. |
**WindowHeight** | **double** | The height of the window, in unit of point. |
docs/model/WorkbookSettings.md view on Meta::CPAN
**GlobalizationSettings** | **GlobalizationSettings** | Gets and sets the globalization settings. |
**Password** | **string** | Represents Workbook file encryption password. |
**WriteProtection** | **WriteProtection** | Provides access to the workbook write protection options. |
**IsEncrypted** | **boolean** | Gets a value that indicates whether a password is required to open this workbook. |
**IsProtected** | **boolean** | Gets a value that indicates whether the structure or window of the Workbook is protected. |
**MaxRow** | **int** | Gets the max row index, zero-based. |
**MaxColumn** | **int** | Gets the max column index, zero-based. |
**SignificantDigits** | **int** | Gets and sets the number of significant digits. The default value is . |
**CheckCompatibility** | **boolean** | Indicates whether check compatibility with earlier versions when saving workbook. |
**PaperSize** | **string** | Gets and sets the default print paper size. |
**MaxRowsOfSharedFormula** | **int** | Gets and sets the max row number of shared formula. |
**Compliance** | **string** | Specifies the OOXML version for the output document. The default value is Ecma376_2006. |
**QuotePrefixToStyle** | **boolean** | Indicates whether setting property when entering the string value(which starts with single quote mark ) to the cell |
**FormulaSettings** | **FormulaSettings** | Gets the settings for formula-related features. |
**ForceFullCalculate** | **boolean** | Fully calculates every time when a calculation is triggered. |
[[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/WorksheetDataStatistics.md view on Meta::CPAN
------------ | ------------- | ------------- | -------------
**Name** | **string** | Represents worksheet name. |
**ChartsCount** | **int** | Represents chart number. |
**TablesCount** | **int** | Represents list object number. |
**PivotTablesCount** | **int** | Represents pivot table number. |
**ShapesCount** | **int** | Represents shape number. |
**HyperlinksCount** | **int** | Represents shape number. |
**QueryTablesCount** | **int** | Represents hyperlink number. |
**CellsCount** | **int** | Represents query table number. |
**CellsCountInTable** | **int** | Represents cell number. |
**CellsCountIsFormula** | **int** | Represents formula number. |
[[Back to Model list]](../README.md#documentation-for-models) [[Back to API list]](../README.md#documentation-for-api-endpoints) [[Back to README]](../README.md)
lib/AsposeCellsCloud/CellsApi.pm view on Meta::CPAN
#
# PostWorksheetCellSetValueRequest
#
# Set cell value using cell name in the worksheet.
#
# @name string (required) The file name.
# @sheetName string (required) The worksheet name.
# @cellName string (required) The cell name.
# @value string The cell value.
# @type string The value type.
# @formula string Formula for cell
# @folder string The folder where the file is situated.
# @storageName string The storage name where the file is situated.
#
{
my $params = {
'request' =>{
data_type => 'PostWorksheetCellSetValueRequest',
description => 'PostWorksheetCellSetValue Request.',
required => '0',
}
lib/AsposeCellsCloud/CellsApi.pm view on Meta::CPAN
if (!$response) {
return;
}
my $_response_object = $self->{api_client}->deserialize('CellsCloudResponse', $response);
return $_response_object;
}
#
# PostCellCalculateRequest
#
# Calculate cell formula in the worksheet.
#
# @name string (required) The file name.
# @sheetName string (required) The worksheet name.
# @cellName string (required) The cell name.
# @options CalculationOptions Calculation Options
# @folder string The folder where the file is situated.
# @storageName string The storage name where the file is situated.
#
{
my $params = {
'request' =>{
data_type => 'PostCellCalculateRequest',
description => 'PostCellCalculate Request.',
required => '0',
}
};
__PACKAGE__->method_documentation->{ 'post_cell_calculate' } = {
summary => 'Calculate cell formula in the worksheet.',
params => $params,
returns => 'CellsCloudResponse',
};
}
#
# @return CellsCloudResponse
#
sub post_cell_calculate{
my ($self, %args) = @_;
my $request = $args{'request'};
lib/AsposeCellsCloud/CellsApi.pm view on Meta::CPAN
# PutWorksheetFormatConditionRequest
#
# Add a format condition in the worksheet.
#
# @name string (required) The file name.
# @sheetName string (required) The worksheet name.
# @index int (required) Gets the Conditional Formatting element at the specified index.
# @cellArea string (required) Adds a conditional formatted cell range.
# @type string (required) Format condition type(CellValue/Expression/ColorScale/DataBar/IconSet/Top10/UniqueValues/DuplicateValues/ContainsText/NotContainsText/BeginsWith/EndsWith/ContainsBlanks/NotContainsBlanks/ContainsErrors/NotContainsErrors/Ti...
# @operatorType string (required) Represents the operator type of conditional format and data validation(Between/Equal/GreaterThan/GreaterOrEqual/LessThan/None/NotBetween/NotEqual).
# @formula1 string (required) The value or expression associated with conditional formatting.
# @formula2 string (required) The value or expression associated with conditional formatting.
# @folder string The folder where the file is situated.
# @storageName string The storage name where the file is situated.
#
{
my $params = {
'request' =>{
data_type => 'PutWorksheetFormatConditionRequest',
description => 'PutWorksheetFormatCondition Request.',
required => '0',
}
lib/AsposeCellsCloud/CellsApi.pm view on Meta::CPAN
#
# PutWorksheetFormatConditionConditionRequest
#
# Add a condition for the format condition in the worksheet.
#
# @name string (required) The file name.
# @sheetName string (required) The worksheet name.
# @index int (required) Gets the Conditional Formatting element at the specified index.
# @type string (required) Format condition type(CellValue/Expression/ColorScale/DataBar/IconSet/Top10/UniqueValues/DuplicateValues/ContainsText/NotContainsText/BeginsWith/EndsWith/ContainsBlanks/NotContainsBlanks/ContainsErrors/NotContainsErrors/Ti...
# @operatorType string (required) Represents the operator type of conditional format and data validation(Between/Equal/GreaterThan/GreaterOrEqual/LessThan/None/NotBetween/NotEqual).
# @formula1 string (required) The value or expression associated with conditional formatting.
# @formula2 string (required) The value or expression associated with conditional formatting.
# @folder string The folder where the file is situated.
# @storageName string The storage name where the file is situated.
#
{
my $params = {
'request' =>{
data_type => 'PutWorksheetFormatConditionConditionRequest',
description => 'PutWorksheetFormatConditionCondition Request.',
required => '0',
}
lib/AsposeCellsCloud/CellsApi.pm view on Meta::CPAN
}
my $_response_object = $self->{api_client}->deserialize('CheckedExternalReferenceResponse', $response);
return $_response_object;
}
#
# CheckWorkbookFormulaErrorsRequest
#
#
#
# @formulaErrorOptions CheckFormulaErrorOptions (required)
#
{
my $params = {
'request' =>{
data_type => 'CheckWorkbookFormulaErrorsRequest',
description => 'CheckWorkbookFormulaErrors Request.',
required => '0',
}
};
__PACKAGE__->method_documentation->{ 'check_workbook_formula_errors' } = {
summary => '',
params => $params,
returns => 'CheckedFormulaErrorsResponse',
};
}
#
# @return CheckedFormulaErrorsResponse
#
sub check_workbook_formula_errors{
my ($self, %args) = @_;
my $request = $args{'request'};
my $response = $request->run_http_request('client' => $self->{api_client} );
if (!$response) {
return;
}
my $_response_object = $self->{api_client}->deserialize('CheckedFormulaErrorsResponse', $response);
return $_response_object;
}
lib/AsposeCellsCloud/CellsApi.pm view on Meta::CPAN
if (!$response) {
return;
}
my $_response_object = $self->{api_client}->deserialize('SplitResultResponse', $response);
return $_response_object;
}
#
# PostWorkbookCalculateFormulaRequest
#
# Calculate all formulas in the workbook.
#
# @name string (required) The file name.
# @options CalculationOptions CalculationOptions Calculation Options.
# @ignoreError boolean ignore Error.
# @folder string The folder where the file is situated.
# @storageName string The storage name where the file is situated.
#
{
my $params = {
'request' =>{
data_type => 'PostWorkbookCalculateFormulaRequest',
description => 'PostWorkbookCalculateFormula Request.',
required => '0',
}
};
__PACKAGE__->method_documentation->{ 'post_workbook_calculate_formula' } = {
summary => 'Calculate all formulas in the workbook.',
params => $params,
returns => 'CellsCloudResponse',
};
}
#
# @return CellsCloudResponse
#
sub post_workbook_calculate_formula{
my ($self, %args) = @_;
my $request = $args{'request'};
my $response = $request->run_http_request('client' => $self->{api_client} );
if (!$response) {
return;
}
my $_response_object = $self->{api_client}->deserialize('CellsCloudResponse', $response);
return $_response_object;
}
lib/AsposeCellsCloud/CellsApi.pm view on Meta::CPAN
if (!$response) {
return;
}
my $_response_object = $self->{api_client}->deserialize('MergedCellResponse', $response);
return $_response_object;
}
#
# GetWorksheetCalculateFormulaRequest
#
# Calculate formula in the worksheet.
#
# @name string (required) The file name.
# @sheetName string (required) The worksheet name.
# @formula string (required) The formula.
# @folder string The folder where the file is situated.
# @storageName string The storage name where the file is situated.
#
{
my $params = {
'request' =>{
data_type => 'GetWorksheetCalculateFormulaRequest',
description => 'GetWorksheetCalculateFormula Request.',
required => '0',
}
};
__PACKAGE__->method_documentation->{ 'get_worksheet_calculate_formula' } = {
summary => 'Calculate formula in the worksheet.',
params => $params,
returns => 'SingleValueResponse',
};
}
#
# @return SingleValueResponse
#
sub get_worksheet_calculate_formula{
my ($self, %args) = @_;
my $request = $args{'request'};
my $response = $request->run_http_request('client' => $self->{api_client} );
if (!$response) {
return;
}
my $_response_object = $self->{api_client}->deserialize('SingleValueResponse', $response);
return $_response_object;
}
#
# PostWorksheetCalculateFormulaRequest
#
# Calculate formula in the worksheet.
#
# @name string (required) The file name.
# @sheetName string (required) Worksheet name.
# @formula string (required) The formula.
# @folder string The folder where the file is situated.
# @storageName string The storage name where the file is situated.
#
{
my $params = {
'request' =>{
data_type => 'PostWorksheetCalculateFormulaRequest',
description => 'PostWorksheetCalculateFormula Request.',
required => '0',
}
};
__PACKAGE__->method_documentation->{ 'post_worksheet_calculate_formula' } = {
summary => 'Calculate formula in the worksheet.',
params => $params,
returns => 'SingleValueResponse',
};
}
#
# @return SingleValueResponse
#
sub post_worksheet_calculate_formula{
my ($self, %args) = @_;
my $request = $args{'request'};
my $response = $request->run_http_request('client' => $self->{api_client} );
if (!$response) {
return;
}
my $_response_object = $self->{api_client}->deserialize('SingleValueResponse', $response);
return $_response_object;
}
lib/AsposeCellsCloud/Object/AbstractCalculationMonitor.pm view on Meta::CPAN
return DateTime->from_epoch(epoch => str2time($data));
} elsif ( grep( /^$type$/, ('int', 'double', 'string', 'boolean'))) {
return $data;
} else { # hash(model)
my $_instance = eval "AsposeCellsCloud::Object::$type->new()";
return $_instance->from_hash($data);
}
}
__PACKAGE__->class_documentation({description => 'Monitor for user to track the progress of formula calculation. ',
class => 'AbstractCalculationMonitor',
required => [], # TODO
} );
__PACKAGE__->method_documentation({
'original_value' => {
datatype => 'string',
base_name => 'OriginalValue',
description => 'Gets the old value of the calculated cell. Should be used only in and . ',
lib/AsposeCellsCloud/Object/CalculationOptions.pm view on Meta::CPAN
'calc_stack_size' => {
datatype => 'int',
base_name => 'CalcStackSize',
description => 'Specifies the stack size for calculating cells recursively. ',
format => '',
read_only => '',
},
'ignore_error' => {
datatype => 'boolean',
base_name => 'IgnoreError',
description => 'Indicates whether errors encountered while calculating formulas should be ignored. The error may be unsupported function, external links, etc. The default value is true. ',
format => '',
read_only => '',
},
'precision_strategy' => {
datatype => 'string',
base_name => 'PrecisionStrategy',
description => 'Specifies the strategy for processing precision of calculation. ',
format => '',
read_only => '',
},
'recursive' => {
datatype => 'boolean',
base_name => 'Recursive',
description => 'Indicates whether calculate the dependent cells recursively when calculating one cell and it depends on other cells. The default value is true. ',
format => '',
read_only => '',
},
'custom_engine' => {
datatype => 'AbstractCalculationEngine',
base_name => 'CustomEngine',
description => 'The custom formula calculation engine to extend the default calculation engine of Aspose.Cells. ',
format => '',
read_only => '',
},
'calculation_monitor' => {
datatype => 'AbstractCalculationMonitor',
base_name => 'CalculationMonitor',
description => 'The monitor for user to track the progress of formula calculation. ',
format => '',
read_only => '',
},
'linked_data_sources' => {
datatype => 'ARRAY[Workbook]',
base_name => 'LinkedDataSources',
description => 'Specifies the data sources for external links used in formulas. ',
format => '',
read_only => '',
},
});
__PACKAGE__->swagger_types( {
'calc_stack_size' => 'int',
'ignore_error' => 'boolean',
'precision_strategy' => 'string',
'recursive' => 'boolean',
lib/AsposeCellsCloud/Object/Cell.pm view on Meta::CPAN
format => '',
read_only => '',
},
'type' => {
datatype => 'string',
base_name => 'Type',
description => 'Represents cell value type.',
format => '',
read_only => '',
},
'formula' => {
datatype => 'string',
base_name => 'Formula',
description => 'Gets or sets a formula of the .',
format => '',
read_only => '',
},
'is_formula' => {
datatype => 'boolean',
base_name => 'IsFormula',
description => 'Represents if the specified cell contains formula.',
format => '',
read_only => '',
},
'is_merged' => {
datatype => 'boolean',
base_name => 'IsMerged',
description => 'Checks if a cell is part of a merged range or not.',
format => '',
read_only => '',
},
'is_array_header' => {
datatype => 'boolean',
base_name => 'IsArrayHeader',
description => 'Indicates the cell`s formula is and array formula and it is the first cell of the array.',
format => '',
read_only => '',
},
'is_in_array' => {
datatype => 'boolean',
base_name => 'IsInArray',
description => 'Indicates whether the cell formula is an array formula.',
format => '',
read_only => '',
},
'is_error_value' => {
datatype => 'boolean',
base_name => 'IsErrorValue',
description => 'Checks if the value of this cell is an error.',
format => '',
read_only => '',
},
'is_in_table' => {
datatype => 'boolean',
base_name => 'IsInTable',
description => 'Indicates whether this cell is part of table formula.',
format => '',
read_only => '',
},
'is_style_set' => {
datatype => 'boolean',
base_name => 'IsStyleSet',
description => 'Indicates if the cell`s style is set. If return false, it means this cell has a default cell format.',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Object/Cell.pm view on Meta::CPAN
read_only => '',
},
});
__PACKAGE__->swagger_types( {
'name' => 'string',
'row' => 'int',
'column' => 'int',
'value' => 'string',
'type' => 'string',
'formula' => 'string',
'is_formula' => 'boolean',
'is_merged' => 'boolean',
'is_array_header' => 'boolean',
'is_in_array' => 'boolean',
'is_error_value' => 'boolean',
'is_in_table' => 'boolean',
'is_style_set' => 'boolean',
'html_string' => 'string',
'style' => 'LinkElement',
'worksheet' => 'string',
'link' => 'Link'
} );
__PACKAGE__->attribute_map( {
'name' => 'Name',
'row' => 'Row',
'column' => 'Column',
'value' => 'Value',
'type' => 'Type',
'formula' => 'Formula',
'is_formula' => 'IsFormula',
'is_merged' => 'IsMerged',
'is_array_header' => 'IsArrayHeader',
'is_in_array' => 'IsInArray',
'is_error_value' => 'IsErrorValue',
'is_in_table' => 'IsInTable',
'is_style_set' => 'IsStyleSet',
'html_string' => 'HtmlString',
'style' => 'Style',
'worksheet' => 'Worksheet',
'link' => 'link'
lib/AsposeCellsCloud/Object/CellValue.pm view on Meta::CPAN
format => '',
read_only => '',
},
'value' => {
datatype => 'string',
base_name => 'value',
description => '',
format => '',
read_only => '',
},
'formula' => {
datatype => 'string',
base_name => 'formula',
description => '',
format => '',
read_only => '',
},
'style' => {
datatype => 'Style',
base_name => 'style',
description => '',
format => '',
read_only => '',
},
});
__PACKAGE__->swagger_types( {
'row_index' => 'int',
'column_index' => 'int',
'type' => 'string',
'value' => 'string',
'formula' => 'string',
'style' => 'Style'
} );
__PACKAGE__->attribute_map( {
'row_index' => 'rowIndex',
'column_index' => 'columnIndex',
'type' => 'type',
'value' => 'value',
'formula' => 'formula',
'style' => 'style'
} );
__PACKAGE__->mk_accessors(keys %{__PACKAGE__->attribute_map});
1;
lib/AsposeCellsCloud/Object/CheckedExternalReferenceResponse.pm view on Meta::CPAN
format => '',
read_only => '',
},
'reference_other_worksheet' => {
datatype => 'boolean',
base_name => 'ReferenceOtherWorksheet',
description => '',
format => '',
read_only => '',
},
'formulas' => {
datatype => 'ARRAY[string]',
base_name => 'Formulas',
description => '',
format => '',
read_only => '',
},
'code' => {
datatype => 'int',
base_name => 'Code',
description => '',
lib/AsposeCellsCloud/Object/CheckedExternalReferenceResponse.pm view on Meta::CPAN
base_name => 'Status',
description => '',
format => '',
read_only => '',
},
});
__PACKAGE__->swagger_types( {
'reference_other_workbook' => 'boolean',
'reference_other_worksheet' => 'boolean',
'formulas' => 'ARRAY[string]',
'code' => 'int',
'status' => 'string'
} );
__PACKAGE__->attribute_map( {
'reference_other_workbook' => 'ReferenceOtherWorkbook',
'reference_other_worksheet' => 'ReferenceOtherWorksheet',
'formulas' => 'Formulas',
'code' => 'Code',
'status' => 'Status'
} );
__PACKAGE__->mk_accessors(keys %{__PACKAGE__->attribute_map});
1;
lib/AsposeCellsCloud/Object/CheckedFormulaErrorsResponse.pm view on Meta::CPAN
}
__PACKAGE__->class_documentation({description => '',
class => 'CheckedFormulaErrorsResponse',
required => [], # TODO
} );
__PACKAGE__->method_documentation({
'is_formulas_errors' => {
datatype => 'boolean',
base_name => 'IsFormulasErrors',
description => '',
format => '',
read_only => '',
},
'formulas_errors' => {
datatype => 'ARRAY[string]',
base_name => 'FormulasErrors',
description => '',
format => '',
read_only => '',
},
'code' => {
datatype => 'int',
base_name => 'Code',
description => '',
lib/AsposeCellsCloud/Object/CheckedFormulaErrorsResponse.pm view on Meta::CPAN
'status' => {
datatype => 'string',
base_name => 'Status',
description => '',
format => '',
read_only => '',
},
});
__PACKAGE__->swagger_types( {
'is_formulas_errors' => 'boolean',
'formulas_errors' => 'ARRAY[string]',
'code' => 'int',
'status' => 'string'
} );
__PACKAGE__->attribute_map( {
'is_formulas_errors' => 'IsFormulasErrors',
'formulas_errors' => 'FormulasErrors',
'code' => 'Code',
'status' => 'Status'
} );
__PACKAGE__->mk_accessors(keys %{__PACKAGE__->attribute_map});
1;
lib/AsposeCellsCloud/Object/CopyOptions.pm view on Meta::CPAN
__PACKAGE__->method_documentation({
'column_character_width' => {
datatype => 'boolean',
base_name => 'ColumnCharacterWidth',
description => 'Indicates whether copying column width in unit of characters. ',
format => '',
read_only => '',
},
'copy_invalid_formulas_as_values' => {
datatype => 'boolean',
base_name => 'CopyInvalidFormulasAsValues',
description => 'If the formula is not valid for the dest destination, only copy values. ',
format => '',
read_only => '',
},
'copy_names' => {
datatype => 'boolean',
base_name => 'CopyNames',
description => 'Indicates whether copying the names. ',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Object/CopyOptions.pm view on Meta::CPAN
'refer_to_destination_sheet' => {
datatype => 'boolean',
base_name => 'ReferToDestinationSheet',
description => 'When copying the range in the same file and the chart refers to the source sheet, False means the copied chart`s data source will not be changed. True means the copied chart`s data source refers to the dest...
format => '',
read_only => '',
},
'refer_to_sheet_with_same_name' => {
datatype => 'boolean',
base_name => 'ReferToSheetWithSameName',
description => 'In ms excel, when copying formulas which refer to other worksheets while copying a worksheet to another one, the copied formulas should refer to source workbook. However, for some situations user may need t...
format => '',
read_only => '',
},
'copy_theme' => {
datatype => 'boolean',
base_name => 'CopyTheme',
description => '',
format => '',
read_only => '',
},
});
__PACKAGE__->swagger_types( {
'column_character_width' => 'boolean',
'copy_invalid_formulas_as_values' => 'boolean',
'copy_names' => 'boolean',
'extend_to_adjacent_range' => 'boolean',
'refer_to_destination_sheet' => 'boolean',
'refer_to_sheet_with_same_name' => 'boolean',
'copy_theme' => 'boolean'
} );
__PACKAGE__->attribute_map( {
'column_character_width' => 'ColumnCharacterWidth',
'copy_invalid_formulas_as_values' => 'CopyInvalidFormulasAsValues',
'copy_names' => 'CopyNames',
'extend_to_adjacent_range' => 'ExtendToAdjacentRange',
'refer_to_destination_sheet' => 'ReferToDestinationSheet',
'refer_to_sheet_with_same_name' => 'ReferToSheetWithSameName',
'copy_theme' => 'CopyTheme'
} );
__PACKAGE__->mk_accessors(keys %{__PACKAGE__->attribute_map});
( run in 1.094 second using v1.01-cache-2.11-cpan-3cd7ad12f66 )