AsposeCellsCloud-CellsApi
view release on metacpan or search on metacpan
close($fh);
```
## 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.|√|√|
|[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).|√|√|
|[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|√|√|
|[DIF](https://docs.fileformat.com/spreadsheet/dif/)|Data Interchange Format.|Â |√|
|[PDF](https://docs.fileformat.com/pdf/)|Adobe Portable Document Format.|Â |√|
docs/api/PutAddNewWorksheet.md view on Meta::CPAN
### **Function Description**
PageTitle: Add a new worksheet in the workbook.PageDescription: Aspose.Cells Cloud provides robust support for adding a new worksheet in the workbook, a process known for its intricacy.HeadTitle: Add a new worksheet in the workbook.HeadSummary: Aspos...
### The request parameters of **putAddNewWorksheet** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The file name.|
|sheetName|String|Path|The new sheet name.|
|position|Integer|Query|The new sheet position.|
|sheettype|String|Query|Specifies the worksheet type(VB/Worksheet/Chart/BIFF4Macro/InternationalMacro/Other/Dialog).|
|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/PutInsertNewWorksheet.md view on Meta::CPAN
### **Function Description**
PageTitle: Insert a new worksheet in the workbook.PageDescription: Aspose.Cells Cloud provides robust support for inserting a new worksheet in the workbook, a process known for its intricacy.HeadTitle: Insert a new worksheet in the workbook.HeadSumma...
### The request parameters of **putInsertNewWorksheet** API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|name|String|Path|The file name.|
|sheetName|String|Query|The worksheet name.|
|index|Integer|Query||
|sheettype|String|Query|Specifies the worksheet type(VB/Worksheet/Chart/BIFF4Macro/InternationalMacro/Other/Dialog).|
|newsheetname|String|Query||
|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,
docs/model/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.410 second using v1.01-cache-2.11-cpan-beeb90c9504 )