AsposeCellsCloud-CellsApi

 view release on metacpan or  search on metacpan

README.md  view on Meta::CPAN

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.| |√|

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 => '',
     		},