AsposeCellsCloud-CellsApi
view release on metacpan or search on metacpan
close($fh);
```
## Support file format
| **Format** | **Description** ...
| :---------------------------------------------------------------- | :---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ...
| [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 2.332 seconds using v1.01-cache-2.11-cpan-97f6503c9c8 )