AsposeCellsCloud-CellsApi
view release on metacpan or search on metacpan
| New API for Comprehensive Formula Error Checks in Excel Workbooks | New Feature |
| New API for External Reference Checks in Excel Workbooks | New Feature |
## Support file format
|**Format**|**Description**|**Load**|**Save**|
| :- | :- | :- | :- |
|[XLS](https://docs.fileformat.com/spreadsheet/xls/)|Excel 95/5.0 - 2003 Workbook.|√|√|
|[XLSX](https://docs.fileformat.com/spreadsheet/xlsx/)|Office Open XML SpreadsheetML Workbook or template file, with or without macros.|√|√|
|[XLSB](https://docs.fileformat.com/spreadsheet/xlsb/)|Excel Binary Workbook.|√|√|
|[XLSM](https://docs.fileformat.com/spreadsheet/xlsm/)|Excel Macro-Enabled Workbook.|√|√|
|[XLT](https://docs.fileformat.com/spreadsheet/xlt/)|Excel 97 - Excel 2003 Template.|√|√|
|[XLTX](https://docs.fileformat.com/spreadsheet/xltx/)|Excel Template.|√|√|
|[XLTM](https://docs.fileformat.com/spreadsheet/xltm/)|Excel Macro-Enabled Template.|√|√|
|[XLAM](https://docs.fileformat.com/spreadsheet/xlam/)|An Excel Macro-Enabled Add-In file that's used to add new functions to Excel.|Â |√|
|[CSV](https://docs.fileformat.com/spreadsheet/csv/)|CSV (Comma Separated Value) file.|√|√|
|[TSV](https://docs.fileformat.com/spreadsheet/tsv/)|TSV (Tab-separated values) file.|√|√|
|TabDelimited|Tab-delimited text file, same with TSV file.|√|√|
|[TXT](https://docs.fileformat.com/word-processing/txt/)|Delimited plain text file.|√|√|
|[HTML](https://docs.fileformat.com/web/html/)|HTML format.|√|√|
|[MHTML](https://docs.fileformat.com/web/mhtml/)|MHTML file.|√|√|
|[ODS](https://docs.fileformat.com/spreadsheet/ods/)|ODS (OpenDocument Spreadsheet).|√|√|
|SpreadsheetML|Excel 2003 XML file.|√|√|
|[Numbers](https://docs.fileformat.com/spreadsheet/numbers/)|The document is created by Apple's "Numbers" application which forms part of Apple's iWork office suite, a set of applications which run on the Mac OS X and iOS operating systems.|√||...
|[JSON](https://docs.fileformat.com/web/json/)|JavaScript Object Notation|√|√|
docs/PutAddNewWorksheetRequest.md view on Meta::CPAN
```perl
use AsposeCellsCloud::Request::PutAddNewWorksheet;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**name** | **string** | The file name. |
**sheet_name** | **string** | The new sheet name. |
**position** | **int** | The new sheet position. |
**sheettype** | **string** | Specifies the worksheet type(VB/Worksheet/Chart/BIFF4Macro/InternationalMacro/Other/Dialog). |
**folder** | **string** | The folder where the file is situated. |
**storage_name** | **string** | The storage name where the file is situated. |
[[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/PutInsertNewWorksheetRequest.md view on Meta::CPAN
```perl
use AsposeCellsCloud::Request::PutInsertNewWorksheet;
```
## Properties
Name | Type | Description | Notes
------------ | ------------- | ------------- | -------------
**name** | **string** | The file name. |
**sheet_name** | **string** | The worksheet name. |
**index** | **int** | |
**sheettype** | **string** | Specifies the worksheet type(VB/Worksheet/Chart/BIFF4Macro/InternationalMacro/Other/Dialog). |
**newsheetname** | **string** | |
**folder** | **string** | The folder where the file is situated. |
**storage_name** | **string** | The storage name where the file is situated. |
[[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/WorkbookSettings.md view on Meta::CPAN
**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. |
lib/AsposeCellsCloud/CellsApi.pm view on Meta::CPAN
}
#
# PutInsertNewWorksheetRequest
#
# Insert a new worksheet in the workbook.
#
# @name string (required) The file name.
# @sheetName string (required) The worksheet name.
# @index int (required)
# @sheettype string (required) Specifies the worksheet type(VB/Worksheet/Chart/BIFF4Macro/InternationalMacro/Other/Dialog).
# @newsheetname string
# @folder string The folder where the file is situated.
# @storageName string The storage name where the file is situated.
#
{
my $params = {
'request' =>{
data_type => 'PutInsertNewWorksheetRequest',
description => 'PutInsertNewWorksheet Request.',
required => '0',
lib/AsposeCellsCloud/CellsApi.pm view on Meta::CPAN
}
#
# PutAddNewWorksheetRequest
#
# Add a new worksheet in the workbook.
#
# @name string (required) The file name.
# @sheetName string (required) The new sheet name.
# @position int The new sheet position.
# @sheettype string Specifies the worksheet type(VB/Worksheet/Chart/BIFF4Macro/InternationalMacro/Other/Dialog).
# @folder string The folder where the file is situated.
# @storageName string The storage name where the file is situated.
#
{
my $params = {
'request' =>{
data_type => 'PutAddNewWorksheetRequest',
description => 'PutAddNewWorksheet Request.',
required => '0',
}
lib/AsposeCellsCloud/Object/WorkbookSettings.pm view on Meta::CPAN
},
'display_drawing_objects' => {
datatype => 'string',
base_name => 'DisplayDrawingObjects',
description => 'Indicates whether and how to show objects in the workbook. ',
format => '',
read_only => '',
},
'enable_macros' => {
datatype => 'boolean',
base_name => 'EnableMacros',
description => 'Enable macros; ',
format => '',
read_only => '',
},
'first_visible_tab' => {
datatype => 'int',
base_name => 'FirstVisibleTab',
description => 'Gets or sets the first visible worksheet tab. ',
format => '',
read_only => '',
lib/AsposeCellsCloud/Object/WorkbookSettings.pm view on Meta::CPAN
'build_version' => 'BuildVersion',
'calc_mode' => 'CalcMode',
'calculation_id' => 'CalculationId',
'check_comptiliblity' => 'CheckComptiliblity',
'check_excel_restriction' => 'CheckExcelRestriction',
'crash_save' => 'CrashSave',
'create_calc_chain' => 'CreateCalcChain',
'data_extract_load' => 'DataExtractLoad',
'date1904' => 'Date1904',
'display_drawing_objects' => 'DisplayDrawingObjects',
'enable_macros' => 'EnableMacros',
'first_visible_tab' => 'FirstVisibleTab',
'hide_pivot_field_list' => 'HidePivotFieldList',
'is_default_encrypted' => 'IsDefaultEncrypted',
'is_hidden' => 'IsHidden',
'is_h_scroll_bar_visible' => 'IsHScrollBarVisible',
'is_minimized' => 'IsMinimized',
'is_v_scroll_bar_visible' => 'IsVScrollBarVisible',
'iteration' => 'Iteration',
'language_code' => 'LanguageCode',
'max_change' => 'MaxChange',
lib/AsposeCellsCloud/Request/PutAddNewWorksheetRequest.pm view on Meta::CPAN
}
return $self;
}
# Run Operation Request
# PutAddNewWorksheetRequest.name : The file name. ,
# PutAddNewWorksheetRequest.sheetName : The new sheet name. ,
# PutAddNewWorksheetRequest.position : The new sheet position. ,
# PutAddNewWorksheetRequest.sheettype : Specifies the worksheet type(VB/Worksheet/Chart/BIFF4Macro/InternationalMacro/Other/Dialog). ,
# PutAddNewWorksheetRequest.folder : The folder where the file is situated. ,
# PutAddNewWorksheetRequest.storageName : The storage name where the file is situated.
{
my $params = {
'client' =>{
data_type => 'ApiClient',
description => 'API Client.',
required => '0',
}
lib/AsposeCellsCloud/Request/PutAddNewWorksheetRequest.pm view on Meta::CPAN
'position' => {
datatype => 'int',
base_name => 'position',
description => 'The new sheet position.',
format => '',
read_only => '',
},
'sheettype' => {
datatype => 'string',
base_name => 'sheettype',
description => 'Specifies the worksheet type(VB/Worksheet/Chart/BIFF4Macro/InternationalMacro/Other/Dialog).',
format => '',
read_only => '',
},
'folder' => {
datatype => 'string',
base_name => 'folder',
description => 'The folder where the file is situated.',
format => '',
read_only => '',
},
lib/AsposeCellsCloud/Request/PutInsertNewWorksheetRequest.pm view on Meta::CPAN
}
return $self;
}
# Run Operation Request
# PutInsertNewWorksheetRequest.name : The file name. ,
# PutInsertNewWorksheetRequest.sheetName : The worksheet name. ,
# PutInsertNewWorksheetRequest.index : ,
# PutInsertNewWorksheetRequest.sheettype : Specifies the worksheet type(VB/Worksheet/Chart/BIFF4Macro/InternationalMacro/Other/Dialog). ,
# PutInsertNewWorksheetRequest.newsheetname : ,
# PutInsertNewWorksheetRequest.folder : The folder where the file is situated. ,
# PutInsertNewWorksheetRequest.storageName : The storage name where the file is situated.
{
my $params = {
'client' =>{
data_type => 'ApiClient',
description => 'API Client.',
required => '0',
lib/AsposeCellsCloud/Request/PutInsertNewWorksheetRequest.pm view on Meta::CPAN
'index' => {
datatype => 'int',
base_name => 'index',
description => '',
format => '',
read_only => '',
},
'sheettype' => {
datatype => 'string',
base_name => 'sheettype',
description => 'Specifies the worksheet type(VB/Worksheet/Chart/BIFF4Macro/InternationalMacro/Other/Dialog).',
format => '',
read_only => '',
},
'newsheetname' => {
datatype => 'string',
base_name => 'newsheetname',
description => '',
format => '',
read_only => '',
},
( run in 0.590 second using v1.01-cache-2.11-cpan-49f99fa48dc )